- NaN — double, single, duration, and calendarDuration
- NaT — datetime
- <missing> — string
- <undefined> — categorical
- {''} — cell of character vectors
Removing rows with empty values in table
58 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Tanika Bawa
le 26 Sep 2022
Réponse apportée : George Papazafeiropoulos
le 26 Sep 2022
Hello! I have the table attached ('egAllHitMov') which has missing values in the first 6393 rows showing as []. I tried the following line to remove them:
AllHitMov = rmmissing(AllHitMov);
But it does not work, and also does not give me an error. Do you know how I can create a new table without these lines?
Thank you!
0 commentaires
Réponse acceptée
Cris LaPierre
le 26 Sep 2022
Empty is not a recognized missing value in MATLAB, so rmmissing does nothing.
Missing values are defined according to the data type of A:
I think the easiest way to do what you want is to convert your values from empty cell arrays to doubles. That automatically removes the empty rows.
AllHitMov = varfun(@cell2mat,AllHitMov);
Plus de réponses (1)
Voir également
Catégories
En savoir plus sur Logical 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!