pandas.core.groupby.DataFrameGroupBy.quantile

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

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

Parameters

q:float 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.

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