Creating new dataset corresponding to certain name within a variable column
1 view (last 30 days)
Show older comments
I have a dataset with four columns: day, bottle, species finalC. Attached is a screenshot for reference. In the bottle column, there are many types of bottle names I reference. I wish to create a new dataset corresponding only to a specific name of bottle, for example "C-a"
Desired outcome looks as follows:
day bottle species finalC
1 'C-a' 'Colp' 1077.58620700000
2 'C-a' 'Colp' 86525.1499800000
2 'C-a' 'Colp' 208333.333300000
0 Comments
Answers (1)
the cyclist
on 22 Mar 2019
Here is one possible way. (It assumes your table's variable name is tbl.)
outcome = tbl(ismember(tbl.bottle,'C-a'),:);
See Also
Categories
Find more on Red 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!