Title
from urllib.request import Request, urlopen
from urllib.parse import urlencode, quote_plus
from xml.etree import ElementTree
import pandas as pd
url =
service_key =
params = '?' + \
urlencode({
quote_plus('ServiceKey') : service_key,
quote_plus('pageNo') : '0',
# quote_plus('num0fRows') : '20',
quote_plus('startCreateDt') : '2020',
quote_plus('endCreateDt') : '20220401',
})
url+params
request = Request(url + params)
response_body = urlopen(request).read()
root = ElementTree.fromstring(response_body)
df = pd.DataFrame()
for item in root.iter('item'):
item_dict = {}
item_dict['기준일시'] = item.find('stdDay').text
item_dict['시도명'] = item.find('gubun').text
item_dict['확진자'] = item.find('defCnt').text
item_dict['전일대비증감'] = item.find('incDec').text
item_dict['해외유입'] = item.find('overFlowCnt').text
item_dict['지역발생'] = item.find('localOccCnt').text
item_dict['사망자수'] = item.find('deathCnt').text
df = df.append(item_dict, ignore_index = True)
df
df['기준일시'] = pd.to_datetime(df['기준일시'], format = '%Y년 %m월 %d일 %H시')
df.sort_values(['기준일시'], inplace = True)
df.reset_index(drop = True, inplace = True)
df.head(19)
df.to_csv('corona_kr.csv', encoding = 'utf-8-sig')