REF: Move transform into apply
- [x] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing.html#code-standards) for how to run them

Cleanups and consolidations to follow.
thanks @rhshadrach 

let the deduplication begin!