remove rows with empty variables within timetable
2 views (last 30 days)
Show older comments
Sehoon Chang
on 2 Sep 2020
Answered: Mohammad Sami
on 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 :)
0 Comments
Accepted Answer
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);
0 Comments
More Answers (0)
See Also
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!