Removing NAN values from the table and deleting it.

45 次查看（过去 30 天）
Shelender Kumar
Shelender Kumar 2018-11-17
编辑： Voss 2025-2-12
Hi
I have a table which is arrranged in susch a waym that it has one row of data and other row which contain NAN and so on, I want to get rid of NAN and aferwards deleting it.
Could you help me with this.

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

采纳的回答

madhan ravi
madhan ravi 2018-11-17
编辑：madhan ravi 2018-11-17
see https://www.mathworks.com/help/matlab/ref/rmmissing.html introduced in 2016b
rmmissing(T) %deletes row containing nan where T your table
  16 个评论
显示 14更早的评论
madhan ravi
madhan ravi 2018-11-19
Thank you sir Walter , have to familiarise with any and all it‘s slightly confusing :)

请先登录，再进行评论。

更多回答（2 个）

ahmed nebli
ahmed nebli 2018-11-17
use this : (isnan(X)) = [] % X is the table
  5 个评论
显示 3更早的评论

请先登录，再进行评论。

Francesco
Francesco 2025-2-12
编辑：Francesco 2025-2-12
Following another question I found this code working really good:
Xnew=X((isfinite(X)));
The new array has no Nan inside.
  5 个评论
显示 3更早的评论
Francesco
Francesco 2025-2-12
编辑：Francesco 2025-2-12
Ran in:
Yes the principle is the same, if you have a table, for example in your case, you can call the columns using T.Column_name, in this case:
T = array2table([1,2,3;nan,2,3;1,2,3;1,2,3;nan,2,3])
T = 5x3 table
Var1 Var2 Var3 ____ ____ ____ 1 2 3 NaN 2 3 1 2 3 1 2 3 NaN 2 3
X=T.Var1 ; Y=T.Var2; Z=T.Var3;
Xnew=X((isfinite(X)));
Ynew=Y((isfinite(X)));
Znew=Z((isfinite(X)));
T_new = array2table([Xnew,Ynew,Znew])
T_new = 3x3 table
Var1 Var2 Var3 ____ ____ ____ 1 2 3 1 2 3 1 2 3
Voss
Voss 2025-2-12
编辑：Voss 2025-2-12
Ran in:
T = array2table([1,2,3;nan,2,3;1,2,3;1,2,3;nan,2,3])
T = 5x3 table
Var1 Var2 Var3 ____ ____ ____ 1 2 3 NaN 2 3 1 2 3 1 2 3 NaN 2 3
T_new = T(isfinite(T.Var1),:)
T_new = 3x3 table
Var1 Var2 Var3 ____ ____ ____ 1 2 3 1 2 3 1 2 3
Since the question only asked about NaNs, isnan might be a better function to use than isfinite, i.e.
T_new = T(~isnan(T.Var1),:)
T_new = 3x3 table
Var1 Var2 Var3 ____ ____ ____ 1 2 3 1 2 3 1 2 3

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by