Also bare in mind that under column Ch1: the time 42:46.0 represents 5:42:46 PM but I am not sure why Excel automatically displays it as shown in the first post.
How do you load a .csv file, skip lines within it, and plot the values?
6 次查看(过去 30 天)
显示 更早的评论
Hi. I seem to have problems loading a .csv file (see attached):
Blah
@Blah
2Blah
Blah
f Blah
fa Blah
Blahasd
Blahasda
vasf Blah
as Blah
asdas Blah
Date Time Ch1:
07/25/2012 42:46.0 96.385
07/25/2012 42:46.0 -177.608
07/25/2012 42:46.0 155.481
07/25/2012 42:46.0 64.15
%Here is my code:
fid = fopen('PULL1.CSV');
% I need to skip the 16 lines. header = textscan(fid, '%s',3,'delimiter', ',',... 'headerLines',16);
data = textscan(fid, '%s %s %s' ,'delimiter', ',');
The problem is that it only recognizes the parameters as strings. Date should be a string. Time should be a floating number. The Ch1 column is a set of values that I want to plot vs. time.
fclose(fid);
采纳的回答
Walter Roberson
2012-9-21
data_to_plot = str2double(data{3});
15 个评论
Walter Roberson
2012-9-25
Use datetick(). You will want to be selective about which time fields you display, as otherwise the tick labels will run into each other.
更多回答(1 个)
per isakson
2012-9-21
编辑:per isakson
2012-9-21
Try
data = textscan( fid, '%s%s%f', 'Headerlines', 16 );
Delimiter is obviously one or many "space" or tab. Default handles that.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Text Data Preparation 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!