What defines the type of the different variables (eg. cell or double) when you import data (for example from a csv table using uigetfile) ?

Question

Max Jaquenoud 2018-9-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/418633-what-defines-the-type-of-the-different-variables-eg-cell-or-double-when-you-import-data-for-exam

评论： Karim botros 2020-10-20

This is the error message i get: Error using table2array (line 27) Cannot concatenate the table variables 'Depth' and 'Cu', because their types are double and cell.

Error in Fullscan_05_17_XRF_CSV (line 7) array = table2array(table(:,1:13));

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

请先登录，再进行评论。

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

Answer 1

Surbhi Pillai 2018-9-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/418633-what-defines-the-type-of-the-different-variables-eg-cell-or-double-when-you-import-data-for-exam#answer_338077

While reading csv table, the data type corresponding to different variables depends on the data contained in the table. The strings in the csv table corresponds to cell type whereas the numbers correspond to double after importing csv table into MATLAB.

The error received in your case is due to conversion of a table consisting elements with different data type into an array. An array is a collection of elements of similar data types therefore it is not allowed to concatenate two different data types to form an array.

Consider using 'table2cell' to combine different data type elements to form a cell array. The documentation link to the respective function is given below:

https://www.mathworks.com/help/matlab/ref/table2cell.html

I hope this helps!

2 个评论
显示无隐藏无

Max Jaquenoud 2018-11-20

Hi,

First of all, thank yo for your answer. My problem is that the table I have should contain only numbers. However, when I import the csv file into matlab, he thinks that some of these numbers are strings. Is there anyway to convert table types from string to double ?

Best,

Max

Karim botros 2020-10-20