I have an excel file ... which consists of 1st column is dates and time and other n rows and n columns data.... in this file, I have daily 1-hour data, I want day night data separate for the reference I have attached output file. Please find input an

1 次查看（过去 30 天）
Sunil Oulkar
Sunil Oulkar 2017-1-17
评论： John Chilleri 2017-1-29
Please see the input and output file attachment for reference.
  3 个评论
显示 1更早的评论

请先登录，再进行评论。

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

采纳的回答

Peter Perkins
Peter Perkins 2017-1-19
I recommend using readtable, using the %D format to create datetimes. Then it's easy to select rows of the table by day and night using timeofday. Then use writetable to write out the separate data.

更多回答（1 个）

John Chilleri
John Chilleri 2017-1-18
编辑：John Chilleri 2017-1-18
Hello,
Here is code that does what you want. You'll need to have two blank files in your directory named "outputfileDAY.csv" and "outputfileNIGHT.csv" - it will write day and night to these files respectively. Furthermore, you need to have "inputfile.csv" in your directory from which the code will pull the data, please have it in csv format. Note that your input/output files have a different number of entries so it was weird to compare, but I checked the results and the code worked:
% Code to separate by time
%
% Acquiring and splitting data
fid = fopen('inputfile.csv','rt');
dayandnight = textscan(fid,'%s %f %f %f %f', 'Delimiter', ',',...
'CollectOutput', 1);
%
% Acquiring times from date
fileid1 = fopen('outputfileDAY.csv','w');
fileid2 = fopen('outputfileNIGHT.csv','w');
for i = 1:size(dayandnight{1},1)
Time = dayandnight{1}{i}(end);
j = 0;
while (Time(1) ~= ' ')
Time = dayandnight{1}{i}(end-j:end);
j = j+1;
end
Time = Time(2:end);
if (Time(2) == ':')
Time = Time(1);
else
Time = Time(1:2);
end
if ((str2num(Time) >= 6)&&(str2num(Time) < 18))
fprintf(fileid1,'%s,%f,%f,%f,%f\n',dayandnight{1}{i},dayandnight{2}(i,1),...
dayandnight{2}(i,2),dayandnight{2}(i,3),dayandnight{2}(i,4));
else
fprintf(fileid2,'%s,%f,%f,%f,%f\n',dayandnight{1}{i},dayandnight{2}(i,1),...
dayandnight{2}(i,2),dayandnight{2}(i,3),dayandnight{2}(i,4));
end
end
fclose(fileid1);
fclose(fileid2);
Please comment if you have any questions!
Hope this helps!

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by