pandas.core.groupby.DataFrameGroupBy.quantile

DataFrameGroupBy.quantile(q=0.5, interpolation='linear', numeric_only=_NoDefault.no_default)[source]

Return group values at the given quantile, a la numpy.percentile.

Parameters:
qfloat or array-like, default 0.5 (50% quantile)

Value(s) between 0 and 1 providing the quantile(s) to compute.

interpolation{‘linear’, ‘lower’, ‘higher’, ‘midpoint’, ‘nearest’}

Method to use when the desired quantile falls between two points.

numeric_onlybool, default True

Include only float, int or boolean data.

New in version 1.5.0.

Returns:
Series or DataFrame

Return type determined by caller of GroupBy object.

See also

Series.quantile

Similar method for Series.

DataFrame.quantile

Similar method for DataFrame.

numpy.percentile

NumPy method to compute qth percentile.

Examples

>>> df = pd.DataFrame([
...     ['a', 1], ['a', 2], ['a', 3],
...     ['b', 1], ['b', 3], ['b', 5]
... ], columns=['key', 'val'])
>>> df.groupby('key').quantile()
    val
key
a    2.0
b    3.0