pandas.Series.unstack

Series.unstack(self, level=-1, fill_value=None)

Unstack, a.k.a. pivot, Series with MultiIndex to produce DataFrame. The level involved will automatically get sorted.

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.

Returns

DataFrame

Unstacked Series.

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

pandas.Series.unique pandas.Series.update