process data from csv file

Hi to all. I am trying to process data from a csv file using matlab. The csv file is like below:
Time, Value
1400660853.068, 614
1400661093.002, 641
1400661332.698, 599
So we have the first line as header and the rest of the first and second columns as data. I am interested in the second column which is the value. I would like to get the column as a matrix(not include the header). How could I do that? I tried to use the textscan command as below:
_clear;
close all;
fid=fopen('C:\Users\yyao\Desktop\Luminance_18.csv');
out=textscan(fid,'%f %d','delimiter',',');
date=out{2}
fclose(fid);_
But then I got date = Empty matrix: 0-by-1
Is there anything wrong with my codes? Thanks so much for helping!

 采纳的回答

Romain
Romain 2014-5-21
编辑:Romain 2014-5-21
I suggest you to use the function csvread :
clear;
close all;
out = csvread('C:\Users\yyao\Desktop\Luminance_18.csv',1,0); % start to read at the second row and the first column
value = out(:,2)

1 个评论

Hi,Romain
Thank you so much! It works! It seems that I really have a lot to learn:)

请先登录,再进行评论。

更多回答(0 个)

类别

帮助中心File Exchange 中查找有关 Get Started with MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by