transform raw data to yearly and monthly in a (hopefully) readable fashion