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

18 次查看（过去 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 中查找有关 Logical 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by