How do I add a column to table?

Question

1 个投票

I have created a CSV file. When I use the "readable" function to load the table, I get an 8x10 table. I want to expand the table to an 8x11 table, where the 11th column should have the values from a function I have created. How do I do this?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

请先登录再关注

Answer 1

Walter Roberson 2024-5-15

编辑：MathWorks Support Team 2024-6-5

在 MATLAB Online 中打开

2 个投票

You can add a new table variable by using either dot notation or the "addvars" function. Dot notation adds new variables to the end of table. If you use the "addvars" function, then you can choose the location of the new table variable.

For example, this code creates a table and two column vectors. Then it adds the column vectors to the table as new variables.

LastName = ["Sanchez";"Johnson";"Li";"Diaz";"Brown"]; 
Age = [38;43;38;40;49]; 
Smoker = logical([1;0;1;0;1]); 
T = table(LastName,Age,Smoker); 
T.NewData = rand(5,1)        % Dot notation adds new variable to end of table 
MoreData = rand(5,1); 
T = addvars(T,MoreData,'Before',1)    % Add variable to beginning of table 

If you generate a table variable name by evaluating an expression, you can pass it as the name of the new variable with either of these syntaxes.

TodaysData = "Data " + string(datetime("today")); 
T.(TodaysData) = rand(5,1) 
YesterdaysData = "Data " + string(datetime("today") - 1); 
T = addvars(T,rand(5,1),'NewVariableNames',YesterdaysData,'Before',1) 