Import Json web data source to xls or csv

Cousin Stanley cousinstanley at gmail.com
Wed Feb 20 07:59:46 CET 2013


io wrote:

> ....
> How do i manage to read the data source 
> from http://bitcoincharts.com/t/markets.json
> ....
> I just need currency, symbol, bid, ask, volume
> ....

  Following is a simple way load the json data
  and write the desired fields to a  .csv  file


import json
import urllib

url        = "http://bitcoincharts.com/t/markets.json"

response   = urllib.urlopen( url ) ;

data       = json.loads( response.read() )

list_dicts = [ dict( this ) for this in data ]

f          = open( 'markets.csv' , 'w' ) 

for this_dict in list_dicts :

    currency  = str( this_dict[ 'currency'] )
    symbol    = str( this_dict[ 'symbol' ] )
    bid       = str( this_dict[ 'bid' ] )
    ask       = str( this_dict[ 'ask' ] )
    volume    = str( this_dict[ 'volume' ] )

    this_list = [ currency , symbol , bid , ask , volume ]

    this_str  = ','.join( this_list )

    f.write( this_str + '\n' )

f.close()
  

-- 
Stanley C. Kitching
Human Being
Phoenix, Arizona




More information about the Python-list mailing list