pandas.Series.unstack#

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