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

34 次查看（过去 30 天）
Douglas Leaffer
Douglas Leaffer 2022-12-8
评论： Douglas Leaffer 2022-12-9
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
<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更早的评论
Cris LaPierre
Cris LaPierre 2022-12-8
编辑：Cris LaPierre 2022-12-8
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 个）

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by