You are viewing documentation about an older version (1.26.0). View latest version

snowflake.snowpark.modin.plugin.extensions.groupby_overrides.SeriesGroupBy.median¶

SeriesGroupBy.median(numeric_only: bool = False)[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.26.0/snowpark-python/src/snowflake/snowpark/modin/plugin/extensions/groupby_overrides.py#L703-L710)¶

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