Counting all NaN for each variable in the table

Question

Mouhammad Jomaa Alkaseam 2022-2-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1644045-counting-all-nan-for-each-variable-in-the-table

回答： Rahul 2024-9-19

untitled.jpg

I have wind and wave data, (9 columns), I would like to have the NaN for each column and then plot the clean data with all the indicated missing values for each column

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

请先登录，再进行评论。

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

Answer 1

Rahul 2024-9-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1644045-counting-all-nan-for-each-variable-in-the-table#answer_1519180

Hi @Mouhammad Jomaa Alkaseam,

In order to clean your data that contains NaN values, you can consider the following method:

You can first identify where the NaN values exist in your data using the 'isnan' function on your data.
Further to clean the data, you can use 'rmmissing' function which would remove the rows with NaN values from the data.
If the above step is not desired for your use-case, you can consider interpolating the data to fill in the missing values by using the 'fillmissing' function.
In the first step, 'isnan' function would give you indices where NaN values exist. You can use the 'find' function on these indices and obtain indicate the missing values and plot them using ‘plot’ function.