import csv
import urllib2
import sys

gid=0

if len(sys.argv)>1:
    id=sys.argv[1]
else:
    id="2PACX-1vQoUC81NBeMtPSxHwzkJ-eDtAwiJ7nj-PAx7YH73A7z0NJujhflUsFdT-jaWXT5MIntOq4Mo_-_jIhA"
    gids=[0,1376812983]
    gids=[0,1376812983,1384353379,288631010,66760384,341295867,1488678804,632776893,1594120904]

data={}
for gid in gids:
    url="https://docs.google.com/spreadsheets/d/e/%s/pub?gid=%s&single=true&output=csv" % (id,gid)
    response = urllib2.urlopen(url)
    reader = csv.DictReader(response)
    for row in reader:
        for header, value in row.items():
            try:
                if len(value) > 0:
                    data[header].append(value)
            except KeyError:
                data[header] = [value]

print "# -*- coding: utf-8 -*-"
print "def extrawords():"
print " tw=",data
print " return tw"