CLN: 29547 replace old string formatting
I splitted PR #31844 in batches, this is the **last**
For this PR I ran the command `grep -l -R -e '%s' -e '%d' -e '\.format(' --include=*.{py,pyx} pandas/` and checked all the files that were returned for `.format(` and changed the old string format for the corresponding `fstrings` to attempt a full clean of, [#29547](https://github.com/pandas-dev/pandas/issues/29547). I may have missed something so is a good idea to double check just in case

- [ x  ] tests added / passed
- [ x ] passes `black pandas`
- [ x ] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [ x ] Ref #29547

@3vts thanks for making the changes. lgtm. can you run black to get ci passing > I splitted PR #31844 in batches, this is the **last**
> For this PR I ran the command `grep -l -R -e '%s' -e '%d' -e '\.format(' --include=*.{py,pyx} pandas/` and checked all the files that were returned for `.format(` and changed the old string format for the corresponding `fstrings` to attempt a full clean of, [#29547](https://github.com/pandas-dev/pandas/issues/29547). I may have missed something so is a good idea to double check just in case
> 
>     * [ x  ] tests added / passed
> 
>     * [ x ] passes `black pandas`
> 
>     * [ x ] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
> 
>     * [ x ] closes #29547 (?)

@3vts Can you please change the last line from ```Closes #29547``` to ```Ref #29547```, Just so it won't close the master issue Thanks @3vts 

General comment - would be nice to keep PRs more minimal in the future. This was maybe an exception because of all of the double curly braces at play, but if something else comes up the same in the future should tackle in smaller bits