Reading large file in matlab with unique data format -
i dealing loading data 250 mb csv file matlab. data looks following:
col1 col2 col3 col4 col5 1 5/1/2014 1 18.4765 18.1938
when like:
y = csvread('datafile.csv');
the second column date , hence when use csvread, variable y appears following:
1 2014 -5 -1 1 18.4765000000000 18.1938000000000 0 0 0 0 0 0 0
so, problems dealing are:
(1) dates messed (2) row zeros gets added
how read such data file ?
from csvread documentation: read comma-separated value file
your csv file contains contents besides values.
if have microsoft excel can try using xlsread: http://www.mathworks.com/help/matlab/ref/xlsread.html
[num,txt,raw] = xlsread('myfile.xls');
otherwise have done manually, can try function answer:
Comments
Post a Comment