remove rows with empty variables within timetable

8 visualizaciones (últimos 30 días)
Sehoon Chang
Sehoon Chang el 2 de Sept. de 2020
Respondida: Mohammad Sami el 3 de Sept. de 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 :)

Respuesta aceptada

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

Más respuestas (0)

Categorías

Más información sobre Tables en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by