Reading CSV & Excel Files in Pandas for Pharmacy Students (ADR Reports & PK Dataset Analysis)

Pandas provides powerful functions to read data from CSV and Excel files. In pharmaceutical sciences, these files are commonly used for Adverse Drug Reaction (ADR) reports, pharmacokinetic (PK) datasets, and clinical trial data.

🔷 Why Read Files in Pandas?

• Quickly load large datasets
• Supports CSV and Excel formats
• Enables efficient data analysis

🔷 Reading CSV Files

import pandas as pd

df = pd.read_csv("adr_data.csv")
print(df)

🔷 Reading Excel Files

df = pd.read_excel("pk_data.xlsx")
print(df)

💊 ADR Dataset Example

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

# Display drug and reaction
print(df[["Drug", "Reaction"]])

Used to analyze adverse drug reactions.

💊 PK Dataset Example

df = pd.read_excel("pk_data.xlsx")

# Display time and concentration
print(df[["Time", "Concentration"]])

Used to analyze drug concentration over time.

🔷 Useful Parameters

📘 Read first few rows

df = pd.read_csv("data.csv", nrows=5)

📘 Specify column names

df = pd.read_csv("data.csv", names=["A","B","C"])

🧠 Memory Tricks

• read_csv → CSV file
• read_excel → Excel file
• DataFrame → Loaded data

🧪 Practice Exercise

Load a dataset and:

• Display first 5 rows
• Select drug column
• Analyze concentration data

🧪 Mini Project

Build simple dataset loader:

import pandas as pd

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

print("First 3 rows:")
print(df.head(3))

📝 MCQs

1. Which function reads CSV?
   a) read()
   b) read_csv()
   c) open()
   d) load()
   Answer: b


2. Which function reads Excel?
   a) read_excel()
   b) open_excel()
   c) read_csv()
   d) excel()
   Answer: a


3. Data is stored in:
   a) List
   b) String
   c) DataFrame
   d) Loop
   Answer: c

❓ FAQs

Why use Pandas for file reading?

It simplifies data import and supports multiple formats.

Which format is common in pharmacy?

CSV and Excel are widely used for ADR and PK datasets.

➡ Next Topic: Inspecting Data (head, tail, info, describe) →