MATLAB: Table2array gives string array when contents are numbers

MATLABtable2arraytable2array string array instead of double

Whenever I try to convert an table of numbers into an array, instead I will get a string array with all my numbers listed inside quotemarks. When I try to access it with {} which is reccommended elsewhere in matlab answers then the problematic column that I just added to the matrix here just dissapears entirely

The line giving the issue is

channel5mmyeild= table2array([sr_p, x5mmlinyeild]);

Anyone have any idea what could be causing this?

Cheers

Best Answer

I suspect data in sr_p and x5mmlinyeild are chars or strings and not doubles. What is the data type of the columns of your table? Look at the results of summary(sr_p) and summary(x5mmlinyeild).

If that doesn't seem to be the problem, please save your variables to a mat file and attach them to your post using the paperclip icon.

Related Solutions

MATLAB: Existing table, populate a column with string (receiving errors)

You are close, but you are trying to assign a character vector to a double variable (NaN = not a number). You can see that if you run the command summary(mytable).

You also do not need to put the text into a cell if you use the string data type.

See if you can get this code to work for your needs.

myArray = nan(5,2)
mytable = array2table(myArray);
mytable.Properties.VariableNames = {'colA', 'colB'};
mytable2 = convertvars(mytable,"colB",'string');
mytable2.colA(:) = 459;
mytable2.colB(:) = "words"

You say you have a lot of data. If the variables already exist, you could do something like this:

colA = nan(5,1);
colB = strings(5,1);
mytable = table(colA,colB);
mytable.colA(:) = 459; % just a random number, proof-of-concept that it works
mytable.colB(:) = "words" % this throws errors

MATLAB: How to change nonzero values to 1 within a table

tempTable = table2array(myTable);
tempTable(tempTable~=0)=1;
myTable = array2table(tempTable);

Best Answer

Related Solutions

MATLAB: Existing table, populate a column with string (receiving errors)

MATLAB: How to change nonzero values to 1 within a table

Related Question