# xander fong

**Statistics**

**MATLAB Answers**

**17** Questions

**0** Answers

RANK**35,903**

of 271,487

REPUTATION**1**

CONTRIBUTIONS

**17** Questions

**0** Answers

ANSWER ACCEPTANCE **
64.71%
**

VOTES RECEIVED**1**

RANK

of 18,308

REPUTATION**N/A**

AVERAGE RATING**0.00**

CONTRIBUTIONS**0** Files

DOWNLOADS **0**

ALL TIME DOWNLOADS**0**

RANK

of 119,983

CONTRIBUTIONS

**0** Problems

**0** Solutions

SCORE**0**

NUMBER OF BADGES**0**

CONTRIBUTIONS**0 Posts**

CONTRIBUTIONS**0** Public Channels

AVERAGE RATING

CONTRIBUTIONS**0** Highlights

AVERAGE NO. OF LIKES

**Content Feed**

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

answersQuestion

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

answerQuestion

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

answersQuestion

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

answerQuestion

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

answerQuestion

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

answerQuestion

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

answersQuestion

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

answerQuestion

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

answerQuestion

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

answerQuestion

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

answerQuestion

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

answerQuestion

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

answerQuestion

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

answerQuestion

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

answerQuestion

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

answerQuestion

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