Extracting data from readtable

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!

Answers (1)

T = readtable('Mycsv.csv') %correct syntax

5 Comments

Hi, this is what I am doing to import the csv file. However, I am having trouble creating separate arrays from this table.
Mind uploading the data to test?
I don't feel comfortable uploading the data because it is for research at my university. However, I uploaded a screenshot of what the data looks like in the table.
If you need to extract an individual array (in a table they are the variables) use:
T.VarName
Thanks Jeremy

Sign in to comment.

Asked:

on 22 Oct 2018

Commented:

on 22 Oct 2018

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!