MATLAB: Unstack table and NaN values

MATLABunstack

I have a table with 5 columns which represent different variables

T = cell2table(MyArray,'VariableNames',{'ID' 'Region' 'Int_Den' 'Area' 'Group'});

Then, I used unstack to kind of reorganize it

S = unstack(T,'Int_Den','ID');

However, this is not exactly what I need. You can see from the screenshot below that I have a 294×52 table, where the majority of values are NaN. Instead of this, I would like to have a table where the first column is the "Region", and then the IDs will be distributed from columns 2 to 50. At the end the table should be 6 rows x 50 columns.

Thanks,

Best Answer

The remaining variables are used by unstack as grouping variables. You should exclude them when calling unstack.

T = cell2table(MyArray,'VariableNames',{'ID' 'Region' 'Int_Den' 'Area' 'Group'});
S = unstack(T(:,{'ID' 'Region' 'Int_Den'}),'Int_Den','ID');

Related Solutions

MATLAB: Merge arrays into table and keep the variable names

table function has VariableNames option, which can be used as follows:

array1=[1;2];
array2=[3;4];
array3=[5;6];
table(array1,array2,array3,'VariableNames',{'array1','array2','array3'})

MATLAB: Am I receiving this error when using the vartestn function

In the code you shared, I see 3 inputs and one name-value pair.

vartestn(Table.trialNum, Table.Sex, Table.ID, 'TestType', 'LeveneQuadratic');

The syntax described in the documentation describes a max of 2 inputs followed by name-value pairs.

vartestn(x,group,Name,Value)

Furthermore, from the documentation, x can be specified as a matrix or column vector. If a grouping variable group is specified, then x must be a column vector. So, you have 1 too many inputs.

Decide which variable is your grouping variable and which variable contains the data you're testing.

Best Answer

Related Solutions

MATLAB: Merge arrays into table and keep the variable names

MATLAB: Am I receiving this error when using the vartestn function

Related Question