Python & Pandas basics for Excel users

Each training is led by seasoned practitioners with years of hands-on experience across diverse industries and corporate environments.

• Audience: Analysts comfortable with Excel, new to programming
• Python & Pandas Basics → transform and analyze
• Focus on mapping familiar Excel concepts → new tools reduces learning friction.
• Hands-on exercises keep engagement high.
• Duration: 2 half-day sessions (4 hrs each )
• Total 8 hours for foundational fluency in Python for Excel users.

Key translation from Excel → Pandas

• Workbook → Python script / Jupyter / Marimo notebook
• Sheet → Pandas DataFrame
• Cell formula → Vectorized operation
• PivotTable → groupby()
• Find & Replace → String methods / filtering

Python & data loading

1. Intro to Python for Analysts

   • Why Python? (Automation, scale, reproducibility)
   • Using Python client tools
   • Basic syntax: variables, lists, dicts (light touch)

2. Meet Pandas & DataFrames

   • Loading data from common file formats (CSV, Excel, etc.)
   • Inspecting data
   • Selecting columns/rows

3. Filtering & sorting

   • Boolean indexing
   • Multiple conditions
   • Sorting
   • Exercise: Recreate Excel filters in Pandas

4. Adding & transforming columns

   • New columns
   • .apply() for custom logic
   • String/date methods

Summarizing, merging & automation

1. Recap & Q&A

2. Grouping & summarizing

   • .groupby() = PivotTable
   • Multiple aggregations
   • .pivot_table() for cross-tabs
   • Exercise: Data analysis

3. Combining DataFrames

   • .merge() = VLOOKUP / JOIN
   • Left, inner, outer merges
   • Handling mismatched keys
   • Exercise: Enrich data

4. Cleaning & handling real data

   • Dealing with missing values
   • Removing duplicates
   • Renaming & reordering columns

5. Capstone project: Business analysis

6. Wrap-up & next Steps

   • When to use Excel vs Python/Pandas
   • Resources

Get started

Ready to level up your team’s data skills? Contact us for a free 15-minute consultation to discuss your training needs.