Removing NaNs from imported table

178 次查看（过去 30 天）

Ilay Green 2023-1-14

评论： Star Strider 2023-1-14

Hey everyone,

I am trying to remove all the NaNs from an imported table with readtable() (.xlsx file).

i've tried using isnan() but without success.

assuming all i have right now is:

R = readtable('blabla')

how can i remove the NaNs and keep the save the new table?

thanks for the help!

Star Strider 2023-1-14

See if the rmmissing function (introduced in R2016b) will do what you want.

Ilay Green 2023-1-14

tyvm!

made me realize it is not neccesary to use a certain function when facing a problem!

Star Strider 2023-1-14

As always, my pleasure!

Jeff Beck 2023-1-14

编辑：Jeff Beck 2023-1-14

You might try using the "MissingRule" option set to "omitrow" in readtable:

R = readtable('blabla', 'MissingRule', 'omitrow');

Ilay Green 2023-1-14

thanks for reply!

its not working though, Star Strider solution worked well for me

MATLAB Language Fundamentals Data Types Tables

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

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

Translated by