Counting all NaN for each variable in the table

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

Answer 1

[Rahul]

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.

You can refer to the following MathWorks documentations to know more about these functions:

'isnan': https://www.mathworks.com/help/releases/R2022a/matlab/ref/isnan.html

'rmmissing': https://www.mathworks.com/help/releases/R2022a/matlab/ref/rmmissing.html

'fillmissing': https://www.mathworks.com/help/releases/R2022a/matlab/ref/fillmissing.html

'find': https://www.mathworks.com/help/releases/R2022a/matlab/ref/find.html

'plot': https://www.mathworks.com/help/releases/R2022a/matlab/ref/plot.html

Hope this resolves your query. Thanks.