turn a table column into doubles

99 次查看（过去 30 天）
JFz
JFz 2016-10-25
编辑： Arshey Dhangekar 2021-7-8
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

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

采纳的回答

Guillaume
Guillaume 2016-10-25
yourtable.columnname = str2double(yourtable.columnname);
is all that is needed.
  5 个评论
显示 3更早的评论
Luisana Rodriguez Sequeira
Luisana Rodriguez Sequeira 2020-11-24
What can we do if str2double returns NaN?
Image Analyst
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
Chaya N 2016-10-25
str2num('enter your string here');
Please note that this would only work for strings that contain numerical data
  7 个评论
显示 5更早的评论
Chaya N
Chaya N 2016-10-26
I am learning new things here. Thank you.
JFz
JFz 2016-10-27
str2double works!
Thank you so much!

请先登录，再进行评论。

Image Analyst
Image Analyst 2016-10-25
You could use xlsread() instead of readtable().
Priteshkumar Gohil
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 个评论
显示 1更早的评论
Image Analyst
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
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!

Translated by