Introduction to Pandas for Pharmacy Students (Pharma Data Analysis & Why Pandas Over CSV/NumPy)

Pandas is one of the most powerful Python libraries used for data analysis. In pharmaceutical sciences, it plays a crucial role in handling patient datasets, pharmacokinetic (PK) studies, and ADR reports.

🔷 What is Pandas?

Pandas is a Python library used for data manipulation and analysis. It provides easy-to-use data structures and functions for working with structured data.

🔷 Importing Pandas

import pandas as pd

🔷 Why Pandas in Pharmacy?

• Handles large datasets efficiently
• Supports CSV and Excel files
• Provides statistical analysis tools
• Useful for PK and ADR data analysis

💊 Pharma Dataset Example

Pandas helps analyze such datasets easily.

🔷 Why Pandas Over CSV Module?

🔷 Why Pandas Over NumPy?

🔷 Simple Pandas Example

import pandas as pd

data = {
    "Patient": ["P001", "P002"],
    "Dose": [500, 650]
}

df = pd.DataFrame(data)
print(df)

🧠 Memory Tricks

• Pandas → Data analysis
• DataFrame → Table
• Series → Column

🧪 Practice Exercise

Create a dataset using Pandas:

• Store patient names
• Store doses
• Display data

🧪 Mini Project

Create a simple patient dataset:

import pandas as pd

data = {
    "Name": ["Alice", "Bob"],
    "Dose": [500, 700]
}

df = pd.DataFrame(data)
print(df)

📝 MCQs

1. Pandas is used for:
   a) Gaming
   b) Data analysis
   c) Networking
   d) Drawing
   Answer: b


2. DataFrame represents:
   a) List
   b) Table
   c) String
   d) Loop
   Answer: b


3. Which is better for dataset analysis?
   a) CSV
   b) NumPy
   c) Pandas
   d) None
   Answer: c

❓ FAQs

Why is Pandas important in pharmacy?

It helps in analyzing clinical, PK, and ADR datasets efficiently.

Can Pandas replace NumPy?

Pandas is built on NumPy, but it is more user-friendly for data analysis.

➡ Next Topic: Pandas Series & DataFrame →