Removing rows with empty values in table

46 views (last 30 days)
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!

Accepted Answer

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

Sign in to comment.

More Answers (1)

George Papazafeiropoulos
George Papazafeiropoulos on 26 Sep 2022


Find more on Tables in Help Center and File Exchange




Community Treasure Hunt

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

Start Hunting!