turn a table column into doubles
94 次查看(过去 30 天)
显示 更早的评论
Hi,
I have a Table that has a column that was read from an excel sheet. The column should be numbers but is currently shown as strings like '3.14', '2.22', .... How to turn this column into doubles?
Thanks.
jennifer
0 个评论
采纳的回答
Guillaume
2016-10-25
yourtable.columnname = str2double(yourtable.columnname);
is all that is needed.
5 个评论
Image Analyst
2020-11-24
The the column is either nans or characters or something that is not a number. So don't try to cast it to doubles then!
更多回答(3 个)
Chaya N
2016-10-25
str2num('enter your string here');
Please note that this would only work for strings that contain numerical data
7 个评论
Priteshkumar Gohil
2021-5-12
编辑:Priteshkumar Gohil
2021-5-12
e.g. if you want to convert 1st column then following should work.
yourtable.(1) = str2double(t.(1));
or
yourtable.('COLUMN_TITLE') = str2double(t.('COLUMN_TITLE'));
3 个评论
Image Analyst
2021-7-8
@Arshey Dhangekar, start your own question and attach the csv file and code to import it into MATLAB, presumably with the readtable() function.
Arshey Dhangekar
2021-7-8
编辑:Arshey Dhangekar
2021-7-8
Hello I know basic thing. So only I want to know how can I convert all data into double. I attach csv file
Press=readtable ("inst0 138.221.155.184 12_10_2020 14_49_56 2.csv")
varfun(@class,Press,'OutputFormat','cell')
Output
Columns 1 through 8
{'double'} {'cell'} {'double'} {'double'} {'double'} {'double'} {'double'} {'double'}
Columns 9 through 16
{'double'} {'double'} {'double'} {'double'} {'double'} {'double'} {'double'} {'double'}
Columns 17 through 25
{'double'} {'double'} {'cell'} {'cell'} {'cell'} {'cell'} {'cell'} {'cell'} {'cell'}
Columns 26 through 29
{'cell'} {'cell'} {'cell'} {'double'}
另请参阅
类别
在 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!