How to delete rows with incomplete data in a csv file

17 次查看（过去 30 天）
ILoveML
ILoveML 2020-2-5
回答： Neeraj Kulkarni 2020-9-15
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

请先登录，再回答此问题。

回答（1 个）

Neeraj Kulkarni
Neeraj Kulkarni 2020-9-15
Hi,
Please refer to following example to clean messy and missing data in tables:
https://in.mathworks.com/help/matlab/matlab_prog/clean-messy-and-missing-data-in-tables.html
Below is an example code to remove incomplete rows:
dataTable = readtable('data.csv');
dataTable = rmmissing(dataTable);
writetable(dataTable,'data.csv');

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by