Convert class types in table

5 次查看（过去 30 天）

AR 2022-9-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1812515-convert-class-types-in-table

评论： AR 2022-9-28

I have a table with different variables consisting of different class elements. Call the table T & the variables A1, A2, A3.

So, class(T.A1) is cell, and class of each individual entry in T.A1 is double.

Class(T.A2) is cell, and class of each individual entry in T.A2 is char.

Class(T.A3) is cell, and class of some entries here is double & some others is char. It appears that the char values are all char([]).

For further operations, I need to convert all values in A1 & A3 to numeric (say double). I tried to replace all the char([]) in T.A3 with []. This works & class of each element in T.A3 now reports as double. However, when I further try:

T.A3 = cell2mat(T.A3)

I get the error: "Brace indexing is not supported for variables of this type. Error in cell2mat..." etc.

Please help figure out what may be wrong, and alternatively suggest how to accomplish the above.

8 个评论
显示 6更早的评论隐藏 6更早的评论

dpb 2022-9-27

".... I was using the "raw" read-in data which contains a combination of char & double to formulate the table. By instead using the numeric and char outputs separately..."

That implies you were/are using the deprecated xlsread instead of readtable -- I strongly recomend looking at readtable and its boon companion detectImportOptions instead.

AR 2022-9-28