Removing rows with empty values in table

60 Ansichten (letzte 30 Tage)
Tanika Bawa
Tanika Bawa am 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!

Akzeptierte Antwort

Cris LaPierre
Cris LaPierre am 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 Kommentar
Tanika Bawa
Tanika Bawa am 26 Sep. 2022
Thank you very much for the answer but also for the explanation =)

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

George Papazafeiropoulos
George Papazafeiropoulos am 26 Sep. 2022


Mehr zu Tables finden Sie in Help Center und File Exchange




Community Treasure Hunt

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

Start Hunting!

Translated by