Removing rows with empty values in table

23 次查看（过去 30 天）
Tanika Bawa
Tanika Bawa 2022-9-26
回答： George Papazafeiropoulos 2022-9-26
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!

请先登录，再回答此问题。

采纳的回答

Cris LaPierre
Cris LaPierre 2022-9-26
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

更多回答（1 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by