Read a csv file???
조회 수: 1 (최근 30일)
이전 댓글 표시
Dear all, in the first row of the matrix are 6 variable names (time, open, high, low, close, volume). The format of the data in the first column (time) is like this: 01.01.2004 01:00:00.000. The time is so complicated, because it is a high frequency data set of an exchange rate. In all other columns are exchange rates. Every entry is separated by a comma. When I use the Import Wizard of Matlab, it separates the data into two sets. In the first set (text file) are only the variable names and the whole column time and in the second data set are all exchange rates. How can I read in the csv-file correctly and as a whole? Thank you in advance!
댓글 수: 6
José-Luis
2013년 1월 8일
How do you expect to convert the time to a number? I don't really understand how you want your data to look like. If you want a single matrix, then you can concatenate whatever it is that you obtain and save everything to a cell array.
per isakson
2013년 1월 8일
I have answered similar questions a number of time here at Answer. I would use textscan.
채택된 답변
Matt J
2013년 1월 8일
편집: Matt J
2013년 1월 8일
If you want date info and numeric info to co-exist in a matrix (not a cell array), you must first convert the date info into a numeric form, e.g., using the DATENUM command. Then concatenate them together as José-Luis recommends.
The example date you provided, for instance, could be converted as follows
>> datenum('01.01.2004 01:00:00.000','mm.dd.yyyy HH:MM:SS')
ans =
7.3195e+05
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Dates and Time에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!