pandas.api.typing.SeriesGroupBy.describe#

SeriesGroupBy.describe(percentiles=None, include=None, exclude=None)[source]#

Generate descriptive statistics for each group.

Within each group, summarize the central tendency, dispersion, and shape of the Series’s distribution, excluding NaN values. The per-group statistics depend on the Series’s dtype; see Notes.

Parameters:

percentileslist-like of numbers, optional: The percentiles to include in the output. All should fall between 0 and 1. The default, None, returns the 25th, 50th, and 75th percentiles.
includeNone: Has no effect on a Series groupby. Deprecated and will be removed in a future version.
excludeNone: Has no effect on a Series groupby. Deprecated and will be removed in a future version.

Returns:

DataFrame: One row per group; columns are the per-group statistics.

See also

Series.describe: Generate descriptive statistics of a Series.
DataFrameGroupBy.describe: Generate descriptive statistics for each group of a DataFrame.

Notes

For numeric Series, the per-group columns are count, mean, std, min, max, and the requested percentiles. By default the lower percentile is 25 and the upper is 75; the 50 percentile is the same as the median.

For object Series (e.g. strings), the per-group columns are count, unique, top, and freq. The top is the most common value within the group and freq is its count.

Examples

>>> s = pd.Series([1, 2, 3, 4])
>>> s.groupby([1, 1, 2, 2]).describe()
   count  mean       std  min   25%  50%   75%  max
1    2.0   1.5  0.707107  1.0  1.25  1.5  1.75  2.0
2    2.0   3.5  0.707107  3.0  3.25  3.5  3.75  4.0