Read csv file and create a new file
io
maroso at libero.it
Thu Feb 28 15:51:45 EST 2013
The final working code is :
import json
import urllib
import csv
url = "http://bitcoincharts.com/t/markets.json"
response = urllib.urlopen(url);
data = json.loads(response.read())
f = open("/home/io/markets.csv","wb")
c = csv.writer(f)
#apre un file di testo e legge il contenuto del file inserendolo in una
stringa
esclusioni_file = open('/home/io/exclusions.txt','r')
esclusioni = []
for line in esclusioni_file:
esclusioni.append(line.strip())
#print(esclusioni)
# write headers
c.writerow(["Currency","Symbol","Bid", "Ask", "Volume"])
for d in data :
if d["currency"] <> "SLL": #esclude la valuta di secondlife SLL
if d["bid"] is not None and d["ask"] is not None:
if d["symbol"] not in esclusioni:
#print d["symbol"]
c.writerow([str(d["currency"]),str(d["symbol"]),str(d
["bid"]),str(d["ask"]),str(d["currency_volume"])])
#esclusioni.close()
More information about the Python-list
mailing list