Convert cell array with different data type to a matrix in MATLAB

22 次查看（过去 30 天）
ALESSIA ANTONACI
ALESSIA ANTONACI 2020-3-2
评论： ALESSIA ANTONACI 2020-3-7
I imported an excel sheet on matlab in which some columns are characterized by different data, such as numeric values ​​separated by a slash (e.g. 7/8) and normal numeric values . The "cell2mat" command transforms only columns containing the same type of data. What can I do for the remaining columns?
  3 个评论
显示 1更早的评论
ALESSIA ANTONACI
ALESSIA ANTONACI 2020-3-2
The cell array that I created is made up of 141 rows and 8 columns. Of these 8 columns, some contain the same type of data, i.e. only numbers. Other columns, on the other hand, consist of both simple numbers and numerical values such as 7/8, or 5/6 and also text abbreviations (therefore they are composed of different types of data). Since building vectors for every single column, for those that have the same data type I used the "cell2mat" command. My problem is that I can't create vectors just for those columns containing mixed data. I apologize for not explaining the problem first but it is my first approach to Matlab.
ALESSIA ANTONACI
ALESSIA ANTONACI 2020-3-2
Furthermore, the vectors I want to create must contain the same data as the cell array

请先登录，再进行评论。

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

回答（1 个）

Divya Gaddipati
Divya Gaddipati 2020-3-5
A similar question has already been answered by the community which might be of relevance to you. Please refer to the following link:
https://www.mathworks.com/matlabcentral/answers/878-how-do-i-convert-strings-stored-in-a-cell-array-to-numbers?s_tid=answers_rc1-2_p2_MLT
Hope this helps!

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by