How do I replace (or remove) <undefined> with NaN in a categorical array ?
37 views (last 30 days)
Show older comments
Douglas Leaffer
on 8 Dec 2022
Commented: Douglas Leaffer
on 9 Dec 2022
How do I replace (or remove) <undefined> with NaN in a categorical array ? .dat file excerpt is attached. Thanks for any help !
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1224617/image.jpeg)
0 Comments
Accepted Answer
Cris LaPierre
on 8 Dec 2022
<undefined> is the value used for a missing categorical entry. NaN is for missing numerical values.
You can replace missing values using fillmissing
3 Comments
Cris LaPierre
on 8 Dec 2022
Edited: Cris LaPierre
on 8 Dec 2022
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")
More Answers (0)
See Also
Categories
Find more on Categorical Arrays in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!