I have rainfall rasters for each day of the decade 2000 - 2009. Each file is named with the format rYYYYMMDD (eg r20001224 is the rainfall raster for Dec 24th 2000).
I would like to create 'monthly average rainfall' rasters for each month in this decade (10 years x 12 months = 120 rasters).
Rather than manually selecting each daily raster in a month, is there a way to get ArcGIS to select rasters with a common prefix as the input to Raster Calculator? i.e. generate a new raster by averaging all rasters named 'r200001__' (from January 2000).
Ideally, I would like to iterate this process in Model Builder using the Raster Calculator. I'm inexperienced with python coding, but I'm happy to learn if it's the only/best way.
Any advice is appreciated!