
他用Python编写了一个程序,对数据进行分析处理,输出总分大于等于260分的学生信息,并直观显示英语前三名的分数情况,生成了如上图所示的图表。
Python程序代码如下,请在①②③④划线处填上合适的代码:
Import pandas as pd
Import matplotlib.pyplot as plt
Plt.rcParams[’font.sans-serif’]=[’SimHei’]
df=pd.read_excel(“scores.xlsx”)
df[“总分”]=
print(df[
g=df.groupby(“班级”,as_index=False)
print(g.英语.mean())
df1=df.sort_values(“英语”,
Plt.title(“英语成绩前三名分数情况”)
x=df1[0:3].姓名
y=df1[0:3].英语
Plt.bar(x,y)
Plt.legend()
Plt.

同类型试题

y = sin x, x∈R, y∈[–1,1],周期为2π,函数图像以 x = (π/2) + kπ 为对称轴
y = arcsin x, x∈[–1,1], y∈[–π/2,π/2]
sin x = 0 ←→ arcsin x = 0
sin x = 1/2 ←→ arcsin x = π/6
sin x = √2/2 ←→ arcsin x = π/4
sin x = 1 ←→ arcsin x = π/2


y = sin x, x∈R, y∈[–1,1],周期为2π,函数图像以 x = (π/2) + kπ 为对称轴
y = arcsin x, x∈[–1,1], y∈[–π/2,π/2]
sin x = 0 ←→ arcsin x = 0
sin x = 1/2 ←→ arcsin x = π/6
sin x = √2/2 ←→ arcsin x = π/4
sin x = 1 ←→ arcsin x = π/2

