Removing rows with empty values in table

58 vues (au cours des 30 derniers jours)
Tanika Bawa
Tanika Bawa 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!

Réponse acceptée

Cris LaPierre
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:
  • NaN double, single, duration, and calendarDuration
  • NaT datetime
  • <missing> string
  • <undefined> categorical
  • {''} cell of character vectors
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);
  1 commentaire
Tanika Bawa
Tanika Bawa le 26 Sep 2022
Thank you very much for the answer but also for the explanation =)

Connectez-vous pour commenter.

Plus de réponses (1)

George Papazafeiropoulos
George Papazafeiropoulos le 26 Sep 2022
AllHitMov(1:6393,:)=[];

Catégories

En savoir plus sur Logical dans Help Center et File Exchange

Produits


Version

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by