Cant convert more than 80 columns of data to categorical

1 次查看（过去 30 天）

显示更早的评论

SkarletSam 2020-11-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/667133-cant-convert-more-than-80-columns-of-data-to-categorical

评论： SkarletSam 2020-11-29

采纳的回答： Walter Roberson

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

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 2020-11-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/667133-cant-convert-more-than-80-columns-of-data-to-categorical#answer_559008

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更早的评论隐藏 1更早的评论

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 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!

请先登录，再进行评论。