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