Passing pandas groupby result to html in a pretty way

Question

I wonder how could I pass python pandas groupby result to html formatted such as printed in console. Pic below. to_html does not work because It says that

Series object has no attribute to_html()

The one on the left is from console the one from the right is from my html view.

iacob · Accepted Answer · 2020-07-06T15:43:24.890

2

Using reset_index() on your GroupBy object will enable you to treat it as a normal DataFrame i.e. apply to_html to it.

edited Jul 06 '20 at 15:43

answered Jul 04 '18 at 11:04

iacob

20,084
6
92
119

score 0 · Answer 2 · answered Jul 04 '18 at 11:10

You can make sure you output a DataFrame, even if the output is a single series.

I can think of two ways.

results_series = df[column_name]  # your results, returns a series
# method 1: select column from list, as a DataFrame
results_df = df[[column_name]] # returns a DataFrame
# method 2: after selection, generate a new DataFrame
results_df = pd.DataFrame(results_series)
# then, export to html
results_df.to_html('output.html')

Passing pandas groupby result to html in a pretty way

2 Answers2