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!

답변 (1개)

madhan ravi
madhan ravi 2018년 10월 22일

0 개 추천

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

댓글 수: 5

Megan Henriksen
Megan Henriksen 2018년 10월 22일
Hi, this is what I am doing to import the csv file. However, I am having trouble creating separate arrays from this table.
madhan ravi
madhan ravi 2018년 10월 22일
Mind uploading the data to test?
Megan Henriksen
Megan Henriksen 2018년 10월 22일
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
madhan ravi
madhan ravi 2018년 10월 22일
Thanks Jeremy

댓글을 달려면 로그인하십시오.

카테고리

질문:

2018년 10월 22일

댓글:

2018년 10월 22일

Community Treasure Hunt

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

Start Hunting!

Translated by