Python Pandas for Data Analysts: A Beginner Guide in Simple Terms

Why Python for a Data Analyst?

SQL and Excel handle most MIS work. But Python becomes useful when you need to:

• Clean very messy datasets
• Automate repetitive analysis
• Work with large files Excel cannot open
• Build machine learning models later

Pandas is the most important Python library for data analysis. Think of it as Excel for programmers — tables, filters, formulas, but faster and repeatable.

Setup (5 minutes)

1. Install Python from python.org
2. Open terminal and run:

pip install pandas matplotlib openpyxl

3. Create a file analysis.py and start coding

Step 1: Read data

import pandas as pd

# From CSV
df = pd.read_csv("sales_data.csv")

# From Excel
df = pd.read_excel("mis_report.xlsx", sheet_name="Sales")

print(df.head())   # First 5 rows
print(df.info())   # Column names and data types

df is a DataFrame — like an Excel sheet in Python.

Step 2: Inspect data quality

print(df.isnull().sum())      # Missing values per column
print(df.duplicated().sum())  # Duplicate rows
print(df.describe())          # Min, max, average for numbers

Always inspect before analyzing. Dirty data = wrong insights.

Step 3: Filter rows (like Excel filters)

# Sales in North region above 10,000
north_high = df[(df["Region"] == "North") & (df["SalesAmount"] > 10000)]

# This month only
june_sales = df[df["OrderDate"] >= "2026-06-01"]

Step 4: Group and summarize (like pivot tables)

summary = df.groupby("ProductCategory")["SalesAmount"].agg(
    TotalSales="sum",
    AvgSales="mean",
    OrderCount="count"
).reset_index()

print(summary.sort_values("TotalSales", ascending=False))

Step 5: Handle missing values

# Fill missing region with "Unknown"
df["Region"] = df["Region"].fillna("Unknown")

# Drop rows with no sales amount
df = df.dropna(subset=["SalesAmount"])

Step 6: Create a simple chart

import matplotlib.pyplot as plt

top_products = df.groupby("ProductName")["SalesAmount"].sum().nlargest(10)

top_products.plot(kind="bar", title="Top 10 Products by Sales")
plt.ylabel("Sales Amount")
plt.tight_layout()
plt.savefig("top_products.png")

Share the PNG in emails or PowerPoint — quick visual for managers.

Step 7: Export results

summary.to_excel("monthly_summary.xlsx", index=False)
summary.to_csv("monthly_summary.csv", index=False)

Pandas vs SQL vs Excel — when to use what

7-day learning plan

1. Day 1–2: read_csv, head, info, describe
2. Day 3: Filtering with conditions
3. Day 4: groupby and aggregations
4. Day 5: Missing values and duplicates
5. Day 6: Basic matplotlib charts
6. Day 7: One full project — clean a Kaggle dataset and export summary

Final takeaway

Pandas is not magic — it is a faster, repeatable way to do what you already do in Excel. Start with one real work dataset, automate one boring weekly task, and build from there.