运行MixedLM并希望将输出推送到Excel或CSV,请参阅下面的模型代码和输出:model = smf.mixedlm('y_var ~ gas_prices', dfModel,
groups = dfModel['region'])
mdf = model.fit()
print(mdf.summary())
Mixed Linear Model Regression Results
======================================================================
Model: MixedLM Dependent Variable: yVar
No. Observations: 420 Method: REML
No. Groups: 4 Scale: 45635645671.2271
Min. group size: 105 Likelihood: -5720.8133
Max. group size: 105 Converged: Yes
Mean group size: 105.0
----------------------------------------------------------------------
Coef. Std.Err. z P>|z| [0.025 0.975]
----------------------------------------------------------------------
Intercept 3241461.947 112718.823 28.757 0.000 3020537.112 3462386.781
gas_prices -118128.471 46931.809 -2.517 0.012 -210113.126 -26143.816
xVar2 275.017 165.072 1.666 0.096 -48.518 598.553
groups RE 0.002
======================================================================
我尝试过推送mdf.summary().to_excel,但没用,除了用mdf.summary()创建Pandas数据框,然后再推到Excel,也没用。在
这里的额外优点是为Excel中的每个输出创建一个唯一的文件名,这样如果我运行一些模型,它们就不会互相覆盖。在
我怎样才能把这个放到Excel上?在