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

16 visualizaciones (últimos 30 días)
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 comentarios
ALESSIA ANTONACI
ALESSIA ANTONACI el 2 de Mzo. de 2020
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 el 2 de Mzo. de 2020
Furthermore, the vectors I want to create must contain the same data as the cell array

Iniciar sesión para comentar.

Respuestas (1)

Divya Gaddipati
Divya Gaddipati el 5 de Mzo. de 2020
A similar question has already been answered by the community which might be of relevance to you. Please refer to the following link:
Hope this helps!

Categorías

Más información sobre Data Type Conversion en Help Center y File Exchange.

Productos


Versión

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by