Finding which rows in table contain NaN, save those as new table

199 次查看（过去 30 天）
new2matlab
new2matlab 2020-2-6
评论： David Ebert 2022-10-3
Im looking to find a way to figure our which rows contain a 'NaN' in column 5, and then save all of those that do as a new table

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

采纳的回答

Guillaume
Guillaume 2020-2-6
Assuming your input is a table:
nantable = yourtable(isnan(yourtable{:, 5}), :) %keep all rows whose 5th column is nan

更多回答（1 个）

Adam Danz
Adam Danz 2020-2-6
编辑：Adam Danz 2020-2-7
If the tables all contain the same variable names (headers), use the variable names to index columns rather than column number. This is one of the strengths of tables over matrices and cell arrays. If the variable names are different, then you'll have to use numeric indexing.
Suppose column 5 is named "MyData" and the table is named "T".
nanIdx = isnan(T.MyData);
% If you must use numeric indexing,
% nanIdx = isnan(T{:,5});
Create the new table
Tnew = T(nanIdx,:);

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by