Page History
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
import requests
import csv
Url = 'http://xxxx/aaaa.txt'
SaveFileName = 'data/aaa.txt'
def downLoadTourH(saveFile):
r = requests.get(url, allow_redirects=True)
open(saveFile, 'wb').write(r.content)
def loadCsvFromTourH():
with open(TourGoodsFileName, newline='\n',encoding='utf-8') as csvfile:
reader = csv.DictReader(csvfile,dialect='excel-tab')
#reader = csv.DictReader(csvfile, delimiter='\t')
for row in reader:
print(row['id'], row['region1'])
downLoadTourH(SaveFileName)
loadCsvFromTourH()
|
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
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)
|