How do I get a range of data from csv with unequal columns?

6 次查看（过去 30 天）
Iain Hunter
Iain Hunter 2019-2-22
回答： Walter Roberson 2019-2-22
I want to read in a section of this data.csv. Everything works fine with the xlsx version of the file.
A = xlsread(filename,1, 'I9..N30008');
The trouble is I would rather pull it in as a csv so that I don't have to save all my csv files as xlsx. I think the difficulty arises since there are not equal column numbers on every row.

请先登录，再回答此问题。

回答（1 个）

Walter Roberson
Walter Roberson 2019-2-22
T = readtable('data.csv', 'HeaderLines', 8, 'ReadVariableNames', false, 'Delimiter', ',');
If you need to convert the second column into dates, then
dates = datetime(T{:,2}, 'InputFormat', 'MM/dd/yyyy hh:mm:ss.SSS a');
and the pure numeric part (ignoring the first column that gives row numbers) would be
num = T{:,3:14};
The events are at T{:,15} and T{:,16}

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by