Q:

How to select with complex criteria from pandas DataFrame?

mahmoud2506
Save to bookmark
|
2022-05-25
|
  281 
0

Pandas is a special tool that allows us to perform complex manipulations of data effectively and efficiently. Inside pandas, we mostly deal with a dataset in the form of DataFrame. DataFrames are 2-dimensional data structures in pandas. DataFrames consist of rows, columns, and the data. DataFrame can be created with the help of python dictionaries or lists but in the real world, CSV files are imported and then converted into DataFrames. Sometimes, DataFrames are first written into CSV files. Here, we are creating a DataFrame and then we will select a particular row using the pandas.DataFrame.query() method.

pandas.DataFrame.query() Method

It allows us to apply any condition or query in the DataFrame. It returns the data after filtering it through the query.

Syntax:

DataFrame.query(expr, inplace=False, **kwargs)

To work with pandas, we need to import pandas package first, below is the syntax:

import pandas as pd
Python programming,
login and add your own answer to this question

All Answers

mahmoud2506
2022-05-25
need an explanation for this answer? contact us directly to get an explanation for this answer

Let us understand with the help of an example:

# Importing pandas package
import pandas as pd

# creating a dictionary of student marks
d = {
    "Players":['Sachin','Ganguly','Dravid','Yuvraj','Dhoni','Kohli',
              'Sachin','Ganguly','Dravid','Yuvraj','Dhoni','Kohli'],
    "Format":['Test','Test','Test','Test','Test','Test',
             'ODI','ODI','ODI','ODI','ODI','ODI'],
    "Runs":[15921,7212,13228,1900,4876,8043,
           18426,11363,10889,8701,10773,12311]
}

# Now we will create DataFrame
df=pd.DataFrame(d)

# Viewing the DataFrame
print("DataFrame:\n",df,"\n\n")

# Applying a query
df1 = df.loc[df.query(
    'Runs >= 12000'
).index]

# Display df1
print("Filtered DataFrame\n",df1)

Output:

Example: select with complex criteria from DataFrame

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now