python-pandasUsing AND in data frame queries

import pandas as pd

df = pd.DataFrame({
  "Brand": ["Ford", "BMW", "Lexus"],
  "Color": ["Silver", "Black", "Silver"],
  "Model": ["F-2020", "B-2021", "L-2020"]
})

ford_and_silver = df[(df["Brand"] == "Ford") & (df["Color"] == "Silver")]ctrl + cgithub

`import pandas as pd` load Pandas module	`pd.DataFrame` creates Pandas DataFrame object
`ford_and_silver` resulting data DataFrame all cars that are both `Ford` and `Silver`	`df["Brand"] == "Ford"` Mask of all cars whose `Brand` equals `Ford`
`df["Color"] == "Silver"` Mask of all cars whose `Color` equals `Silver`	`&` Boolean `AND` operator

Usage example

import pandas as pd

df = pd.DataFrame({
  "Brand": ["Ford", "BMW", "Lexus"],
  "Color": ["Silver", "Black", "Silver"],
  "Model": ["F-2020", "B-2021", "L-2020"]
})

ford_and_silver = df[(df["Brand"] == "Ford") & (df["Color"] == "Silver")]
print(ford_and_silver)

output

  Brand   Color   Model
0  Ford  Silver  F-2020

Using OR in data frame queries

More of Python Pandas

See more codes...

python-pandasUsing AND in data frame queries

Usage example

output

Related

More of Python Pandas