pandas.Series.unstack — pandas 3.0.0.dev0+2100.gf496acffcc documentation (original) (raw)

Series.unstack(level=-1, fill_value=None, sort=True)[source]#

Unstack, also known as pivot, Series with MultiIndex to produce DataFrame.

Parameters:

levelint, str, or list of these, default last level

Level(s) to unstack, can pass level name.

fill_valuescalar value, default None

Value to use when replacing NaN values.

sortbool, default True

Sort the level(s) in the resulting MultiIndex columns.

Returns:

DataFrame

Unstacked Series.

Notes

Reference the user guide for more examples.

Examples

s = pd.Series( ... [1, 2, 3, 4], ... index=pd.MultiIndex.from_product([["one", "two"], ["a", "b"]]), ... ) s one a 1 b 2 two a 3 b 4 dtype: int64

s.unstack(level=-1) a b one 1 2 two 3 4

s.unstack(level=0) one two a 1 3 b 2 4