Query
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
