MATLAB: How to separate each day of this file

data importfor loopfunctionMATLABmatricesmatrixmatrix arraytabletext file

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.

Best Answer

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

Related Solutions

MATLAB: How to separate each month of this file

M=cell(1,12);
cy=[0,31,59,90,120,151,181,212,243,273,304,334,365]*24;
for k=2:13
    M{k-1}=yourMatrix(cy(k-1)+1:c(k),:);
end

MATLAB: Averaging files with different dates

years = 1978:2009
for y = years
    pattern = sprintf('*_%d.txt', y);
    d = dir(pattern);
    Nfiles = numel(d);
    average = 0;
    for i = 1:numel(d)
       filename = d(i).name;
       % read data from filename
       % insert your function here
       % assume that the data is read into variable 'data'
       average = average + 1/Nfiles*data;
    end
    average_filename = sprintf('avg_%d.txt', y);
    % write data to file, e.g., using dlmwrite
    dlmwrite(average_filename, average)
  end

Best Answer

Related Solutions

MATLAB: How to separate each month of this file

MATLAB: Averaging files with different dates

Related Question