필터 지우기
필터 지우기

How do I add a column to table?

조회 수: 965 (최근 30일)
m m
m m 2015년 11월 19일
편집: MathWorks Support Team 2024년 6월 5일
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?

채택된 답변

Walter Roberson
Walter Roberson 2024년 5월 15일
편집: MathWorks Support Team 2024년 6월 5일
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)
For more information, see the following documentation:
Add, Delete, and Rearrange Table Variables
https://www.mathworks.com/help/matlab/matlab_prog/add-and-delete-table-variables.html

추가 답변 (3개)

Sean de Wolski
Sean de Wolski 2015년 11월 20일
T.EleventhColumn = rand(8,1);
Where 'EleventhColumn' is the name you want for the variable.
  댓글 수: 2
Theodore Wilkening
Theodore Wilkening 2020년 3월 13일
this works best.
Yifei
Yifei 2022년 11월 26일
The most convenient approach.

댓글을 달려면 로그인하십시오.


thang ngo
thang ngo 2020년 7월 24일
This helps to pass a name as parameter:
name = 'new_column'
T.(name) = rand(8,1);

Ehab Abdelkarim
Ehab Abdelkarim 2018년 8월 3일
you may want to check the following link https://de.mathworks.com/help/matlab/matlab_prog/add-and-delete-table-variables.html

카테고리

Help CenterFile Exchange에서 Tables에 대해 자세히 알아보기

제품


릴리스

R2024a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by