a.get_yaxis().get_major_formatter().set_scientific(False)
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
plt.rcParams['font.sans-serif']=['SimHei']
df = pd.read_excel(r"C:\Users\LiJie\Desktop\demo.xlsx",sheet_name='Sheet3')
x = plt.figure()
a = x.add_subplot(111)
a.bar(df["请求数量"],df["耗时"],color='lightskyblue')
plt.ylabel('耗时(ms)')
plt.xlabel('请求数量')
a.plot(df["请求数量"],df["耗时"],color='r',marker='*')
a.get_yaxis().get_major_formatter().set_scientific(False)
plt.show()