How Can i import data from excel with column names
14 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
sri satya ravi
il 11 Apr 2016
Commentato: Walter Roberson
il 13 Apr 2016
I am looking to import data from excel with colum names. I also meed to perform calculations for the whole column with that name.
For Example: Say i have a excel sheet with 50 columns of data. I want to pick a column from the dataset with the name of the column and do some mathematical operations on the whole column.
0 Commenti
Risposta accettata
Walter Roberson
il 11 Apr 2016
If you have R2013b or later then I recommend you use readtable() and then operate on the column by name.
5 Commenti
Walter Roberson
il 12 Apr 2016
Modificato: Walter Roberson
il 12 Apr 2016
I cannot read the names of your columns in your excel data. What I can read, together with the warning message, suggests that you have multiple columns with the same header, so it might have modified the name of the variables to prevent duplicates.
To see the names that were used for the columns, use
t.VariableNames
Walter Roberson
il 13 Apr 2016
t = readtable('MAE 525 HW5 Soln.xlsx', 'Range', 'B15:V12006');
t.Properties.VariableNames
CO2_meas = str2double(t.CO2_meas(2:end));
Your data turns out to have a 14 irrelevant lines at the top that needed to be skipped over. Unfortunately readtable() does not support the HeaderLines option for spreadsheets in the release I have (R2014a), but the change in documentation for R2014b suggests that for that version onward you might possibly be able to use
t = readtable('MAE 525 HW5 Soln.xlsx', 'HeaderLines', 14);
You might notice I have used str2double on the data. That is because you have a second header below the row name that gives the units, and that text field is being interpreted by readtable as indicating that the entire column should be treated as text. :(
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!