How to add a new column to a table such that the new column has all 0s or ''?

I need to add two more columns to my table. One has all the 0s; one has all the ''. I will change the 0s and '' later.

How to add a new column to a table such that the new column has all 0s or ''?

Thanks,

Jennifer

Answer 1

[Walter Roberson]

nrow = size(YourTable,1);
YourTable.NewColumnName = zeros(nrow, 1);    %0
YourTable.OtherNewColumn = char(zeros(nrow,0));  %empty string, see note
YourTable.ThirdColumn = repmat({''}, nrow, 1);   %cell array of empty string

Note: if you use the char(zeros(nrow,0)) then although you have initialized to empty strings, all of the columns then become constrained to be empty strings and you cannot expand those except by replacing the entire column. You probably want the cell array version rather than the empty-string version

[JFz]

Thank you!

[Jessica Blasco]

thank you!! he also helped me with a similar problem!! :)

[Peter Perkins]

More recentl (R2018a), you can preallocatre a table with a syntax such as

t = table('Size',[n 2],'VariableTypes',{'double' 'cellstr'})

Once you have that, you can horzcat or assign the new table onto the existing table.

[JFz]

Thanks.