DOC: Fix SA04 errors in docstrings #28792
- [x] xref #28792 
- [x] passes `black pandas`
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`


@AdrianMastronardi looks like a merge conflict - can you merge master? @WillAyd merge conflict resolved. Great thanks @AdrianMastronardi !