How Can i import data from excel with column names
14 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Walter Roberson
2016-4-11
If you have R2013b or later then I recommend you use readtable() and then operate on the column by name.
5 个评论
Walter Roberson
2016-4-12
编辑:Walter Roberson
2016-4-12
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
2016-4-13
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. :(
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!