MATLAB: Find out the mean of each year and month from temperature data of 1890-2018

time seriestimetable

How can I find out the mean of the temperature of each year if I have a big dataset 1890-2018. I would also like to separate the data in to 12 months for all the year to see the seasonal variation. The year of the data has already shown as the Matlab time. I do not know how the select the data of each year to find the mean.

Best Answer

If you have your data stored in a timetable, use the retime function. Use the "Aggregate Timetable Data and Calculate Mean Values" example on the retime documentation page as a model, changing how it aggregates the data from 'hourly' to 'monthly' or 'yearly'.

Related Solutions

MATLAB: Monts in year sequence, string, matrix

Convert to a timeseries() object and use retime()

Or:

Data = rand(365,1);
Data_timestamp = datetime(2021, 1, 1:365).';  %use non-leap year !
month_totals = accumarray(month(Data_timestamp), Data)
month_totals = 12×1
   17.6917
   12.5502
   14.1349
   17.2993
   14.2127
   17.4742
   16.3479
   14.0845
   13.4153
   15.4119

MATLAB: How to separate month, day of the week, and hour of the day for each row of a csv time series file so that I can do a factor analysis for month, day, hour

Use a timetable!

https://www.mathworks.com/help/matlab/timetables.html

https://www.mathworks.com/help/matlab/matlab_prog/create-timetables.html

Import your csv file as table and then create a timetable from it .Then you can do whatever you want to do with it, like monthly mean, yearly sum, etc. For example,

data_table = readtable('yourfile.csv');
data_timetable = table2timetable(data_table);

and then you could use retime

https://www.mathworks.com/help/matlab/ref/retime.html

 hourly_mean_table = retime(data_timetable,'hourly','mean')

Best Answer

Related Solutions

MATLAB: Monts in year sequence, string, matrix

MATLAB: How to separate month, day of the week, and hour of the day for each row of a csv time series file so that I can do a factor analysis for month, day, hour

Related Question