Add an excel renderer to the package #83

robbertjan94 · 2022-02-05T18:59:09Z

This PR fixes #77: implementing an excel renderer.

The excel renderer is based on the xlsxwriter package.

Example:

import pandas as pd
from sklearn import datasets
import statsmodels.api as sm
from stargazer.stargazer import Stargazer

diabetes = datasets.load_diabetes()
df = pd.DataFrame(diabetes.data)
df.columns = ['Age', 'Sex', 'BMI', 'ABP', 'S1', 'S2', 'S3', 'S4', 'S5', 'S6']
df['target'] = diabetes.target

est = sm.OLS(endog=df['target'], exog=sm.add_constant(df[df.columns[0:4]])).fit()
est2 = sm.OLS(endog=df['target'], exog=sm.add_constant(df[df.columns[0:6]])).fit()
stargazer = Stargazer([est, est2])

Calling the excel renderer works similar to the html and LaTeX renderers:

stargazer.render_excel(filename='test.xlsx')

Which returns the following table in the test.xlsx file:

robbertjan94 · 2022-02-07T17:12:14Z

stargazer/stargazer.py

+
+                if 'FOOTER' in location.name:
+                    format1['bottom'] = 6
+                    format1['bottom'] = 6


Second format1 should be format2

robbertjan94 added 3 commits February 5, 2022 17:01

Fixed name of footer bottom line location

fb4a6a5

Implemented an excel renderer

533c8c8

Fix format of header

cf9f6c4

robbertjan94 commented Feb 7, 2022

View reviewed changes

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Add an excel renderer to the package #83

Add an excel renderer to the package #83

robbertjan94 commented Feb 5, 2022 •

edited

robbertjan94 Feb 7, 2022 •

edited

Add an excel renderer to the package #83

Are you sure you want to change the base?

Add an excel renderer to the package #83

Conversation

robbertjan94 commented Feb 5, 2022 • edited

robbertjan94 Feb 7, 2022 • edited

Choose a reason for hiding this comment

robbertjan94 commented Feb 5, 2022 •

edited

robbertjan94 Feb 7, 2022 •

edited