remove rows with empty variables within timetable

8 vues (au cours des 30 derniers jours)
Sehoon Chang
Sehoon Chang le 2 Sep 2020
Hi all
I have a table with numerous variables that are empty/not recorded at certain point of time (mostly front and rear row, due to different measurement period or simply missing).
How can i just keep the central part, in which all the measurement of all variables are present, and remove the front and rear row in which even a single measurement is missing?
Below is an examplary timetable to explain what i intend to do.
thanks :)

Réponse acceptée

Mohammad Sami
Mohammad Sami le 3 Sep 2020
You can use the rmmissing function. It will remove all rows where any of the columns are missing.
b = rmmissing(a);

Plus de réponses (0)

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by