pydata_week2_hw.py

import requests
import json
import xml.etree.ElementTree as et
import pandas as pd
from IPython.display import display
 
res_weather = requests.get('http://www.kma.go.kr/wid/queryDFSRSS.jsp?zone=1159068000')
#res_weather.content
weather = et.fromstring(res_weather.content)
df_weathers = []

if weather.find('channel/item/description/body') is not None:
    body_rows = weather.find('channel/item/description').iter('body')
     
    for body_row in body_rows.next():
        df_weather = pd.DataFrame(columns=['name', 'value'])
        data_rows = body_row.iter('data')
 
        for data_row in data_rows.next():
            r = dict(zip(['name', 'value'],[data_row.tag, data_row.text]))
            r_s = pd.Series(r)
            df_weather = df_weather.append(r_s, ignore_index=True)
        df_weathers.append(df_weather);

for i in range(0, len(df_weathers)):
    df_weathers[i] = df_weathers[i].replace({'hour' : '시각'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'day'  : '날짜(0:오늘 1:내일 2:모레)'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'temp' : '기온'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'tmx'  : '최고기온'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'tmn'  : '최저기온'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'wfKor': '한국어 날씨(1:맑음 2:구름조금 3:구름많음 4:흐림 5:비 6:눈/비 7:눈)'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'wfEn' : 'Weather(1:Clearly 2:Little Cloudy 3:Mostly Cloudy 4:Cloudy 5:Rainy 6:Snow/Rain 7:Snow)'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'pop'  : '강수확율'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'ws': '풍향'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'wdKor': '풍향'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'wdEn' : 'wind direction'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'wd': '풍향(시방향)'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'reh' : '습도'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'pty' : '강수상태(0:없음  1:비  2: 비/눈  3: 눈/비  4:눈)'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'s12' : '12시간 예상강설량'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'r12' : '12시간 예상강수량'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'s06' : '12시간 예상강설량'}, regex=True)
    df_weathers[i] = df_weathers[i].replace({'s06' : '12시간 예상강수량'}, regex=True)
    display(df_weathers[i])