图a
图b
(1)在对表格进行数据整理时发现,“日期”可能存在的数据问题是
(2)程序代码如下所示,请在划线处填入合适的代码
import matplotlib.pyplot as plt
import pandas as pd
plt.rcParams["font.sans-serif"] = ["SimHei"] #设置中文字体
df = pd.read_excel("temp.xlsx")
df["温差"] =
s = df.sort_values("温差", ascending=False, ignore_index=True)
df_max =
print(df_max)
df_t = s.groupby("天气", as_index=False).count()
df_t = df_t.rename(columns={"日期": "天数"}) #修改列名"日期"为"天数"
x = df_t["天气"]
y = df_t["天数"]
plt.legend()
plt.show()
(3)观察图b,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

