import urllib
from urlobject import URLObject
link1 = "http://website.net/textfile.txt"
f = urllib.urlopen(link1)
mylist = f.readlines()
row = mylist [1];
for row in mylist:
symbol = row.split('|')[0]
url = URLObject("http://website.com/d/quotes.csv?")
wrapper1 = "s="
wrapper2 = "&f=q"
query = (wrapper1 + symbol + wrapper2)
fullurl = url.with_query(query)
fullurl_data = urllib.urlopen(fullurl).readlines(1)
cleaned = (", ".join(fullurl_data))
exdivdate = cleaned.split(',')[0]
if "N/A" not in exdivdate:
print cleaned,
output looks like this
"7/28/2015","a","a","a"
"1/28/2015","b","f","d"
'9/22/2015","d","b","a"
"5/25/2015","a","a","a"
how can I sort by the date? the output should look like this
"1/28/2015","b","f","d"
"5/25/2015","a","a","a"
"7/28/2015","a","a","a"
'9/22/2015","d","b","a"