Getting data from specific columns in a table
显示 更早的评论
Hello:
I have table_1 and say it has 6 columns. I would to love to have a code that will enable me to get data from a specific column(s) by using the column number or numbers.So lets say I want data from columns 2 and 3, the code should enable me to enter 2 and 3 and then it will search the table and return the data associated with the specified column(s).
Thank you guys.
采纳的回答
You get data from a table by using the dot-notation. Therefore use the name of the column. If your columns are named 1...6 use
table_new = table_old.2
to get data from the column named '2'.
Here is an example:
A = table(['a'; 'b'; 'c'],[1; 2; 3],'VariableNames',{'x', 'y'})
If you use:
A.y
you get an array containing all values of the column named 'y'.
Best regards
Stephan
9 个评论
Curious Mind
2018-8-21
What is the result if you type:
whos your_table_name
To avoid missunderstanding: table_old is a placeholder since i do not know the name of your table ans the names of their columns.
If i assume that your table is named table_1 and the true name of the columns is 1...6:
result(:,1) = table_1.2;
result(:,2) = table_1.3;
Will give you the columns 2 and 3 from your table in a new array called result.
Curious Mind
2018-8-21
Curious Mind
2018-8-21
Curious Mind
2018-8-21
Curious Mind
2018-8-21
So you use:
B = Table_A(:,2:3)
to get what you want.
Curious Mind
2018-8-21
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
