Copying rows from one table to another
54 views (last 30 days)
Show older comments
David Cynamon
on 24 Oct 2016
Commented: Alexandra Harkai
on 24 Oct 2016
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 Comments
Accepted Answer
Alexandra Harkai
on 24 Oct 2016
strcmp(table.Name, 'Smith')
would do the trick.
3 Comments
Alexandra Harkai
on 24 Oct 2016
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'.
More Answers (0)
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!