Python With Excel and Text Strings
Pandas Dataframes
Let’s now see how to filter on if at least one condition is satisfied, and not necessarily
Code:
import pandas as pd
df = pd.read_excel('europe_cities_by_sunshine.xlsx')
df[ (df['Year'] > 3000) | (df['Country'] == 'France')]
Explanation:
Now, we’re filtering for above 3000 in the Year category, or if the city is in France. So we can see the list that is returned now has Paris, France as a row even though the Year value is 1662. We have the two ways to filter upon, and the “ | “ in the middle signifies to python that we want the value to be above 3000 OR the country to be in France. The “ | “ is considered the OR operator in python and can be used in many cases, to see if either one or the other case is valid.