|
马上注册,结交更多好友,享用更多功能^_^
您需要 登录 才可以下载或查看,没有账号?立即注册
x
import numpy as np
import pandas as pd
import statsmodels.api as sm
import statsmodels.formula.api as smf
import matplotlib.pyplot as plt
df = pd.read_excel('COVAR1.xlsx',sheet_name = 'Sheet1') #修改
for year in range(2007,2021):
for semi in [1,0]:
for bank in range(6,38):
select = df.loc[(df['year'] == year) & (df['semi'] == semi)]
row_num = select.shape[0]
Xi = select.iloc[1:row_num,bank]
Mi = select.iloc[1:row_num,4]
mod = smf.quantreg(Xi,Mi)
res = mod.fit(q=.05)
print(res.params)
报错:PatsyError: model is missing required outcome variables
可能是mod = smf.quantreg(Xi,Mi)有问题,但不知道怎么改 |
|