Filter rows and from pandas DataFrame

Premium

Use pandas filtering methods to extract companies in the healthcare industry.
Use either DataFrame.query() or DataFrame.loc[] to filter the rows where the 'Industry' column has the value Healthcare.

import pandas as pd
 
df = pd.read_csv('/data/companies.csv')
 
# extract companies in Healthcare industry...

filtered =

 
print(filtered['Company Name'])
 
# expected output:
# 1     Neptune Pharmaceuticals
# 7       Alpha Pharmaceuticals
# 16         Health Innovations
# 21    Everest Pharmaceuticals
# 30         Wellness Solutions
# 35    Sunrise Pharmaceuticals
# 44    Neptune Pharmaceuticals
# Name: Company Name, dtype: object

Python

Setting up Python environment...

Output