read from CSV file-complex

1 visualizzazione (ultimi 30 giorni)

ron il 16 Gen 2013

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...

Ilham Hardy il 16 Gen 2013

Download this function from File Exchange:

And look in the comment, specifically for example no.4 in the m-file.

HTH,

Ilham

MATLAB Data Import and Analysis

Scopri di più su Data Import and Analysis in Help Center e File Exchange

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

Translated by