Removing rows with empty values in table

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!

Answer 1

[Cris LaPierre]

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);

For more, see this answer: https://www.mathworks.com/matlabcentral/answers/277113-how-to-convert-cell-array-into-double-in-table#answer_261133

[Tanika Bawa]

Thank you very much for the answer but also for the explanation =)

Answer 2

[George Papazafeiropoulos]

AllHitMov(1:6393,:)=[];