Sunday, November 17, 2024
Google search engine
HomeLanguagesHow to Get the maximum value from the Pandas dataframe in Python?

How to Get the maximum value from the Pandas dataframe in Python?

Python Pandas max() function returns the maximum of the values over the requested axis.

Syntax: dataframe.max(axis)

where,

  • axis=0 specifies column
  • axis=1 specifies row

Example 1: Get maximum value in dataframe row

To get the maximum value in a dataframe row simply call the max() function with axis set to 1.

Syntax: dataframe.max(axis=1)

Python3




# import pandas module
import pandas as pd
  
# create a dataframe
# with 5 rows and 4 columns
data = pd.DataFrame({
    'name': ['sravan', 'ojsawi', 'bobby'
             'rohith', 'gnanesh'],
    'subjects': ['java', 'php', 'html/css',
                 'python', 'R'],
    'marks': [98, 90, 78, 91, 87],
    'age': [11, 23, 23, 21, 21]
})
  
# display dataframe
print(data)
  
# get the maximum in row
data.max(axis=1)


Output:

Example 2: Get the maximum value in column

To get the maximum value in a column simply call the max() function using the axis set to 0.

Syntax: dataframe.max(axis=0)

Python3




# import pandas module
import pandas as pd
  
# create a dataframe
# with 5 rows and 4 columns
data = pd.DataFrame({
    'name': ['sravan', 'ojsawi', 'bobby'
             'rohith', 'gnanesh'],
    'subjects': ['java', 'php', 'html/css',
                 'python', 'R'],
    'marks': [98, 90, 78, 91, 87],
    'age': [11, 23, 23, 21, 21]
})
  
# display dataframe
print(data)
  
# get the maximum in column
data.max(axis=0)


Output:

Example 3: Get the maximum value in a particular column

To get the maximum value in a particular column call the dataframe with the specific column name and max() function.

Syntax: dataframe[‘column_name’].max()

Python3




# import pandas module
import pandas as pd
  
# create a dataframe
# with 5 rows and 4 columns
data = pd.DataFrame({
    'name': ['sravan', 'ojsawi', 'bobby'
             'rohith', 'gnanesh'],
    'subjects': ['java', 'php', 'html/css'
                 'python', 'R'],
    'marks': [98, 90, 78, 91, 87],
    'age': [11, 23, 23, 21, 21]
})
  
# display dataframe
print(data)
  
# get the max in name  column
print(data['name'].max())
  
# get the max in subjects  column
print(data['subjects'].max())
  
# get the max in age  column
print(data['age'].max())
  
# get the max in marks  column
print(data['marks'].max())


Output:

RELATED ARTICLES

Most Popular

Recent Comments