Python - Check if the Pandas Index with some NaNs is a floating type

To check if a Pandas Index with NaN values is a floating type, use the index.is_floating() method. This method returns True if the index contains floating-point numbers, even when NaN values are present.

Syntax

index.is_floating()

This method returns a boolean value indicating whether the index is of floating-point type.

Creating an Index with NaN Values

First, let's create a Pandas index containing floating-point numbers and NaN values ?

import pandas as pd
import numpy as np

# Creating Pandas index with some NaNs
index = pd.Index([5.7, 6.8, 10.5, np.nan, 17.8, 25.6, np.nan, np.nan, 50.2])

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

Pandas Index...
Float64Index([5.7, 6.8, 10.5, nan, 17.8, 25.6, nan, nan, 50.2], dtype='float64')

Checking if Index is Floating Type

Now let's check if this index with NaN values is a floating type ?

import pandas as pd
import numpy as np

# Creating Pandas index with some NaNs
index = pd.Index([5.7, 6.8, 10.5, np.nan, 17.8, 25.6, np.nan, np.nan, 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)

# Check whether index values with some NaNs are floating type
print("\nIndex values with some NaNs is a floating type?")
print(index.is_floating())

Pandas Index...
Float64Index([5.7, 6.8, 10.5, nan, 17.8, 25.6, nan, nan, 50.2], dtype='float64')

Number of elements in the index...
9

The dtype object...
float64

Index values with some NaNs is a floating type?
True

Comparing with Non-Floating Index

Let's compare this with an integer index to see the difference ?

import pandas as pd

# Creating integer index
int_index = pd.Index([1, 2, 3, 4, 5])

# Creating floating index
float_index = pd.Index([1.0, 2.0, 3.0, 4.0, 5.0])

print("Integer Index is floating?", int_index.is_floating())
print("Float Index is floating?", float_index.is_floating())

Integer Index is floating? False
Float Index is floating? True

Key Points

• The is_floating() method returns True for floating-point indexes, even with NaN values
• NaN values do not affect the floating type detection
• Integer indexes return False when checked with is_floating()
• The method is useful for data type validation in data preprocessing

Conclusion

The is_floating() method effectively identifies floating-point indexes regardless of NaN values. This is particularly useful when validating data types before performing numerical operations on Pandas indexes.