Azzera filtri
Azzera filtri

Counting all NaN for each variable in the table

7 visualizzazioni (ultimi 30 giorni)
Mouhammad Jomaa Alkaseam
Mouhammad Jomaa Alkaseam il 6 Feb 2022
Risposto: Rahul il 19 Set 2024 alle 8:34
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

Risposte (1)

Rahul
Rahul il 19 Set 2024 alle 8:34
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:
Hope this resolves your query. Thanks.

Categorie

Scopri di più su Data Preprocessing in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by