Unstack, also known as pivot, Series with MultiIndex to produce DataFrame. Parameters ---------- level : int, str, or list of these, default last level Level(s) to unstack, can pass level name. fill_value : scalar value, default None
(
self,
level: IndexLabel = -1,
fill_value: Hashable | None = None,
sort: bool = True,
)
| 4443 | return self._constructor(values, index=index, name=self.name, copy=False) |
| 4444 | |
| 4445 | def unstack( |
| 4446 | self, |
| 4447 | level: IndexLabel = -1, |
| 4448 | fill_value: Hashable | None = None, |
| 4449 | sort: bool = True, |
| 4450 | ) -> DataFrame: |
| 4451 | """ |
| 4452 | Unstack, also known as pivot, Series with MultiIndex to produce DataFrame. |
| 4453 | |
| 4454 | Parameters |
| 4455 | ---------- |
| 4456 | level : int, str, or list of these, default last level |
| 4457 | Level(s) to unstack, can pass level name. |
| 4458 | fill_value : scalar value, default None |
| 4459 | Value to use when replacing NaN values. |
| 4460 | sort : bool, default True |
| 4461 | Sort the level(s) in the resulting MultiIndex columns. |
| 4462 | |
| 4463 | Returns |
| 4464 | ------- |
| 4465 | DataFrame |
| 4466 | Unstacked Series. |
| 4467 | |
| 4468 | See Also |
| 4469 | -------- |
| 4470 | DataFrame.unstack : Pivot the MultiIndex of a DataFrame. |
| 4471 | |
| 4472 | Notes |
| 4473 | ----- |
| 4474 | Reference :ref:`the user guide <reshaping.stacking>` for more examples. |
| 4475 | |
| 4476 | Examples |
| 4477 | -------- |
| 4478 | >>> s = pd.Series( |
| 4479 | ... [1, 2, 3, 4], |
| 4480 | ... index=pd.MultiIndex.from_product([["one", "two"], ["a", "b"]]), |
| 4481 | ... ) |
| 4482 | >>> s |
| 4483 | one a 1 |
| 4484 | b 2 |
| 4485 | two a 3 |
| 4486 | b 4 |
| 4487 | dtype: int64 |
| 4488 | |
| 4489 | >>> s.unstack(level=-1) |
| 4490 | a b |
| 4491 | one 1 2 |
| 4492 | two 3 4 |
| 4493 | |
| 4494 | >>> s.unstack(level=0) |
| 4495 | one two |
| 4496 | a 1 3 |
| 4497 | b 2 4 |
| 4498 | """ |
| 4499 | from pandas.core.reshape.reshape import unstack |
| 4500 | |
| 4501 | return unstack(self, level, fill_value, sort) |
| 4502 |