AttributeError: dataframe' object has no attribute 'ix' ( Solved )

Pandas python package allows you to create a dataframe from the dataset that helps you to manipulate the dataset. But sometimes you may use some functions that are not provided by panda’s library or are deprecated. In this example, you will learn how to solve the error AttributeError : dataframe’ object has no attribute ‘ix’ in a simple way.

What does the ix do?

The ix function allows you to find the rows and columns by selecting the range in the integer. It means using ix[] you can use the label and integer-based slicing techniques. For example, if I want to slice the rows to the first 5 rows only then I will use the below lines of code.

df.ix[:4, ]

Why AttributeError dataframe’ object has no attribute ‘ix’ Occurs

The root cause of why you are getting this AttributeError is that the latest version of the pandas package doesn’t provide the ix[] attribute. From version 0.20.0 the .ix indexer is depreciated.

As my system is updated with the latest version of the pandas. If I run the following lines of code, I will get an AttributeError dataframe’ object has no attribute ‘ix’ error.

import pandas as pd
import numpy as np
data = {"name":["Rob","Bam","Maya","Rahul"],"age":[23,25,26,32],
        "country":["USA","UK","France","Germany"]}
df = pd.DataFrame(data)
df.ix[:2,]

Output

Solution of the dataframe’ object has no attribute ‘ix’

There are two ways to solve this attributeError. One is to downgrade the pandas package to 0.20.0. And the second-way is to update to newest pandas version for indexing or slicing the rows. And it is iloc[]. It also does the same work as the ix[].

Now you will not get the error when you will run the below lines of code to slice the dataframe.

import pandas as pd
import numpy as np
data = {"name":["Rob","Bam","Maya","Rahul"],"age":[23,25,26,32],
        "country":["USA","UK","France","Germany"]}
df = pd.DataFrame(data)
df.iloc[:2,]

Output

Slicing the rows using the iloc[] attribute

Conclusion

In this tutorial, you have learned why the dataframe’ object has no attribute ‘ix’ error comes. To avoid this error you have to use the latest slicing attribute provided by the pandas package and it is iloc[].

I hope you have liked this tutorial. If you have any doubt about it then you can contact us for more help.