max() – maximum value of column in python pandas

Get the maximum value of column in pandas python : In this tutorial we will learn How to get the maximum value of all the columns in dataframe of python pandas. How to get the maximum value of a specific column or a series by using max() function.  

Syntax of Pandas Max() Function:

DataFrame.max(axis=None, skipna=None, level=None, numeric_only=None)
axis  0 – Rows wise operation
1- Columns wise operation
skipna  Exclude NA/null values when computing the result
 If the axis is a Multi index (hierarchical), count along a particular level, collapsing into a Series
numeric_only  Include only float, int, boolean columns. If None, will attempt to use everything

We will looking at an example on

  • How to get Column wise maximum value of all the column.
  • Get Maximum value of a specific column by name
  • Get Maximum value of series in pandas python
  • Get Maximum value of a specific column by index

Create Dataframe:


import pandas as pd
import numpy as np

#Create a DataFrame
d = {
'Name':['Alisa','Bobby','jodha','jack','raghu','Cathrine',
'Alisa','Bobby','kumar','Alisa','Alex','Cathrine'],
'Age':[26,24,23,22,23,24,26,24,22,23,24,24],

'Score':[85,63,55,74,31,77,85,63,42,62,89,77]}

df = pd.DataFrame(d,columns=['Name','Age','Score'])
df

So the resultant dataframe will be

Get the maximum value of column in dataframe –python pandas

 

Get the maximum value of all the column in python pandas:


# get the maximum values of all the column in dataframe

df.max()

This gives the list of all the column names and its maximum value, so the output will be

Get the maximum value of column in python pandas 1

 

Get the maximum value of a specific column in pandas:

Example 1:


# get the maximum value of the column 'Age'

df['Age'].max()

This gives the maximum value of column “Age” so the output will be

26

 

Example 2:


# get the maximum value of the column 'Name'

df['Name'].max()

This gives the maximum value of column “Name” so the output will be

‘raghu’

 

 

Get the maximum value of a specific column in pandas by column index:

 # get the maximum value of the column by column index

df.iloc[:, [1]].max()

df.iloc[] gets the column index as input here column index 1 is passed which is 2nd column (“Age” column), maximum value of the 2nd  column  is calculated using max() function as shown.

Maximum value of the column in pandas 11

 

 

Get Maximum value of the series in pandas :

Lastly we would see how to calculate the maximum value of a series in pandas by using max() function . First lets create a series of alphabets as shown below

### Create a series 

import pandas as pd
import numpy as np
data = np.array(['a','b','c','d','e','f'])
ser = pd.Series(data,index=[1000,1001,1002,1003,1004,1005])

created series is

Maximum value of the column in pandas 12

Maximum value of a series is calculated using series.max() function as shown below

### Calculate maximum value of a series 

ser.max()

so the resultant max value of the series is

‘ f ‘

 

 previous-small Get the maximum value of column in dataframe –python pandas                                                                                                          next_small Get the maximum value of column in dataframe –python pandas

Author

  • Sridhar Venkatachalam

    With close to 10 years on Experience in data science and machine learning Have extensively worked on programming languages like R, Python (Pandas), SAS, Pyspark.