第三题自己的答案

import numpy as np
import pandas as pd

data = pd.read_csv("data_etr.csv")
df = data.pivot(values='KWH',index='DATA_DATE',columns='CONS_NO')
df

QL = df.quantile(0.25)
QU = df.quantile(0.75)
IQR = QU-QL
df[((df>QU+1.5*IQR)|(df<QL-1.5*IQR))]=None
df

df1 = df.agg(['max','min','mean','median','sum','var','skew','kurt'])

datadif = df.diff()
df2 = datadif.agg(['max','min','mean','median','sum','var','skew','kurt'])

df3 = df.quantile(0.05)
df3

df.index=pd.to_datetime(df.index)
df

df4 = df.resample('W').sum().agg(['max','min','mean','median','sum','var','skew','kurt'])
df4

dfm = df.max()*0.9

df5 = df.apply(lambda x:sum(x>x.max()*0.9),axis=0)
df5