read from CSV file-complex
1 view (last 30 days)
Show older comments
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...
0 Comments
Answers (1)
Ilham Hardy
on 16 Jan 2013
Download this function from File Exchange:
And look in the comment, specifically for example no.4 in the m-file.
HTH,
Ilham
0 Comments
See Also
Categories
Find more on Data Import and Analysis 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!