remove rows with empty variables within timetable
4 ビュー (過去 30 日間)
古いコメントを表示
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.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/355396/image.png)
thanks :)
0 件のコメント
採用された回答
Mohammad Sami
2020 年 9 月 3 日
You can use the rmmissing function. It will remove all rows where any of the columns are missing.
b = rmmissing(a);
0 件のコメント
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Tables についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!