Hey Mohsin,
I understand you would like to rearrange the ‘tmax’ and ‘tmin’ data along with the corresponding dates, where the data should be in ‘mm/dd/yyyy’ format. Currently, the data is organized into two sets, each containing data for six months.
“setDefaultFormats” function can be used to set the datetime to required format.
Here is a sample code that you can use to arrange the data to as required:
% get date for column 1 for required data
datetime.setDefaultFormats('defaultdate','MM/dd/yyyy')
startDate = datetime(1977,1,1);
endDate = datetime(1977,12,31);
dateValues = (startDate:endDate)';
% Extract data
% get column 2 & 3 for the required data
tempValues = [0 0]; %temprature values for 6 months
tempValues = double.empty(tempValues);
% random Sample data representing your 13 columns
filedata = randi(12,31,13);
for i=2:2:12
tempValues=[tempValues;filedata(:,i:i+1)];
end
%similarly calculate the temp2Values for the next six months using correct row number
%I am using the same values for next six months
temp2Values=tempValues;
tempCombined=[tempValues;temp2Values]; %data for 12 months
T=table;
T=addvars(T,dateValues);
T=addvars(T,tempCombined(1:365,1));
T=addvars(T,tempCombined(1:365,2));
T.Properties.VariableNames = ["Date","tmax", 'tmin'];
%Output the data
T
For doing it for multiple years, use this code as a function with datafile and year as input and the result as output.
Please refer the shared MathWorks documentation link for more “setDefaultFormats” related details: https://www.mathworks.com/help/matlab/matlab_prog/set-display-format-of-date-and-time-arrays.html
Hope this helps.
