首先打开jupyter notebook,并读入数据
# import pandas as pd
import matplotlib.pyplot as plt
students=pd.read_excel('E:\\下载练习数据专用\\009\\Students.xlsx')
print(students)
先排序,figsize = (8,6)设置8*6大小的图
students.sort_values(by='Number',inplace=True,ascending=False)
students.plot.bar(figsize = (8,6),x='Field',y='Number',title='international students by field')
如果你用的不是jupyter notebook可能需要加上 plt.show() 这句代码图才会显示出来
完整代码
# import pandas as pd
import matplotlib.pyplot as plt
students=pd.read_excel('E:\\下载练习数据专用\\009\\Students.xlsx')
students.sort_values(by='Number',inplace=True,ascending=False)
students.plot.bar(figsize = (8,6),x='Field',y='Number',title='international students by field')
plt.show()