import pandas as pd

gcms = [
    'csiro-mk3.6.0',
    'his',
    'noresm1-m'
]

locs = [
    ['42.524_-122.753', '45.52389_-122.75250', 'loc1'],
    ['45.617_-123.715', '45.61692_-123.71453', 'loc2'],
    ['47.653_-122.424', '47.65329_-122.32408', 'loc3']
]

df = pd.DataFrame()
for g in gcms:
    for l in locs:
        if g == 'his':
            loc = l[1]
        else:
            loc = l[0]
        dx = pd.read_csv('{}_{}.csv'.format(g, loc))
        dx['T7'] = df.T2.rolling(7).mean()
        dx['T60'] = df.T2.rolling(60).mean()
        times = pd.to_datetime(dx.times)
        dx['doy'] = times.dt.dayofyear
        dx['fdate'] = times.apply(lambda x: "{}-{}-{}".format(2000, x.month, x.day))
        dx['loc'] = l[2]
        dx['gcm'] = g
        df = pd.concat([df, dx])

df.to_csv('/home/disk/rocinante/DATA/temp/crystal_fire/wrf/daily_select/newcombined.csv', index=False)