import pandas as pd
import seaborn as sns
import matplotlib.pyplot as plt
from matplotlib import font_manager, rc
font = font_manager.FontProperties(fname="c:/Windows/Fonts/malgun.ttf").get_name()
rc('font', family=font)
mic1 = pd.read_csv('d:data\\mic1.csv', encoding = 'cp949')
mic2 = pd.read_csv('d:data\\mic2.csv', encoding = 'cp949')
mic3 = pd.read_csv('d:data\\mic3.csv', encoding = 'cp949')
mic4 = pd.read_csv('d:data\\mic4.csv', encoding = 'cp949')
mic=pd.concat([mic1, mic2, mic3, mic4], axis = 0)
mic.columns=['일시', '구분', '미세먼지', '초미세먼지']
mic['년도']=mic['일시'].str.slice(0, 4)
c=mic.groupby('년도')['미세먼지'].sum().reset_index()
c.sort_values('미세먼지', ascending = False) #by = '미세먼지'
#sns.set_style("whitegrid")
plt.figure(figsize=(11,5))
can = pd.read_csv('d:data\\can.csv', encoding = 'cp949')
ax = sns.lineplot(x='년도', y='미세먼지', data=c, color = 'red')
plt.ylim(4000000, 13000000)
plt.legend(['미세먼지'])
ax.set(ylabel=None) # ax설정 변경
