application_vnd.jupyter.stderr_output_1.png
import glob

import pandas as pd

station = 68241
def Datastations(station, path):
    allFiles = glob.glob(path + '/*.csv')
    list_ = []
    array = ['T', 'MinT', 'MaxT', 'Precip', 'AIR_TEMP', 'AIR_TEMP_MIN', 'AIR_TEMP_MAX', 'PRCP']
    for file_ in allFiles:
        df = pd.read_csv(file_, index_col=None, header=0)
        df = df[df.station_number == station]
        df = df.loc[df['parameter'].isin(array)]
        list_.append(df)
    frame = pd.concat(list_, ignore_index=True)
    return frame
df1 = Datastations(station, 'refdata/obs')
df2 = Datastations(station, 'refdata/BoM_ETA_20160501-20170430/obs')
print(len(df1))
print(df1.head())
print(len(df2))
print(df2.head())