Pandas Data Wrangling Data Science & Python
Prompts
-
Messy CSV Cleaning Plan Before Any Code
Inspect a messy file and plan the cleaning steps.
-
Pandas Merge and Join Troubleshooter
Fix wrong row counts after merging tables.
-
Datetime and Time Zone Cleaning Guide
Parse mixed timestamps without silent errors.
-
Groupby and Aggregation Recipe Builder
Choose the right aggregation for a business question.
-
Missing Data Strategy Interview
Decide how to handle nulls case by case.
-
Slow Pandas Code Performance Review
Find and fix the slowest steps.
-
Reshaping Wide and Long Tables
Pivot, melt, and stack without confusion.
-
Text Column Cleaning and Standardization
Normalize names, categories, and free text.
-
Duplicate Detection and Record Linkage Plan
Find duplicates safely without deleting good rows.
-
Data Quality Report From a DataFrame
Produce a repeatable profile of a dataset.
-
Window Functions and Rolling Calculations
Moving averages, ranks, and running totals.
-
Unit Tests for Data Transformations
Test a cleaning function with small known cases.
-
Reading Many Files into One Clean Table
Combine monthly exports with different layouts.
-
Explain This Pandas Code Line by Line
Understand inherited code before changing it.
-
Choosing Data Types to Save Memory
Right-size columns safely.
-
Pipeline from Raw Export to Analysis-Ready Table
Design a reproducible cleaning pipeline.
-
Merge Validation With Indicator Columns
Prove a join did what you intended.
-
Large CSV Processing in Chunks
Handle files that do not fit in memory.
-
Nested JSON and API Data to Tidy Tables
Flatten messy nested data reliably.
-
Time Series Resampling and Gap Handling
Align irregular data to regular intervals.
-
Fuzzy Matching Names and Addresses
Link records that are almost the same.
-
Cohort Table Construction in Pandas
Build retention-style cohort tables.
-
Parsing Numbers, Currencies and Dates in Messy Columns
Clean values stored as text.
No prompts match those filters.