Introduction

Many pandas groupby operations return a Series with a MultiIndex, especially when you aggregate a single column by multiple grouping keys. Converting that result back into a DataFrame is usually simple, but the right method depends on whether you want a flat table, a one-column DataFrame, or a pivoted layout.

Start With a Typical GroupBy Result

Here is a small example that produces a multi-indexed series:

1import pandas as pd
2
3df = pd.DataFrame({
4    "team": ["A", "A", "B", "B"],
5    "city": ["X", "Y", "X", "Y"],
6    "score": [10, 15, 10, 20],
7})
8
9grouped = df.groupby(["team", "city"])["score"].sum()
10print(grouped)

The result is a Series whose index contains both team and city. That is useful for some operations, but awkward for reporting or later joins.

Use reset_index for a Flat DataFrame

If you want the grouping levels back as normal columns, use reset_index. This is usually the most practical answer.

result = grouped.reset_index(name="total_score")
print(result)

That produces a regular DataFrame with columns such as team, city, and total_score. For many workflows, this is the cleanest format because it behaves like ordinary tabular data again.

Use to_frame When You Want to Keep the Index

If you want a DataFrame but still want to preserve the multi-index, use to_frame.

result = grouped.to_frame(name="total_score")
print(result)

This gives you a one-column DataFrame whose index is still the original multi-index. That is useful when downstream code expects indexed group results rather than flat columns.

Use unstack for a Pivoted Shape

Sometimes you do not want a flat table at all. You want one index level to become columns. In that case, unstack is often the right choice.

result = grouped.unstack(fill_value=0)
print(result)

With the sample data, team stays on the rows and city becomes columns. This is convenient for matrix-like analysis or plotting.

Choose the Right Shape for the Next Step

These three conversions are not interchangeable:

• 'reset_index is best for flat tables and later merges,'
• 'to_frame is best when you want to keep the multi-index structure,'
• 'unstack is best when one level should become columns.'

That is why "convert series back to DataFrame" is really a shape question. The right answer depends on what you plan to do next.

Asking that question first usually saves time, because it tells you whether flattening, preserving, or pivoting the index is the real goal.

Example With Multiple Aggregations

If you know you want a DataFrame from the beginning, another option is to avoid the series output entirely by using .agg() on the grouped object.

1result = (
2    df.groupby(["team", "city"])
3      .agg(total_score=("score", "sum"))
4      .reset_index()
5)
6
7print(result)

This often produces cleaner code than converting after the fact, especially when you need more than one aggregated column.

Common Pitfalls

• Using reset_index() without name=... and ending up with an unnamed value column.
• Choosing unstack() when a flat DataFrame was actually needed.
• Forgetting that to_frame() keeps the multi-index instead of flattening it.
• Converting after every operation instead of choosing a better groupby pattern earlier.
• Losing track of whether your grouping keys live in the index or in regular columns.

Summary

• A grouped pandas series can be turned back into a DataFrame in several ways.
• Use reset_index(name=...) for the most common flat-table result.
• Use to_frame(name=...) when you want a DataFrame but still want the multi-index.
• Use unstack() when one index level should become columns.
• In some cases, using agg() directly is cleaner than converting later.