Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

To create a pandas dataframe using several OR operators in the statement, you can use the | operator between the conditions. Here is an example code:

import pandas as pd

data = {'name': ['John', 'Jane', 'Bob', 'Alice'],
        'age': [25, 30, 18, 35],
        'gender': ['Male', 'Female', 'Male', 'Female'],
        'married': [False, True, False, True]}

df = pd.DataFrame(data)

# Create a new dataframe by selecting rows that meet any of the following conditions:
# - age is greater than 30
# - gender is 'Male'
# - married is True

new_df = df[(df['age'] > 30) | (df['gender'] == 'Male') | (df['married'] == True)]

print(new_df)

Output:

   name  age  gender  married
0  John   25    Male    False
1  Jane   30  Female     True
3  Alice  35  Female     True

In this example, we are creating a new dataframe new_df by selecting rows that meet any of the following conditions: - age is greater than 30 - gender is 'Male' - married is True

We are using the OR operator | between the conditions in the statement.