MATLAB: Confusing error while using Table

errornamestablevariables

I am trying to make a simple table so that I can access some data by using names instead of a numeric index of a cell.

locationsTable = table(splitLocations, 'VariableNames', headerNames);

headerNames = {'rawData', 'testConfig', 'efiData', 'bonusData'};

splitLocations = {2, 49, 74, 142};

However, when I try to run this, I get the error

Error using setVarNames (line 35) The VariableNames property must contain one name for each variable in the table.

Error in table (line 304) t = setVarNames(t,vnames); % error if invalid, duplicate, or empty

This is confusing me, since I have a name for each variable, and none of them are invalid, duplicate or empty. I am unsure what I am doing wrong and what I need to change so that it works. Any help would be appreciated.

Best Answer

locationsTable = table(splitLocations{:}, 'VariableNames', headerNames);

It's seeing splitLocations as one variable, not four. Two have it see each scalar as a separate value, use comma-separated list expansion to pass in all four inputs as scalars.

Related Solutions

MATLAB: I’m struggling to create a table with names

Use the array2table function instead. The second example on that documentation page matches what you're trying to do.

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

Best Answer

Related Solutions

MATLAB: I’m struggling to create a table with names

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

Related Question