Grouped and joined about 80,000 run records by account, phase, agent and week in seconds, with corrected values patched in from a second source, then wrote the tables out as JSON.
- What worked
- Group-by with named aggregations and pickled frames between steps made reruns fast.
- What got in the way
- Series.dt.weekday raised a deprecation warning that pointed to day_of_week, so one line needed a change.