In [1]:
# Querying with a Single Condition
import pandas as pd
df = pd.DataFrame({
''''A'''': [1, 2, 3, 4],
''''B'''': [''''x'''', ''''y'''', ''''z'''', ''''w'''']
})
result = df.query(''''A > 2'''')
print(result)
A B 2 3 z 3 4 w
In [2]:
# Using Boolean Indexing
import pandas as pd
df = pd.DataFrame({
''''A'''': [1, 2, 3, 4],
''''B'''': [''''x'''', ''''y'''', ''''z'''', ''''w'''']
})
result = df[df[''''A''''] > 2]
print(result)
A B 2 3 z 3 4 w
In [3]:
# Querying with Multiple Conditions
import pandas as pd
df = pd.DataFrame({
''''A'''': [1, 2, 3, 4],
''''B'''': [''''x'''', ''''y'''', ''''z'''', ''''w'''']
})
result = df.query(''''A > 2 & B == "z"'''')
print(result)
A B 2 3 z
In [4]:
# Using Boolean Indexing
import pandas as pd
df = pd.DataFrame({
''''A'''': [1, 2, 3, 4],
''''B'''': [''''x'''', ''''y'''', ''''z'''', ''''w'''']
})
result = df[(df[''''A''''] > 2) & (df[''''B''''] == ''''z'''')]
print(result)
A B 2 3 z