remove rows with empty variables within timetable

3 views (last 30 days)
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 :)

Accepted Answer

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

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!