import pandas as pd
from glob import glob

data = sorted(glob('*WRF-NARR*PREC*.csv'))
df = pd.DataFrame()

def fread(ifile, loc):
    df = pd.read_csv(ifile)
    df.index = pd.to_datetime(df.Date)
    df = df[df.columns[1:]]
    df = df.resample('1D').sum()
    df = df.melt(ignore_index=False)
    df['Location'] = loc
    df = df[(df.index.year >= 1980) & (df.index.year <= 2020)]
    return df
    
for ifile in data:
    loc = ifile.split('_')[0]     
    print(ifile, loc)
    his = fread(ifile, loc)
    fut = fread(ifile.replace('WRF-NARR', 'AllGCM'), loc)
    
    df = pd.concat([df, his, fut])

df.to_csv('qc_tab.csv')