Reshape data for the framing questions

ODA-5 Order: #5 Explore Data and Find Signal Has Dependencies

Updated 1 month, 2 weeks ago

Guidance

Convert between long ("tidy") and wide ("square") layouts with stack()/unstack()/pivot(), and build a hierarchical (multi-index) structure if your questions need more than one categorical grouping key (e.g. State + Year). Choose the shape each later step actually needs rather than leaving everything in whatever shape it was loaded in.

Details

Order:: #5
Phase:
Predecessor:: ODA-4 Combine and deduplicate datasets
Created:: Sep 18, 2026
Last Updated:: Sep 18, 2026

Workflow

Organize and Clean Data

Turn the selected raw datasets into one clean, combined, correctly-shaped working DataFrame — the shared substrate every later exploration step …

View Workflow

Assigned Agent

EDA Practitioner

The person or AI system running this playbook end to end — analyst, programmer, and …

Required Skills

Pandas Data Structure Manipulation Tabular Data Engineering pandas, numpy

Rules

No rules linked.

Input Artifacts

No input artifacts

Output Artifacts 1

Clean Working DataFrame Document Required