Something went wrong. Try again.
moderation music collection code, output, history etc.
Something went wrong. Try again.
moderation moderation.svg.py
795 B · 27 lines
Python
at main
12345678910111213141516171819202122232425262728import csv, urllib, time, datetime, operator, gzip, shutilfrom time import localtime, strftime
# retreive csv data from google docsdata = urllib.urlopen("https://spreadsheets.google.com/a/sooper.org/tq?tqx=out:csv&range=I2:j33&key=0AtnmrDi58ubkdEt5cUtmMndoalNpSWdmYjFuQjhKTFE&gid=1")# print data.read()collection = csv.reader(data.read(), delimiter=',', quotechar='"')
rowcount = len(list(collection)) - 1
print rowcount
# data.seek(0) # reset file iterator after determining number or rowscollection.next()
collection = sorted(collection, key=lambda k: (k[0].lower(), k[2].lower(), k[1].lower()), reverse=False)
data.close()
dstamp = datetime.datetime.utcfromtimestamp(time.time())updated = dstamp.strftime('%Y-%m-%dT%H:%M:%S.000Z')
for row in collection: print row[0]