okimport pandas as pd
import sys
import os

args = sys.argv
ifile = args[1]
out = 'summary.csv'

df = pd.read_csv(ifile, sep='\t', header=None)
df.columns = ['prec', 'tmax', 'tmin', 'wnd']


dmed = df.median().rename(lambda x: str(x) + '_median')
dmean = df.mean().rename(lambda x: str(x) + '_mean')
dmin = df.min().rename(lambda x: str(x) + '_min')
dmax = df.max().rename(lambda x: str(x) + '_max')
dsum = df.sum().rename(lambda x: str(x) + '_sum')
dall = dmed.append(dmean).append(dmin).append(dmax).append(dsum)
dall = pd.DataFrame(dall)
dall.columns = [ifile]
dall = dall.T
dall.index.name = 'loc'

if os.path.exists(out):
    dall.to_csv(out, mode='a', float_format='%0.3f', header=False)
else:
    dall.to_csv(out, float_format='%0.3f')