How do I replace (or remove) <undefined> with NaN in a categorical array ?

2022 12 8
1 个回答
回答已采纳
更新时间：2022 12 9
6 次查看（30 天）

0 个投票

How do I replace (or remove) <undefined> with NaN in a categorical array ? .dat file excerpt is attached. Thanks for any help !

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

 采纳的回答

Cris LaPierre
Cris LaPierre 2022-12-8

2 个投票

<undefined> is the value used for a missing categorical entry. NaN is for missing numerical values.
You can replace missing values using fillmissing
See this answer: https://www.mathworks.com/matlabcentral/answers/495000-replacing-undefined-in-categoricals-or-defining-a-default-value

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Douglas Leaffer
Douglas Leaffer 2022-12-8
Thank you Cris. I do not think I can use fillmissing to replace the categorical <undefined> with a number such as zero ( 0 ) ... Is there a way to do that? Or replace with another categorical such as "None"
Cris LaPierre
Cris LaPierre 2022-12-8
编辑：Cris LaPierre 2022-12-8
Ran in:
Ran in:
Your table variable source is of type categorical, so you must use a valid categorical data type, which is categorial, char array, or string.
  • categorical(0)
  • "0"
  • "None"
Here is an example that uses "None"
load Table4excerpt.mat
T41.source = fillmissing(T41.source,'constant',"None")
T41 = 40×10 table
Datetime Temp Hum DP WS Deg Bar Rain UFPConc source ____________________ _____ ____ _____ ___ ______ ______ ____ _______ ______ 17-Aug-2016 05:34:44 81.51 78.1 74.05 4.2 245.25 29.848 0 12460 None 17-Aug-2016 05:34:45 81.5 78 74 4 247.5 29.848 0 49020 None 17-Aug-2016 05:34:46 81.5 78 74 4 247.5 29.848 0 49020 None 17-Aug-2016 05:34:47 81.5 78 74 4 247.5 29.848 0 49020 None 17-Aug-2016 05:34:48 81.5 78 74 4 247.5 29.848 0 49020 None 17-Aug-2016 05:34:49 81.5 78 74 4 247.5 29.848 0 49020 None 17-Aug-2016 05:34:50 81.5 78 74 4 247.5 29.848 0 49020 None 17-Aug-2016 05:34:51 81.5 78 74 4 247.5 29.848 0 49020 train 17-Aug-2016 05:34:52 81.5 78 74 4 247.5 29.848 0 49020 None 17-Aug-2016 05:34:53 81.5 78 74 4 247.5 29.848 0 49020 None 17-Aug-2016 05:34:54 81.5 78 74 4 247.5 29.848 0 49020 None 17-Aug-2016 05:34:55 81.5 78 74 4 247.5 29.848 0 49020 None 17-Aug-2016 05:34:56 81.5 78 74 4 247.5 29.848 0 49020 None 17-Aug-2016 05:34:57 81.5 78 74 4 247.5 29.848 0 49020 None 17-Aug-2016 05:34:58 81.5 78 74 4 247.5 29.848 0 49020 None 17-Aug-2016 05:34:59 81.5 78 74 4 247.5 29.848 0 49020 None

请先登录，再进行评论。

更多回答（0 个）

类别

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

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by