modin.pandas.DataFrameGroupBy.median¶

DataFrameGroupBy.median(numeric_only=False)[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.47.0/.tox/docs/lib/python3.9/site-packages/modin/pandas/groupby.py#L1413-L1419)¶

Compute median of groups, excluding missing values.

For multiple groupings, the result index will be a MultiIndex.

Parameters:: numeric_only (bool, default False) – Include only float, int, boolean columns.
Returns:: Median of values within each group.
Return type:: Series or DataFrame

Examples

For SeriesGroupBy:

>>> lst = ['a', 'a', 'a', 'b', 'b', 'b']
>>> ser = pd.Series([7, 2, 8, 4, 3, 3], index=lst)
>>> ser
a    7
a    2
a    8
b    4
b    3
b    3
dtype: int64
>>> ser.groupby(level=0).median()
a    7.0
b    3.0
dtype: float64

For DataFrameGroupBy:

>>> data = {'a': [1, 3, 5, 7, 7, 8, 3], 'b': [1, 4, 8, 4, 4, 2, 1]}
>>> df = pd.DataFrame(data, index=['dog', 'dog', 'dog',
...                   'mouse', 'mouse', 'mouse', 'mouse'])
>>> df
       a  b
dog    1  1
dog    3  4
dog    5  8
mouse  7  4
mouse  7  4
mouse  8  2
mouse  3  1
>>> df.groupby(level=0).median()
         a    b
dog    3.0  4.0
mouse  7.0  3.0