read from CSV file-complex

hi, i have aCSV file looks like this:
2012-02-09 00:00:36,11002,86,1,0,376,0,0,0,0,0
2012-02-09 00:00:39,11002,86,1,0,622,0,0,0,0,3
the fields are: datetime|int|int|int|int|int|int|int|int|int|int|
i want to read it into a matrix that will look like this:
year|month|day|hour|all other numeric columns. any suggestions?
P.S the data amount in large, about 3 millon rows...

回答(1 个)

Ilham Hardy
Ilham Hardy 2013-1-16

0 个投票

Download this function from File Exchange:
And look in the comment, specifically for example no.4 in the m-file.
HTH,
Ilham

类别

帮助中心File Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息

标签

提问:

ron
2013-1-16

Community Treasure Hunt

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

Start Hunting!

Translated by