pandas+plt操作练习（统计高等数学竞赛获奖）

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
from matplotlib import font_manager

file_path = r"C:\Users\Administrator\Desktop\data analysis\附件：获奖学生名单.xlsx"
df = pd.read_excel(file_path, header=1, sheet_name=0)
myfont = font_manager.FontProperties(fname="C:/Windows/Fonts/simhei.ttf")

plt.figure(figsize=(5,5), dpi=80)

tmp_list = df["院系"].value_counts()

x = tmp_list.index.to_numpy()
_x = np.arange(len(x))
hei = tmp_list.values
plt.xticks(_x, x, fontproperties=myfont, rotation=90)

plt.bar(_x, hei, width=0.5, color='blue')

plt.figure(figsize=(5,5), dpi=80)
award_list = df["获奖"].value_counts()
print(award_list)

index_award_list = award_list.index.tolist()
index_award_list.reverse()
values_award_list = award_list.values

x = index_award_list
_x = np.arange(len(x))
y = values_award_list

plt.bar(_x, y, width=0.5, color='blue')
plt.xticks(_x, x, fontproperties=myfont, rotation=90)