#!/usr/bin/python3
import pandas as pd
from glob import glob
import os

data = sorted(glob('data*'))

df = pd.DataFrame()
count=0

for d in data:
    count += 1
    print(d, count)
    loc = os.path.basename(d).replace('data_', '')    
    cdf = pd.read_csv(d, sep='[ ]+', engine='python', header=None)
    df[loc] = cdf[6]

dates = pd.to_datetime(cdf[0], format='%m/%d/%Y-%H:%M:%S')
df.index = dates

df = df[(df.index.year == 2050) & (df.index.month == 12)]
df.to_csv('precip.csv')