Character to numeric - importing/conversion
4 次查看(过去 30 天)
显示 更早的评论
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 个评论
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:
采纳的回答
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 个评论
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 Type Conversion 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!