import pandas as pd
city8_fullname_py = ['beijing','chongqing','wuhan','shenzhen','nanjing','guangzhou','chengdu','shanghai']
city8_fullname = ['北京','重慶','武漢','深圳','南京','廣州','成都','上海']
 
weather_dic = {}
for i in range(len(city8_fullname)):
    df = pd.DataFrame(pd.read_excel('./2021年城市氣溫?cái)?shù)據(jù)/2021年氣溫?cái)?shù)據(jù)'+city8_fullname_py[i]+'.xls'))
    weather_dic[city8_fullname[i]] = df[['日期','最高溫','最低溫','氣候類型']]
    weather_dic[city8_fullname[i]]['城市'] = pd.Series([city8_fullname[i]]*df.shape[0])
weather = weather_dic[city8_fullname[0]]
for i in range(1,8):
    weather = pd.concat([weather,weather_dic[city8_fullname[i]]],ignore_index="true")

import joypy
import matplotlib.pyplot as plt
 
plt.figure(dpi= 90)
fig, axes = joypy.joyplot(weather, column=['最高溫', '最低溫'], by="城市", figsize=(13,9),
                          fill=True, legend=True,alpha=.8,
                          xlabelsize=18,ylabelsize=18,color=['tomato','dodgerblue']
                          )
plt.title('八大城市過去一年氣溫分布', fontsize=25,verticalalignment='bottom' )
plt.savefig(r'./繪圖結(jié)果/天氣-過去一年氣溫分布-嵴線圖.png')