Community Profile

photo

xander fong


Active since 2015

Statistics

  • Thankful Level 3

View badges

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

answers

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

answer

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

answers

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

answer

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

answer

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

answer

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

answers

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

answer

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

answer

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

answer

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

answer

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

answer

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

answer

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

answer

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

answer

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

1

answer

Question


Basic Excel Import Error
Hello, I'm new to Matlab and am trying to create the beginning of a script that lists all *.XYZ files from excel and then stores...

7 years ago | 1 answer | 0

1

answer