Categorical2Num in a table

Question

BingoIngo 2019-5-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/461074-categorical2num-in-a-table

回答： Peter Perkins 2019-5-14

I have a table with categorical data in it. In order to calculate average etc. I need to convert it to num. Does anyone know the syntax?

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

Walter Roberson 2019-5-9

YourTable.NewVariable = double(YourTable.CategoricalVariable)

It is possible to replace the variable but you have to build a table to do it because of the change of data type.

Are you sure you need numeric? findgroups will probably provide you with everything you need in practice.

请先登录，再进行评论。

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

Answer 1

Peter Perkins 2019-5-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/461074-categorical2num-in-a-table#answer_374995

If you are computing the average of a numeric variable using a cate3gorical variable to group your data, then you should not need to convert anything.

But your description sounds like you are trying to compute the average of a categorical variable. That's a contradiction in terms. It's like computing the mean of text data. Mode, sure (in which case you don't need to convert), median, yes, if it's ordinal. Mean? Something is wrong.