python-pandasUsing OR 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_or_lexus = df[(df["Brand"] == "Ford") | (df["Brand"] == "Lexus")]ctrl + cgithub

`import pandas as pd` load Pandas module	`pd.DataFrame` creates Pandas DataFrame object
`ford_or_lexus` resulting `DataFrame` containing all cars that are either `Ford` or `Lexus`	`df["Brand"] == "Ford"` Mask of all cars whose `Brand` equals `Ford`
`df["Brand"] == "Lexus"` Mask of all cars whose `Brand` equals `Lexus`	`\|` Boolean `OR` 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_or_lexus = df[(df["Brand"] == "Ford") | (df["Brand"] == "Lexus")]
print(ford_or_lexus)

output

   Brand   Color   Model
0   Ford  Silver  F-2020
2  Lexus  Silver  L-2020

Using AND in data frame queries

More of Python Pandas

See more codes...

python-pandasUsing OR in data frame queries

Usage example

output

Related

More of Python Pandas