STYLE update pre-commit-config
- [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

Am doing this manually (instead of the automated job tomorrow) in order to fixup some minor things
LGTM; npdev failures look unrelated thanks @MarcoGorelli 