def avg(filename):
df=pd.read_csv(filename)
df1=df[df.columns[2:]] # 取类型及其后的所有列
g=df1.groupby( ① ,as_index=False).mean()
return ②
划线②处应填入的代码为(单选,填字母)。
A.df[df.类型=='AQI'] B.df1.AQI C.g.AQI D.g[g.类型=='AQI']
import pandas as pd
import matplotlib.pyplot as plt
n=10 #城市个数
count=[0]*n
daymax=[0]*n
for i in range(1,31):
day=str(i)
if len(day)<2:
day='0'+str(i)
daydata='202204'+day+'.csv'
dayaqi=avg(daydata)
city=dayaqi.columns[1:n+1]
for j in range(n):
t=city[j]
if dayaqi.at[0,t] <= 100:
else:
if count[j]>daymax[j]:
daymax[j]=count[j]
count[j]=0
for k in range(n):
if count[k]>daymax[k]:
print(daymax)
plt.figure(figsize=(12,4))
x=
y=daymax
plt.bar(x,y)
plt.show()