Copying rows from one table to another

Question

David Cynamon 2016-10-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/308864-copying-rows-from-one-table-to-another

评论： Alexandra Harkai 2016-10-24

I have a large table of data which I have managed to filter down to the particular entrees I want by deleting unwanted rows. I'd like to be able to create new tables off of this.

For example making a new table consisting off all rows in the original that have the entree X for field y.

I would like to use this with a logical expression such as

rows = table.Name == 'Smith';
vars = {'Gender','Height','Weight'};
newTable = table(rows,vars)

However when do this it informs me that "==" is not defined for cells. What is the correct way to do this?

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

请先登录，再进行评论。

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

Answer 1

Alexandra Harkai 2016-10-24

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/308864-copying-rows-from-one-table-to-another#answer_240424

在 MATLAB Online 中打开

strcmp(table.Name, 'Smith')

would do the trick.

3 个评论
显示 1更早的评论隐藏 1更早的评论

David Cynamon 2016-10-24

在 MATLAB Online 中打开

Thank you very much for the help!

I saw in the first link you sent that I could use code like the following to return a structure where cells that have entries greater than specific values are listed.

rows = T.Var2>0;

However when I try this I get "Undefined operator '>' for input arguments of type 'cell'". What command would let me do this?

Thank you again for your help, it's much appreciated.

Alexandra Harkai 2016-10-24

If your table column for a given variable is a cell array, then you need to get the data 'out' of it: http://uk.mathworks.com/help/matlab/cell-arrays.html

So cell2mat would 'Convert cell array to ordinary array of the underlying data type'.

请先登录，再进行评论。