Character to numeric - importing/conversion

3 次查看（过去 30 天）
Emily Howes
Emily Howes 2021-7-13
评论： Emily Howes 2021-7-14
My numerical data keeps importing from MS Excel as 'char' type. I set the target type as number when I was importing it so I'm not sure why. I would like the data to be a column vector of numeric data. I've tried the str2num and str2double functions but I receive the below error message.
>> class SoilMoisture
ans=
'char'
>> SM=str2num(SoilMoisture)
Error using str2num (line 35)
Input must be a character vector or string scalar.
Please could you help me find a way to either import my data as numeric type or if not, convert it once it's imported? Thank you.
  12 个评论
显示 10更早的评论
Stephen23
Stephen23 2021-7-13
编辑：Stephen23 2021-7-13
This command syntax
class 'T'
is exactly equivalent to this function syntax:
class('T')
which is very unlikely to be useful for you. Understanding the difference between command syntax and function syntax is critical to using MATLAB, which is why I explained this in an earlier comment and also linked to the documentation. In general I recommend avoiding command syntax, to avoid the problems you are having now.
Most likely you want to check the class of the variable T:
class(T)
which be class "table". You can use indexing or names to access the (numeric) data in a table:
https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-table.html
Emily Howes
Emily Howes 2021-7-13
Brilliant, thank you for your help. I have just tried this and it is now giving the answer as 'table'.

请先登录，再进行评论。

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

采纳的回答

Tanay Gupta
Tanay Gupta 2021-7-13
编辑：Tanay Gupta 2021-7-13
The problem you are facing is most probably because you are importing the heading as well and trying to convert that into a number.
Spreadsheets often contain a mix of numeric and text data as well as variable and row names, which is best represented in MATLAB® as a table thats the reason the data is imported as a character. You can import data in numeric format by using the Import Tool or the readmatrix function.
To learn to use the import tool click here. While importing the data through the above tool select the output type as numeric matrix. This will automatically import the data in double format.
You can also use the readmatrix function which provides the same functionality in form of code. Click here to learn more about it.
Hope it helps.
  5 个评论
显示 3更早的评论
Tanay Gupta
Tanay Gupta 2021-7-14
Sending the data in two different tables. The land use table contains the data from land use column and the moisture_data contains data from other two columns. The moisture data is saved as double and the land use data is saved as a table. You can now load these data files into matlab and access each row using indexing.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by