Filtering & Selecting Data in Pandas for Pharmacy Students (High-Risk Patients & ADR Analysis)

Filtering and selecting data are key operations in data analysis. In pharmaceutical sciences, these techniques help identify high-risk patients, severe ADR cases, and important clinical patterns.

🔷 What is Filtering?

Filtering means selecting rows based on specific conditions.

🔷 Basic Filtering

import pandas as pd

df = pd.read_csv("clinical_data.csv")

# High dose patients
high_dose = df[df["Dose"] > 600]
print(high_dose)

🔷 Multiple Conditions

# High dose and elderly patients
risk_patients = df[(df["Dose"] > 600) & (df["Age"] > 60)]
print(risk_patients)

💊 ADR Filtering Example

# Severe ADR cases
severe_cases = df[df["Reaction"] == "Severe"]
print(severe_cases)

Used to identify serious adverse drug reactions.

🔷 Selecting Specific Columns

# Select only Drug and Dose
print(df[["Drug", "Dose"]])

🔷 Using loc[] for Selection

# Select rows and columns
print(df.loc[df["Dose"] > 600, ["Patient", "Dose"]])

💊 Clinical Risk Analysis

# Identify high-risk patients
risk = df[(df["Dose"] > 600) & (df["Reaction"] == "Severe")]

print("High-risk patients:")
print(risk)

🧠 Memory Tricks

• [] → Filter rows
• & → AND condition
• | → OR condition
• loc[] → Select data

🧪 Practice Exercise

Load dataset and:

• Find patients with dose > 500
• Filter severe ADR cases
• Select drug and reaction columns

🧪 Mini Project

Create a clinical filter system:

import pandas as pd

df = pd.read_csv("clinical_data.csv")

high_risk = df[(df["Age"] > 60) & (df["Dose"] > 600)]

print("High Risk Patients:")
print(high_risk)

📝 MCQs

1. Filtering is used to:
   a) Delete data
   b) Select data
   c) Print data
   d) Store data
   Answer: b


2. AND condition uses:
   a) |
   b) &
   c) +
   d) =
   Answer: b


3. loc[] is used for:
   a) File reading
   b) Data selection
   c) Looping
   d) Printing
   Answer: b

❓ FAQs

Why is filtering important in pharmacy?

It helps identify high-risk patients and critical clinical conditions.

How to combine multiple conditions?

Use & (AND) or | (OR).

➡ Next Topic: Grouping & Aggregation →