MATLAB: Does table creation produce error “VariableNames property must contain one name for each variable in the table”

table

Can you please revise the following line of code to eliminate the error "VariableNames property must contain one name for each variable in the table"? I am stumped.

    T = table(rand(30,8), 'VariableNames', ...
      {'var1' 'var2' 'var3' 'var4' 'var5' 'var6' 'var7' 'var8'});

Best Answer

Just figured this out: have to use array2table,

   T = array2table(rand(30,8), ...
      'VariableNames', {'var1' 'var2' 'var3' 'var4' 'var5' ...
      'var6' 'var7' 'var8'});

However if you want to assign other properties besides names, you have to do that separately, unlike the table command,

T.Properties.VariableUnits = {'kg' 'm' 'W' 's' 'g' 'kg' 'm' 'W'};

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: Joining 2 tables to make 1 table

You can unite them as if they were matrixes:

complete_table = [table1 ; table2]; % This should work to join the columns of both tables

Best Answer

Related Solutions

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

MATLAB: Joining 2 tables to make 1 table

Related Question