MATLAB: How to use a vector for filling columns of table

table

Hi, in my program I am creating a table of a certain width. the table is filled row by row in a for loop. Sometimes an error occurs and I handle this one with the try, catch command and then I go to the next row with the for loop. Now I want that if an error occurs the table entries of this row are all zero in each column except the first two values. I tried something like this but I really can not figure out how to get it work (table width varies thats why I have to do it like this)

    new_table = table({num2str(id)}, {'error'}, [zeros(1, width(new_table)-2)])

the answer should look like this then:

      Var1       Var2      Var3    Var4    Var5    Var6    Var7
    ________    _______    ____    ____    ____    ____    ____
    '466451'    'error'    0       0       0       0       0

thank you very much 🙂

Joe

Best Answer

cell2table([{num2str(457888)}, {'error'}, num2cell(zeros(1, size(new_table,2)-2))])

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: Remove rows of a table based on values in an array

disp('Original table');
var1=[1;1;1;1;4;1];
var2=[2;2;2;2;5;2];
var3=[0;3;3;8;8;9];
table_data=table(var1,var2,var3)
n=histc(var3(:),var3);
disp('Updated table');
table_data(find(n==1),:)=[]

Result Window:

Original table
table_data =
  6×3 table
    var1    var2    var3
    __    ____    ____
    1       2       0   
    1       2       3   
    1       2       3   
    1       2       8   
    4       5       8   
    1       2       9   
    
Updated table
table_data =
  4×3 table
    var1    var2    var3
    ____    ____    ____
    1       2       3   
    1       2       3   
    1       2       8   
    4       5       8

Best Answer

Related Solutions

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

MATLAB: Remove rows of a table based on values in an array

Related Question