How to delete rows with incomplete data in a csv file
17 ビュー (過去 30 日間)
古いコメントを表示
Have lots of csv files with the same data structure: 52 columns (some empty ones in between) and thousands rows.
Was wondering whether there is qucik way to delete the rows with incomplete data (meaning no data for some parameters/columns) and save the csv file with Matlab scripts.
For example, the attached data.csv file has incomplete data starting Row #29 (included) onwards. Thus, the script will delete Row #29 and above and save the csv file.
Thanks!
ILoveML
0 件のコメント
回答 (1 件)
Neeraj Kulkarni
2020 年 9 月 15 日
Hi,
Please refer to following example to clean messy and missing data in tables:
Below is an example code to remove incomplete rows:
dataTable = readtable('data.csv');
dataTable = rmmissing(dataTable);
writetable(dataTable,'data.csv');
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!