#!/usr/bin/python
import csv
result = []
for i in [1,2,4,8,11,12,13,14,15,16,17,18,19,20]:
no = str(i)
r1 = csv.DictReader(file(no+".csv"), fieldnames=["datetime", "temp-"+no, "humid-"+no])
result+=list(r1)
#result = sum(result,[]) #flatten list of list
for i in range(len(result)):
result[i]["datetime"] = result[i]["datetime"][:-1]+"0"
result.sort(key=lambda x: x["datetime"])
prev=""
fa = []
for entry in result:
if entry["datetime"] == prev:
fa[-1] = {k: v for dic in [entry, fa[-1]]
for k, v in dic.items()}
else:
fa.append(entry)
prev = entry["datetime"]
print "var data = "
print fa