我正在使用 pandas.stats.api.ols
进行OLS回归,使用以下代码进行 groupby
:
from pandas.stats.api import ols
df=pd.read_csv(r'F:\file.csv')
result=df.groupby(['FID']).apply(lambda d: ols(y=d.loc[:, 'MEAN'], x=d.loc[:, ['Accum_Prcp', 'Accum_HDD']]))
for i in result:
x=pd.DataFrame({'FID':i.index, 'delete':i.values})
frame = pd.concat([x,DataFrame(x['delete'].tolist())], axis=1, join='outer')
del frame['delete']
print frame
但是这会返回错误:
AttributeError: 'OLS' object has no attribute 'index'
我有大约2000个按组分类的项目,当我打印每一个时,它们看起来像这样:
-
------------------------Summary of Regression Analysis-------------------------
Formula: Y ~ <Accum_Prcp> + <Accum_HDD> + <intercept>
Number of Observations: 79
Number of Degrees of Freedom: 3
R-squared: 0.1242
Adj R-squared: 0.1012
Rmse: 0.1929
F-stat (2, 76): 5.3890, p-value: 0.0065
Degrees of Freedom: model 2, resid 76
-----------------------Summary of Estimated Coefficients------------------------
Variable Coef Std Err t-stat p-value CI 2.5% CI 97.5%
--------------------------------------------------------------------------------
Accum_Prcp 0.0009 0.0003 3.28 0.0016 0.0004 0.0015
Accum_HDD 0.0000 0.0000 1.98 0.0516 0.0000 0.0000
intercept 0.4750 0.0811 5.86 0.0000 0.3161 0.6340
---------------------------------End of Summary---------------------------------
我希望能够将每个项目导出为csv文件,这样我就可以单独查看它们。
ols.summary()
实际上是以文本形式输出的,而不是作为DataFrame
。我通常会将其打印到一个或多个文本文件中进行存储。 - Stefanfor i in result: i.to_csv(os.path.join(outpath, i +'.csv')
时,它会返回AttributeError: 'OLS' object has no attribute 'to_csv'
。 - Stefano PotterOLS
例程?是statsmodels
吗? - Stefanpandas.stats.api
。 - Stefano Potter