在同一图上绘制多个Excel张

Question

我有我需要绘制的excel文件。到目前为止，我的代码看起来像这样

import pandas as pd 
import matplotlib.pyplot as plt

file = 'weatherdata.xlsx'


def plotMeteoData(file,x_axis,metric,*list_of_cities):
    
    df = pd.ExcelFile(file)
    sheets = df.sheet_names
    print(sheets)
    df_list = []
    for city in list_of_cities:
        df_list.append(df.parse(city))

    x=range(len(df_list[0][x_axis].tolist()))
    width = 0.3
    
    for j,df_item in enumerate(df_list):
        plt.bar(x,df_item[metric],width,label = sheets[j]) #this isn't working
        x = [i+width for i in x]
        
    
   
    plt.xlabel(x_axis)
    plt.ylabel(metric)
    
    plt.xticks(range(len(df_list[0][x_axis].tolist())),labels=df_list[0][x_axis].tolist())

    


    plt.show()
    
t=['Αθήνα','Θεσσαλονίκη','Πάτρα']
plotMeteoData(file,'Μήνας','Υγρασία',*t)

，并给出 this 输出。 每种颜色代表Excel板，X轴代表月份，Y轴代表某些值。 我已经评论了我试图为每张纸添加一些标签的行，但我无法。另外，如果您查看上述输出，则条形不会以每个XTICK为中心。我该如何解决这些问题？谢谢

Answer 1

通常，您会使用plt.subplots，因为它使您可以更多地控制图形。下面的代码计算XTICK标签所需的偏移量，并用城市标签显示传奇：

import pandas as pd
import matplotlib.pyplot as plt

file = 'weatherdata.xlsx'


def plotMeteoData(file,x_axis,metric,*list_of_cities):
    df = pd.ExcelFile(file)
    sheets = df.sheet_names
    print(sheets)
    df_list = []
    for city in list_of_cities:
        df_list.append(df.parse(city))

    x=range(len(df_list[0][x_axis].tolist()))
    width = 0.3

    # Calculate the offset of the center of the xtick labels 
    xTickOffset = width*(len(list_of_cities)-1)/2
    
    # Create a plot
    fig, ax = plt.subplots()
    
    for j,df_item in enumerate(df_list):
        ax.bar(x,df_item[metric],width,label = sheets[j]) #this isn't working
        x = [i+width for i in x]

    ax.set_xlabel(x_axis)
    ax.set_ylabel(metric)

    # Add a legend (feel free to change the location)
    ax.legend(loc='upper right')

    # Add the xTickOffset to the xtick label positions so they are centered
    ax.set_xticks(list(map(lambda x:x+xTickOffset, range(len(df_list[0][x_axis].tolist())))),labels=df_list[0][x_axis].tolist())
    
    plt.show()
    
t=['Athena', 'Thessaloniki', 'Patras']
plotMeteoData(file,'Month','Humidity',*t)

结果图：

XTICK偏移量应考虑不同数量的Excel页面。参见 this 以获取有关传说的更多信息。