remove rows with empty variables within timetable

3 Ansichten (letzte 30 Tage)
Sehoon Chang
Sehoon Chang am 2 Sep. 2020
Beantwortet: Mohammad Sami am 3 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 :)

Akzeptierte Antwort

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

Weitere Antworten (0)

Kategorien

Mehr zu Tables finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by