Extracting data from readtable
9 views (last 30 days)
Show older comments
I am trying to import a csv file into MatLab. I can't use readcsv because the data contains headers and datetime values, and I can't use xlsread because I need to include the leading column and row. I am trying to use readtable, which is including all of the data I need, but I can't seem to get my data out of the table. This is what I'm trying to do on a table M to extract my datetime and specific column values:
t = datetime(M(2:end,1), 'ConvertFrom', 'excel');
y1 = M(2:end,120);
Please let me know where my error is!
0 Comments
Answers (1)
madhan ravi
on 22 Oct 2018
T = readtable('Mycsv.csv') %correct syntax
5 Comments
Jeremy Hughes
on 22 Oct 2018
If you need to extract an individual array (in a table they are the variables) use:
T.VarName
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!