Filter rows based on multiple conditions
Filter the companies DataFrame based on 2 conditions. Extract all the rows where 'Revenue (USD)' is greater than
4,000,000 and 'Year Established' is before 2015.import pandas as pd
df = pd.read_csv('/data/companies.csv')
# extract companies in Healthcare industry...
filtered =
print(filtered['Company Name'].values)
# expected output:
# ['Global Tech Solutions' 'Spectrum Entertainment' 'Pantheon Technologies'
# 'Starburst Studios' 'Sunrise Pharmaceuticals' 'Grandeur Hotels'
# 'Golden Gate Financial Services' 'Neptune Pharmaceuticals']'
Python
Setting up Python environment... Output