Removing rows with empty values in table

2022 9 26
2 个回答
回答已采纳
更新时间：2022 9 26
14 次查看（30 天）

0 个投票

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

0 个投票

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

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

产品

版本

R2020b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by