1
import pandas as pd
import matplotlib.pyplot as pltstudents pd.read_excel(./Students.xlsx)print(----原始数据----)
print(students)students.sort_values(by2017,inplaceTrue,ascendingFalse)
students.plot.bar(xField,y[2016,2017],color[orange,red])plt.title(I…