import matplotlib.pyplot as plt
import pandas as pd
df=pd.read_excel('총인구수출생아수.xlsx')
plt.rc('font',family='Gulim')
plt.title('남녀인구수')
plt.plot(df['년도'],df['남자(명)']/10000,color='blue',label='남')
plt.plot(df['년도'],df['여자(명)']/10000,color='red',label='여', linestyle='--')
plt.legend()
plt.show()

import pandas as pd
import folium
mymap=folium.Map(location=[33.371296, 126.560056],zoom_start=11)
df=pd.read_excel('전국도시공원정보표준데이터.xls')
df=df.dropna(subset=['위도','경도','소재지지번주소'])
name = input("지역명을 입력하세요")
cond= "소재지지번주소.str.contains('"+name+"')"
df=df.query(cond,engine='python')
for i in range(len(df)):
folium.Marker([float(df['위도'][i:i+1]),float(df['경도'][i:i+1])], popup=df['
공원명'][i:i+1]).add_to(mymap)
mymap

import pandas as pd
import folium
mymap=folium.Map(location=[33.371296, 126.560056],zoom_start=11)
df=pd.read_excel('전국지역특화거리표준데이터.xls')
df=df.dropna(subset=['위도','경도','거리명'])
name = input("지역명을 입력하세요")
cond= "소재지도로명.str.contains('"+name+"')"
df=df.query(cond,engine='python')
for i in range(len(df)):
folium.Marker([float(df['위도'][i:i+1]),float(df['경도'][i:i+1])], popup=df['
거리명'][i:i+1]).add_to(mymap)
mymap

\for i in range(len(df)):
popup_color = "<font color=red>" + df['공원명'][i:i+1] + "</font>"
folium.Marker([float(df['위도'][i:i+1]),float(df['경도'][i:i+1])],
popup=popup_color).add_to(mymap)

folium.Marker([float(df['위도'][i:i+1]),float(df['경도'][i:i+1])],
popup=popup_color,icon=folium.Icon(color='pink')).add_to(mymap)

for i in range(len(df)):
folium.CircleMarker([float(df['위도'][i:i+1]),float(df['경도'][i:i+1])], p
opup=df['공원명'][i:i+1]).add_to(mymap)

import matplotlib.pyplot as plt
import pandas as pd
df=pd.read_excel('주민등록인구.xlsx',thousands=',') #천단위 구분기호 없애기
plt.rc('font',family='Malgun Gothic')
plt.figure(figsize=(10, 5))
plt.title("동별 인구 그래프")
q=input("원하는 동 명을 적으세요")
df1=df.query('행정기관.str.contains("'+q+'")', engine='python')
df1=df1.iloc[0:,4:15]
df1=df1.T
df1=df1.astype(int)
q2=input("원하는 동 명을 적으세요")
df2=df.query('행정기관.str.contains("'+q2+'")', engine='python')
df2=df2.iloc[0:,4:15]
df2=df2.T
d2f=df2.astype(int)
plt.plot(df1,marker='*',color='g',label=q)
plt.plot(df2,marker='o',color='y',label=q2)
plt.legend()
plt.show()