Table Of Contents

Search

Enter search terms or a module, class or function name.

pandas.DataFrame.max

DataFrame.max(axis=None, skipna=None, level=None, numeric_only=None, **kwargs)[source]
This method returns the maximum of the values in the object.
If you want the index of the maximum, use idxmax. This is the equivalent of the numpy.ndarray method argmax.
Parameters:
axis : {index (0), columns (1)}

skipna : boolean, default True

Exclude NA/null values when computing the result.

level : int or level name, default None

If the axis is a MultiIndex (hierarchical), count along a particular level, collapsing into a Series

numeric_only : boolean, default None

Include only float, int, boolean columns. If None, will attempt to use everything, then use only numeric data. Not implemented for Series.

Returns:
max : Series or DataFrame (if level specified)

Examples

MultiIndex series example of monthly rainfall

>>> index = pd.MultiIndex.from_product(
...     [['London', 'New York'], ['Jun', 'Jul', 'Aug']],
...     names=['city', 'month'])
>>> s = pd.Series([47, 35, 54, 112, 117, 113], index=index)
>>> s
city      month
London    Jun       47
          Jul       35
          Aug       54
New York  Jun      112
          Jul      117
          Aug      113
dtype: int64
>>> s.max()
117

Max using level names, as well as indices

>>> s.max(level='city')
city
London       54
New York    117
dtype: int64
>>> s.max(level=1)
month
Jun    112
Jul    117
Aug    113
dtype: int64
Scroll To Top