read from CSV file-complex

3 vues (au cours des 30 derniers jours)
ron
ron le 16 Jan 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...

Connectez-vous pour répondre à cette question.

Réponses (1)

Ilham Hardy
Ilham Hardy le 16 Jan 2013
Download this function from File Exchange:
http://www.mathworks.ch/matlabcentral/fileexchange/18430-txt2mat
And look in the comment, specifically for example no.4 in the m-file.
HTH,
Ilham

Catégories

En savoir plus sur Resizing and Reshaping Matrices dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by