Copy table's certain data into another table with corresponding variable names

Question

Ege 2014-10-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/159711-copy-table-s-certain-data-into-another-table-with-corresponding-variable-names

编辑： Mohammad Abouali 2014-10-23

Let's say I have a table with 10 rows and 10 columns. I'd like to copy 5 cols and 10 rows of the table into another one with their variable names. Is there a way to do that?

Thank you.

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

请先登录，再进行评论。

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

Answer 1

Mohammad Abouali 2014-10-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/159711-copy-table-s-certain-data-into-another-table-with-corresponding-variable-names#answer_156251

在 MATLAB Online 中打开

Lets say you want move column Age from table1 to table2

table2.Age=table1.Age

Or if you want to move column 5 to 8 of table1 to table2 do this:

for c=5:8
 table2.(T.Properties.VariableNames{c})=table1.(T.Properties.VariableNames{c});
end

2 个评论
显示无隐藏无

Ege 2014-10-23

When I try this on a sample table I get "Error using table/subsrefDot (line 48) Index exceeds matrix dimensions.

Error in table/subsref (line 62) [varargout{1:nargout}] = subsrefDot(t,s);" error

Mohammad Abouali 2014-10-23

编辑：Mohammad Abouali 2014-10-23

Do your two tables have the same number of rows?

By the way, I have assumed that both table2 and table1 are already defined.

请先登录，再进行评论。

Answer 2

Guillaume 2014-10-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/159711-copy-table-s-certain-data-into-another-table-with-corresponding-variable-names#answer_156249

编辑：Guillaume 2014-10-22

在 MATLAB Online 中打开

Just use normal indexing to get your new table:

demotable = cell2table(num2cell(randi(100, 10, 10)), ...
                      'VariableNames', ...
                      arrayfun(@(n) sprintf('Name_%d', n), 1:10, 'uni', 0))
newtable = demotable(:, 3:7)