How can I read the following input csv file into matlab.
mid cid rate value date
1262 24294 4 ? 7/4/04
1810 18187 3 ? 3/12/04
2000 23573 5 ? 1/20/05
3312 25907 1 ? 5/12/05
I want to have a matrix that has 5 columns [mid, cid, rate, value, date]
NOTE: the "value" column should be -1 instead of the question mark.
I try to use cvsread but it gives an error.
Thanks!
Have a look at this answer to this question. I think it does exactly what you want.
You may try textscan and manually convert the date column using datenum
fid = fopen('datafile.csv');
data = textscan(fid, '%f %f %f %s', 'Delimiter', ',', 'HeaderLines', 1);
fclose(f);
data{4} = datenum(data{4});
will return a cell array data of doubles where the fourth column is the MATLAB datenum corresponding to each date, and each other column is the corresponding column from the file.
Using this approach, you will need to read the header line separately. It can easily be done like this:
mid = data{1}; % etc...
You may also read the names from file and use eval to do the assigning, but if the number of columns is small, I recommend avoiding eval.
