

import pandas as pd
import matplotlib.pyplot as plt
plt.rcParams['font.sans-serif']=['SimHei'] #设置中文字体
df=pd.read_excel("weather.xlsx")
df.at[①
dfl=df.sort_values("温差",ascending-=False)
df2=②_________
print(df2) #输出温差最大的3条记录
df3=df.groupby("天气",as_index=False).③
x=df3["天气"]
y=df3["温差"]
④
plt.legend()
p1t.show()
(1)请在划线①③④处填入合适的代码。
(2)划线②处可以填入的代码有
A.df1.head(3) B.df1.tail(3)
C.df1[:3] D.df1[-3:]
(3)观察图表,发现温差最大的天气是

同类型试题

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

