Cant convert more than 80 columns of data to categorical

1 次查看（过去 30 天）
SkarletSam
SkarletSam 2020-11-29
评论： SkarletSam 2020-11-29
I am trying to convert all coloumns of a 1000x170 table to categorical data. "bt_000" would be the 81st coloumn.
It would seem that the function does not work after the 80th coloumn, any remedies?
Thank you.
  1 个评论
dpb
dpb 2020-11-29
It's not the number or the postion but the content of the column that's the problem, methinks.
Bet it will error the same way if you try that column alone.

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2020-11-29
When you categorical() numeric values, then internally it uses %-0.5g format to convert the values to character vectors. It then errors if the number of unique values that result is different than the number of unique numbers.
Which is to say that when you categorical() numeric values, it is a problem if two of the unique values are the same up to the 5th decimal digit.
  3 个评论
显示 1更早的评论
dpb
dpb 2020-11-29
That doesn't say it errors because of it, though...that's probably worth a documentation addendum note (not that anybody ever actually reads the doc first).
SkarletSam
SkarletSam 2020-11-29
Seems like fuzziness with the categorical was the root of the problem. There were some columns that had large numbers that were really close to each other in numeric value. Took those out and the varfun worked. I discretized the columns that didnt work inidividually and added onto the newTable. Thanks for the input!

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by