How can I remove rows containing Nan values in table?

Question

Behrooz Daneshian 2023-1-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1895260-how-can-i-remove-rows-containing-nan-values-in-table

评论： Image Analyst 2023-1-17

Table.mat

Hi all,

I have attached a table I am working one. In some rows of a table, there is NaN values both for TAVG and Tfreezing. How can I remove these rows? I tried using find(table.TAVG==NaN) but I do not know why it is not working. Can anyone help me in this regard?

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

请先登录，再进行评论。

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

Answer 1

dpb 2023-1-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1895260-how-can-i-remove-rows-containing-nan-values-in-table#answer_1150150

在 MATLAB Online 中打开

ixnan=(isnan(tTable.TAVG)|isnan(tTable.Tfreezing));     % logical vector either variable nan
tTable(ixnan,:)=[];                                     % remove those rows

alternatively, you can keep the finite rows...

tTable=tTable(~ixnan,:); % neither is nan

"I tried using find(table.TAVG==NaN)..."

Do NOT use "table" as the name of a variable -- that aliases the MATLAB table function; a very bad idea.

I'd suggest something a little more meaningful to the content of the table for your variable name, I just used tTable above as a fill-in for your table variable to avoid repeating the above aliasing.

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

请先登录，再进行评论。

Answer 2

Image Analyst 2023-1-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1895260-how-can-i-remove-rows-containing-nan-values-in-table#answer_1150155

编辑：Image Analyst 2023-1-16

在 MATLAB Online 中打开

behrooz Table.mat

Try this:

% Load .mat file.
s = load('behrooz Table.mat')
% Extract variable from structure into table.
t = s.stations_1__3__3__8_
% Extract columns 2 and 3 into a numerical array.
m = table2array(t(:, 2:3));
% See which rows have a nan in them.
nanRows = any(isnan(m), 2);
% Delete those rows with nans in column 2 or 3
% In other words, extract only rows that don't have a nan in them into a
% new variable.  You could use the same variable as the original if you want.
tNoNans = t(~nanRows, :)

Or, assuming you already have table t in memory, and want to do it all in one line

tNoNans2 = t(~any(isnan(t{:, 2:3}), 2), :);

though it's a bit cryptic and not commented at all like the first example so it might be harder to figure out what it's doing later.

2 个评论
显示无隐藏无

Behrooz Daneshian 2023-1-17

Thank you so much. it is the right way to do that.

Image Analyst 2023-1-17

If this Answer solves your original question, then could you please click the "Accept this answer" link to award the answerer with "reputation points" for their efforts in helping you? They'd appreciate it. Thanks in advance. 🙂 Note: you can only accept one answer (so pick the best one) but you can click the "Vote" icon for as many Answers as you want. Voting for an answer will also award reputation points.

请先登录，再进行评论。