How to delete rows with incomplete data in a csv file
17 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Neeraj Kulkarni
le 15 Sep 2020
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 commentaires
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!