Page History

import csv


def SomeInfoJsonToCSV(filename,jsonData):            
    with open(filename, 'w') as csvfile:
        fieldnames = ['gid','gkey','name','latitude','longitude','region1','region2',
                                     'address','lowestRate','highestRate','mainProvider' ]
        writer = csv.DictWriter(csvfile, fieldnames=fieldnames,lineterminator='\n')
        writer.writeheader()
        for key in jsonData:
            try:
                info = jsonData[key]                        
                someInfo = {'gid':info['gid'],'gkey':info['gkey'],'name':info['name'],'latitude':info['latitude'],'longitude':info['longitude'],'region1':info['region1'],'region2':info['region2'],
                                         'address':info['address'],'lowestRate':info['lowestRate'],'highestRate':info['highestRate'],'mainProvider':info['mainProvider'] }            
                writer.writerow(someInfo)
            except UnicodeError:
                someInfo = {} # 인코딩에러처리                            
                writer.writerow(someInfo)