import pandas as pd import matplotlib.pyplot as plt
mat_data = pd.read_excel('./football_data.xlsx') data1=mat_data[mat_data['Country']=='Spain'] data2=data1[data1['Year']==2016] data3=data1[data1['Year']==2017] data4=data1[data1['Year']==2018] data5=data1[data1['Year']==2019] data6=data1[data1['Year']==2020]
pandas的dataframe支持标签内筛选数据,还是很强的,包装了遍历的方法。
plt.bar(data2['Player Names'], data2['Goals']) plt.xticks(rotation=270) 如果X轴坐标太挤可以xticks方法旋转270度 plt.title('Player Names-Goals') plt.xlabel('Player Names')