Reading a CSV file with header and times

3 次查看（过去 30 天）
Steven
Steven 2012-1-29
Good Afternoon,
I am having difficulty loading csv files into Matlab. The problem seems to be with the header (which contains strings) and the data values in two of the columns (they contain time values in 00:00 format).
I am able to ignore the header through use of the 'csvread' function, but Matlab won't load the time values and gives me the below errors.
EDU>> x = csvread('SUNY_070054005.csv', 1, 0)
??? Error using ==> dlmread at 145 Mismatch between file and format string. Trouble reading number from file (row 1, field 5) ==> :15,0
Error in ==> csvread at 50 m=dlmread(filename, ',', r, c);
The data in the CSV file are in the following format...
Date,Itime,Uglo,Udir,Udif,Stime,Sglo,Sdir,Sdif
1998-01-01,00:15,0,0,0,01:00,0,0,0
1998-01-01,01:15,0,0,0,02:00,0,0,0
I would use the wizard, but I have to import 281 csv files.
Any help would be appreciated.
Many Thanks,
Steven

请先登录，再回答此问题。

采纳的回答

Sven
Sven 2012-1-30
Hi Steven,
The string you've got for the dates and times aren't automatically recognised as simple dates - you'll need to read them in as strings:
fid = fopen('myFile.txt')
HDRS = textscan(fid,'%s %s %s %s %s %s %s %s %s',1, 'delimiter',',')
DATA = textscan(fid,'%s %s %d %d %d %s %d %d %d','delimiter',',')
fclose(fid)
outCell = cell(size(DATA{1},1), length(HDRS));
for i = 1:length(HDRS)
if isnumeric(DATA{i})
outCell(:,i) = num2cell(DATA{i});
else
outCell(:,i) = DATA{i};
end
end
myStruct = cell2struct(outCell, [HDRS{:}], 2);
Does this work for you? It worked for a small text file that I made from your input. You can convert stringed dates (and times) using the datestr function.
  3 个评论
显示 1更早的评论
Sven
Sven 2012-1-31
Hi Steven, I've updated the answer to do this second part in a way that I thought would be useful. Keep in mind that I've used "%d" which will convert all numbers in the text files to integers. Use "%f" if you need floats.
Steven
Steven 2012-2-5
Sven,
I tried the code you provided and it works :-). I wish I could have thanked you sooner, but I wasn't able to get on earlier in the week.
Thanks again :-)
-Steven

请先登录，再进行评论。

更多回答（1 个）

Stanislav
Stanislav 2013-3-26
编辑：Stanislav 2013-3-26
The easiest way for me is :
path='C:\folder1\folder2\';
data = 'data.xls';
data = dataset('xlsfile',sprintf('%s\%s', path,data));
Of cource you could also do the following:
[data,path] = uigetfile('C:\folder1\folder2\*.xls');
data = dataset('xlsfile',sprintf('%s\%s', path,data));

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by