Python TypeError: 'DataFrame' Object Is Not Callable

Python TypeError: 'DataFrame' Object Is Not Callable

We will introduce how to call data from a DataFrame based on a query in Python. We will also introduce how to resolve the TypeError: ‘DataFrame’ object is not callable in Python with examples.

TypeError: ‘DataFrame’ object is not callable in Python

DataFrames are the object of Pandas, two dimensional labeled data structure with columns. DataFrames are the same as Spreadsheets and SQL tables used to store data.

While working on spreadsheets or scraping data from websites and saving them in spreadsheets, we often need to use data frames to organize the data correctly for users and us to understand and use later.

Let’s understand how we can create a data frame from multiple arrays in Python. We will create arrays containing students’ data, then utilize them in a data frame and save them in a spreadsheet.

The arrays are shown below.

Code:

# python
import pandas as pd

name = ['Ali', 'Hasnain', 'Khan']
marks = ['35', '70', '95']

data = {'Name': name, 'Marks': marks}

df = pd.DataFrame(data)

print(df)

Output:

dataframe from arrays in python

Now let’s add another column of Result in which we will add whether a student passed or failed, as shown below.

Code:

# python
import pandas as pd

name = ['Ali', 'Hasnain', 'Khan']
marks = ['35', '70', '95']
result = ['Fail', 'Pass', 'Pass']

data = {'Name': name, 'Marks': marks, 'Result': result}

df = pd.DataFrame(data)

print(df)

Output:

dataframe from arrays in python part 2

Now, if we have a data frame the same as the one we created but with a large amount of data, we want to extract the students who fail or pass using Boolean indexing. We will replace the last line with Boolean indexing, as shown below.

# python
print(df[df.Result=='Pass'])

The result of the above change will be shown below.

Output:

Boolean indexing in df in python

Many people need help getting the results from the data frame based on Boolean indexing. It is very simple to use.

We only need to create a new data frame and use [] brackets to mention the Boolean indexing based on which we want to get the results.

Rana Hasnain Khan avatar Rana Hasnain Khan avatar

Rana is a computer science graduate passionate about helping people to build and diagnose scalable web application problems and problems developers face across the full-stack.

LinkedIn

Related Article - Python Error

  • IndexError: Tuple Index Out of Range in Python
  • Python Segmentation Fault 11
  • ZeroDivisionError: Float Division by Zero in Python
  • Python PermissionError: [WinError 5] Access Is Denied
  • Python TypeError: Can't Convert 'List' Object to STR