How to separate each day of this file?

Question

Mohamed Nedal 2019-1-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/440270-how-to-separate-each-day-of-this-file

评论： Mohamed Nedal 2020-1-9

采纳的回答： madhan ravi

Jan.txt

Hello,

Kindly find the attached text file. It contains data for the entire January 2014.

Each row represents a data record per hour so that it starts from hour=0 (the 3rd column) to hour=23 and then starts again from hour=0 for the next day, and so on.

I need to loop over the rows and save each day (24 hours; rows) separately in a text file (i.e. d1, d2, ..., d31).

Could you please tell me how to do that?

Thanks in advance.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

madhan ravi 2019-1-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/440270-how-to-separate-each-day-of-this-file#answer_356874

编辑：madhan ravi 2019-1-17

在 MATLAB Online 中打开

https://www.mathworks.com/help/matlab/ref/dlmwrite.html?searchHighlight=dlmwrite&s_tid=doc_srchtitle#btzp57u-1 - adapt precision which suits you the best

T=load('Jan.txt');
TT=mat2cell(T,repmat(24,numel(unique(T(:,2))),1));
for i = 1:numel(unique(T(:,2)))
    dlmwrite(sprintf('file%d',i),TT{i},'precision','%.2f','delimiter',' ') % saves each day in a separate file , filenames will be like file1.txt ... and so on till the end
end

4 个评论
显示 2更早的评论隐藏 2更早的评论

Mohamed Nedal 2019-1-17

Thanks a lot. :)

Yes, I've accepted it.

Mohamed Nedal 2020-1-9

Hi Ravi, i hope you're fine.

Please I would like to ask you one more question.

Kindly find the attached file. It's similar to the previous file (Jan.txt), but it's for the whole year of 2018 (includes all months).

I need to do the same thing as you did, but to separate each month in a separate file and then I will apply your previous code on each one to separate each month into days.

Could you tell me how to separate the whole year into months?

The issue is some months have 30 days, some have 31 days, and April sometimes has 28 days or 29 days.

I really appreciate your help.

请先登录，再进行评论。