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

Referencethe user guide for more examples.

Examples

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

>>>s.unstack(level=-1)     a  bone  1  2two  3  4

>>>s.unstack(level=0)   one  twoa    1    3b    2    4