How to Remove Rows in Table
显示 更早的评论
Hi, I have a data table here.
Let's say that I want to get rid of the people that does not like animal, signified by a blank space instead of a Y.
How do I make a new data table that removes these rows and forms a new table that only contains the Y.
Thank you!
采纳的回答
Adam Danz
2019-8-12
Read in the data; determine which rows are empty under "LikesAnimals"; then remove those rows.
t = readtable('data table.xlsx','ReadRowNames',true); % use full path if possible
noLikeIdx = cellfun(@isempty,t.LikesAnimals);
t(noLikeIdx, :) = [];
6 个评论
Minjun Seo
2019-8-12
Adam Danz
2019-8-12
Glad I could help!
Minjun Seo
2019-8-12
You can't have missing numbers. You can have NaNs, but not missing. If the numbers are represented as strings, then you can have missing strings. Is that the case? are the numbers represented as strings ('5') rather than numeric (5)?
Or perhaps the column is a cell array (you can also have empty cells).
The solution will depend on what you're working with: number, strings, cells, something else?
Minjun Seo
2019-8-12
Yes. In my answer above, the variable "noLikeIdx" is an index of rows that will be eliminated.
Here's how to create an index of rows that have NaN values or values less than 0 based on values stored in a column named "OtherData".
rowIdx = isnan(t.OtherData) | t.OtherData < 0;
% { find nan values} or {values less than 0}
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Multidimensional Arrays 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
