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

Question

Sunil Oulkar 2017-1-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/320781-i-have-an-excel-file-which-consists-of-1st-column-is-dates-and-time-and-other-n-rows-and-n-colum

评论： John Chilleri 2017-1-29

采纳的回答： Peter Perkins

Please see the input and output file attachment for reference.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Sunil Oulkar 2017-1-17

from morning 6 am to 5:59 pm day and 6 pm to 5:59 am night

Sunil Oulkar 2017-1-17

I want day data and night data in two separate file

请先登录，再进行评论。

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

Answer 1

Peter Perkins 2017-1-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/320781-i-have-an-excel-file-which-consists-of-1st-column-is-dates-and-time-and-other-n-rows-and-n-colum#answer_251190

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

John Chilleri 2017-1-19

I'm going to have to check this out for myself! Always enlightening to hear of built in solutions!

请先登录，再进行评论。

Answer 2

John Chilleri 2017-1-18

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/320781-i-have-an-excel-file-which-consists-of-1st-column-is-dates-and-time-and-other-n-rows-and-n-colum#answer_251042

编辑：John Chilleri 2017-1-18

在 MATLAB Online 中打开

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);