Python - Return the minimum value of the Pandas Index

To return the minimum value of the Pandas Index, use the index.min() method. This method efficiently finds the smallest value in the index without needing to sort the entire index.

Syntax

index.min()

Creating a Pandas Index

First, let's create a Pandas index with some numerical values ?

import pandas as pd

# Creating Pandas index with float values
index = pd.Index([10.5, 20.4, 40.5, 25.6, 5.7, 6.8, 30.8, 50.2])

# Display the Pandas index
print("Pandas Index...")
print(index)

Pandas Index...
Float64Index([10.5, 20.4, 40.5, 25.6, 5.7, 6.8, 30.8, 50.2], dtype='float64')

Finding the Minimum Value

Use the min() method to get the smallest value from the index ?

import pandas as pd

# Creating Pandas index
index = pd.Index([10.5, 20.4, 40.5, 25.6, 5.7, 6.8, 30.8, 50.2])

# Display the Pandas index
print("Pandas Index...")
print(index)

# Return the number of elements in the Index
print("\nNumber of elements in the index...")
print(index.size)

# Return the dtype of the data
print("\nThe dtype object...")
print(index.dtype)

# Get the minimum value
print("\nMinimum value...")
print(index.min())

Pandas Index...
Float64Index([10.5, 20.4, 40.5, 25.6, 5.7, 6.8, 30.8, 50.2], dtype='float64')

Number of elements in the index...
8

The dtype object...
float64

Minimum value...
5.7

Working with Different Data Types

The min() method works with various data types including integers, strings, and dates ?

import pandas as pd

# Integer index
int_index = pd.Index([45, 12, 78, 23, 9])
print("Integer Index minimum:", int_index.min())

# String index
str_index = pd.Index(['apple', 'banana', 'cherry', 'date'])
print("String Index minimum:", str_index.min())

Integer Index minimum: 9
String Index minimum: apple

Conclusion

The index.min() method provides an efficient way to find the minimum value in a Pandas Index. It works with numeric, string, and datetime data types, returning the smallest value according to the natural ordering of the data type.