How to delete rows with incomplete data in a csv file

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

Answer 1

[Neeraj Kulkarni]

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');