Removing rows with empty values in table

58 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
AllHitMov(1:6393,:)=[];

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!