Dirk Strider

4 days ago

Verified

A user of established repute

🎃PUMPKIN PATCH🎃

A badge for particularly hellacious heels.

@timaeusTestified[TT]

> import sqlite3,csv,urllib2 database=sqlite3.connect('amazonrankscom.db') cursor=database.cursor() for isbn in [[row[0],row[1]] for row in csv.reader(open('isbns.csv','rb'),delimiter=',')]: try: therank=urllib2.urlopen('http://www.amazon.com/dp/'+isbn[1]).read().split(' in Luxury ')[0][-10:].replace('\n','').replace(',','').replace('#','') database.execute('insert into ranks values("'+isbn[1]+'","'+time.strftime("%Y-%m-%d",time.gmtime())+'","'+therank+'")') except: print isbn[0]+' messed up' database.commit() @gynarchsGoverness USERID : DSTRI4224HP Dispatch in thirty.