turn a table column into doubles
126 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
JFz
am 25 Okt. 2016
Bearbeitet: Arshey Dhangekar
am 8 Jul. 2021
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 Kommentare
Akzeptierte Antwort
Guillaume
am 25 Okt. 2016
yourtable.columnname = str2double(yourtable.columnname);
is all that is needed.
5 Kommentare
Image Analyst
am 24 Nov. 2020
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!
Weitere Antworten (3)
Chaya N
am 25 Okt. 2016
str2num('enter your string here');
Please note that this would only work for strings that contain numerical data
7 Kommentare
Priteshkumar Gohil
am 12 Mai 2021
Bearbeitet: Priteshkumar Gohil
am 12 Mai 2021
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 Kommentare
Image Analyst
am 8 Jul. 2021
@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
am 8 Jul. 2021
Bearbeitet: Arshey Dhangekar
am 8 Jul. 2021
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'}
Siehe auch
Kategorien
Mehr zu Data Type Conversion finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!