Determining maximum and minimum Daily temperatures

I have Data from 1985 to 2017 containing the recorded Temperature every hour . The First column contains

1.Date format :

• YYYYMMDDHH

FROM (1985010100 ) (2017123123 )

The second column conains

2.Temperature every hour

Question: I want to determine the maximum and minimum daily temperatures from 1985 to 2017 .

Thank you

[Adam Danz]

Ok, where are you at in this project? Have you loaded the data into matlab? If yes, how are the variables stored? Are you having trouble isolating the data between the two dates? Let us know how we can help you.

Answer 1

[Jon]

If you have exactly 24 data points for each day (one for every hour) then you could use this approach, assume you have your data in an a two dimensional array named data

% determine total number of days of data
numDays = length(data)/24;

% reshape your temperature data so that you have a column for each day, with a row for each hour in the day
Tdata = reshape(data,24,numDays)

% calculate your min and max for each day
dailyMin = min(Tdata);
dailyMax = max(Tdata);

If your data is somehow less regular and you are missing entries for certain hours then you will have to do something more involved

[Jon]

you could also use accumarray for this purpose https://www.mathworks.com/help/matlab/ref/accumarray.html