How to read column in excel table as a specific data type?

Question

Zeyad Elreedy 2023-3-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1927555-how-to-read-column-in-excel-table-as-a-specific-data-type

评论： Zeyad Elreedy 2023-3-13

Hello. I am trying to read an excel table that contains multiple columns. My understanding is that MATLAB looks at the first row of each column to determine its data type. For one of my columns, I have both numeric values and strings. Since the numeric values are first, this column returns the strings as NaN, as it has identified the whole column as type double. I would like to convert this column to cells, as I am planning to create a categorical array from them. However, I am unable to do so at the moment due to the NaN entries. Therefore, I am trying to find a way to load the column as a cell straight away, so the string entries are not lost as NaN.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2023-3-13

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1927555-how-to-read-column-in-excel-table-as-a-specific-data-type#answer_1191585

在 MATLAB Online 中打开

filename = 'appropriate file name goes here';
opts = detectImportOptions(filename);
opts = setvartype(opts, COLUMNNUMBER, 'categorical');
T = readtable(filename, opts);