Community Profile

# xander fong

Active since 2015

#### Content Feed

View by

Question

Find three largest and smallest values in column of table
Hello, so I have a 1500x15 table, in which one column represents profits for that asset. I would like to know how to code to ret...

7 years ago | 2 answers | 0

### 2

Question

How to plot Cell Array full of doubles.
Hello, I have a 257x1 cell array in which every cell contains a 1x1 double with a number 1-5 I would like to plot this against ...

7 years ago | 1 answer | 0

### 1

Question

Divide column 17 of table by 365
Hello, I have a 1500x15 table, how do I divide every element in the 15th column by 365? Or, how do I create a new column which i...

7 years ago | 2 answers | 0

### 2

Question

How to Unnest Nested cell arrays
Hello, I have a 17x300 cell array, some of which contain text and numbers. However, the 17th column is filled with 1x1 cell arra...

7 years ago | 1 answer | 0

### 1

Question

How to Create new column in table with words in each cell
I have a 40x1 cell array in which each cell contains a 15x300 table. How do I add a 16th column to each table where every cell i...

7 years ago | 1 answer | 0

### 1

Question

Create One large containers.map from multiple maps
Hello, So i created a file of 50 or so risk maps using the for loop: for i=1:numel(mdata) mmap{i}=containers.Map(mdata{i}.TagL...

7 years ago | 1 answer | 0

### 1

Question

Replace NaN's in table with zero
Hello, I have a 1501x7 table called 'x' and there appears to be NaN's in the fourth and sixth column called "Age" and "height". ...

7 years ago | 10 answers | 1

### 10

Question

creating new column using containers.Map, skip to next row if key doesn't exist??????
Hello, so I have a containers.Map that i am trying to use to produce a second column in a 1501x1 table called "x" and the column...

7 years ago | 1 answer | 0

### 1

Question

Trying to create new column which is col1/col2, but function explodes because col 1 and 2 are sometimes 0 or NAN. How do I make the function ignore those?
Hello, I have a large data table, 1501x15. I'm trying to create a 16th column which is equal to two columns divided by each othe...

7 years ago | 1 answer | 0

### 1

Question

More X ticks for subplots
Hello, I have a figure with 10 subplots on them. The x axis is made from a matrix is Datetime format. However,there are only two...

7 years ago | 1 answer | 0

### 1

Question

Using a containers.Map to find values
Hello, so I have a 35x1 cell array that contains a table of data for every day. The cell array looks like "[1501x6 table, 1501x6...

7 years ago | 1 answer | 0

### 1

Question

Containers.Map how to set keys and values
Hello, so I want to create a Containers.Map. However, I am unsure of how to create it as the data that I want to use as key valu...

7 years ago | 1 answer | 0

### 1

Question

How to delete workspace empty variables
Hello, I have a script that creates tons of variables in my workspace. However, some of them are worthless. For example, one w...

7 years ago | 1 answer | 0

### 1

Question

How to automatically delete empty cell arrays generated from a script
Hey, so I have a script that filters through a large excel spreadsheet and sorts data based on criteria. It returns around 17 f...

7 years ago | 1 answer | 0

### 1

Question

How to change [jul15,jul16,jul17] to [7.15,7.16,7.17]?
Hello, so I have a vertical array of imported excel data that are in the format "Jul15, Jul16, Jul17, etc..." I would like to k...

7 years ago | 1 answer | 0

### 1

Question

Import File function not working?
Hello, I'm trying to create a script that sucks in Excel files, and keeps selected Data from one of its multiple spreadsheet tab...

7 years ago | 1 answer | 0