CLN: Clean-up use of super() in instance methods.
- [x] xref #25725

Simplifies the use of simple uses of ``super`` by converting to use python3 idioms. This is a quite big PR, but only deals with converting ``super(MyClass, self)`` to ``super()`` so it's very simple.

In addition to the uses of ``super`` dealt with in this PR, there are some more advanced uses of ``super`` in the code base, e.g. in classmethods and using ``super`` to jump to a specific point in the MRO-chain. I'd like to tackle those in a seperate PR in order to keep the the current large PR very simple.
# [Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/26177?src=pr&el=h1) Report
> Merging [#26177](https://codecov.io/gh/pandas-dev/pandas/pull/26177?src=pr&el=desc) into [master](https://codecov.io/gh/pandas-dev/pandas/commit/bbcfc7fba2c730d4df18f93f7f95ad439c26c31b?src=pr&el=desc) will **decrease** coverage by `<.01%`.
> The diff coverage is `90.67%`.

[![Impacted file tree graph](https://codecov.io/gh/pandas-dev/pandas/pull/26177/graphs/tree.svg?width=650&token=eZ4WkYLtcO&height=150&src=pr)](https://codecov.io/gh/pandas-dev/pandas/pull/26177?src=pr&el=tree)

```diff
@@            Coverage Diff             @@
##           master   #26177      +/-   ##
==========================================
- Coverage   91.98%   91.98%   -0.01%     
==========================================
  Files         175      175              
  Lines       52371    52371              
==========================================
- Hits        48175    48171       -4     
- Misses       4196     4200       +4
```

| Flag | Coverage Δ | |
|---|---|---|
| #multiple | `90.53% <88.13%> (ø)` | :arrow_up: |
| #single | `40.71% <27.54%> (-0.15%)` | :arrow_down: |

| [Impacted Files](https://codecov.io/gh/pandas-dev/pandas/pull/26177?src=pr&el=tree) | Coverage Δ | |
|---|---|---|
| [pandas/io/clipboard/exceptions.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2NsaXBib2FyZC9leGNlcHRpb25zLnB5) | `71.42% <0%> (ø)` | :arrow_up: |
| [pandas/io/clipboard/windows.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2NsaXBib2FyZC93aW5kb3dzLnB5) | `11.11% <0%> (ø)` | :arrow_up: |
| [pandas/core/base.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvYmFzZS5weQ==) | `98.2% <100%> (ø)` | :arrow_up: |
| [pandas/core/resample.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvcmVzYW1wbGUucHk=) | `97.22% <100%> (ø)` | :arrow_up: |
| [pandas/io/packers.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL3BhY2tlcnMucHk=) | `88.08% <100%> (ø)` | :arrow_up: |
| [pandas/core/algorithms.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvYWxnb3JpdGhtcy5weQ==) | `94.78% <100%> (ø)` | :arrow_up: |
| [pandas/io/excel/\_openpyxl.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2V4Y2VsL19vcGVucHl4bC5weQ==) | `84.71% <100%> (ø)` | :arrow_up: |
| [pandas/io/formats/format.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2Zvcm1hdHMvZm9ybWF0LnB5) | `97.91% <100%> (ø)` | :arrow_up: |
| [pandas/io/excel/\_xlwt.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2V4Y2VsL194bHd0LnB5) | `98.48% <100%> (ø)` | :arrow_up: |
| [pandas/core/arrays/datetimelike.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvYXJyYXlzL2RhdGV0aW1lbGlrZS5weQ==) | `97.69% <100%> (ø)` | :arrow_up: |
| ... and [46 more](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree-more) | |

------

[Continue to review full report at Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/26177?src=pr&el=continue).
> **Legend** - [Click here to learn more](https://docs.codecov.io/docs/codecov-delta)
> `Δ = absolute <relative> (impact)`, `ø = not affected`, `? = missing data`
> Powered by [Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/26177?src=pr&el=footer). Last update [bbcfc7f...972c8d6](https://codecov.io/gh/pandas-dev/pandas/pull/26177?src=pr&el=lastupdated). Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments).
 # [Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/26177?src=pr&el=h1) Report
> Merging [#26177](https://codecov.io/gh/pandas-dev/pandas/pull/26177?src=pr&el=desc) into [master](https://codecov.io/gh/pandas-dev/pandas/commit/b62e9aeac6b646a7d4a1f63d88dd15e347ad3719?src=pr&el=desc) will **decrease** coverage by `<.01%`.
> The diff coverage is `90.67%`.

[![Impacted file tree graph](https://codecov.io/gh/pandas-dev/pandas/pull/26177/graphs/tree.svg?width=650&token=eZ4WkYLtcO&height=150&src=pr)](https://codecov.io/gh/pandas-dev/pandas/pull/26177?src=pr&el=tree)

```diff
@@            Coverage Diff             @@
##           master   #26177      +/-   ##
==========================================
- Coverage   91.98%   91.98%   -0.01%     
==========================================
  Files         175      175              
  Lines       52372    52372              
==========================================
- Hits        48177    48173       -4     
- Misses       4195     4199       +4
```

| Flag | Coverage Δ | |
|---|---|---|
| #multiple | `90.53% <88.13%> (ø)` | :arrow_up: |
| #single | `40.7% <27.54%> (-0.15%)` | :arrow_down: |

| [Impacted Files](https://codecov.io/gh/pandas-dev/pandas/pull/26177?src=pr&el=tree) | Coverage Δ | |
|---|---|---|
| [pandas/io/clipboard/exceptions.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2NsaXBib2FyZC9leGNlcHRpb25zLnB5) | `71.42% <0%> (ø)` | :arrow_up: |
| [pandas/io/clipboard/windows.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2NsaXBib2FyZC93aW5kb3dzLnB5) | `11.11% <0%> (ø)` | :arrow_up: |
| [pandas/core/base.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvYmFzZS5weQ==) | `98.2% <100%> (ø)` | :arrow_up: |
| [pandas/core/resample.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvcmVzYW1wbGUucHk=) | `97.22% <100%> (ø)` | :arrow_up: |
| [pandas/io/packers.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL3BhY2tlcnMucHk=) | `88.08% <100%> (ø)` | :arrow_up: |
| [pandas/core/algorithms.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvYWxnb3JpdGhtcy5weQ==) | `94.8% <100%> (ø)` | :arrow_up: |
| [pandas/io/excel/\_openpyxl.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2V4Y2VsL19vcGVucHl4bC5weQ==) | `84.71% <100%> (ø)` | :arrow_up: |
| [pandas/io/formats/format.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2Zvcm1hdHMvZm9ybWF0LnB5) | `97.91% <100%> (ø)` | :arrow_up: |
| [pandas/io/excel/\_xlwt.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2V4Y2VsL194bHd0LnB5) | `98.48% <100%> (ø)` | :arrow_up: |
| [pandas/core/arrays/datetimelike.py](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvYXJyYXlzL2RhdGV0aW1lbGlrZS5weQ==) | `97.69% <100%> (ø)` | :arrow_up: |
| ... and [46 more](https://codecov.io/gh/pandas-dev/pandas/pull/26177/diff?src=pr&el=tree-more) | |

------

[Continue to review full report at Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/26177?src=pr&el=continue).
> **Legend** - [Click here to learn more](https://docs.codecov.io/docs/codecov-delta)
> `Δ = absolute <relative> (impact)`, `ø = not affected`, `? = missing data`
> Powered by [Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/26177?src=pr&el=footer). Last update [b62e9ae...0d9555c](https://codecov.io/gh/pandas-dev/pandas/pull/26177?src=pr&el=lastupdated). Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments).
 lgtm, will merge after I fixup master.

can you do a followup to prohitbit the old style in code-checks (or push to this one ok too) I can add that to the follow-up, where I take the rest of ``super``. @topper-123 can you merge master? The failure seems unrelated, don't know what's going on:

```
  @pytest.mark.parametrize('cache', [True, False])
    def test_string_na_nat_conversion(self, cache):
        # GH #999, #858
    
        strings = np.array(['1/1/2000', '1/2/2000', np.nan,
                            '1/4/2000, 12:34:56'], dtype=object)
    
        expected = np.empty(4, dtype='M8[ns]')
        for i, val in enumerate(strings):
            if isna(val):
                expected[i] = iNaT
            else:
                expected[i] = parse(val)
    
        result = tslib.array_to_datetime(strings)[0]
        tm.assert_almost_equal(result, expected)
    
        result2 = to_datetime(strings, cache=cache)
        assert isinstance(result2, DatetimeIndex)
        tm.assert_numpy_array_equal(result, result2.values)
    
        malformed = np.array(['1/100/2000', np.nan], dtype=object)
    
        # GH 10636, default is now 'raise'
        msg = (r"\(u?'Unknown string format:', '1/100/2000'\)|"
               "day is out of range for month")
        with pytest.raises(ValueError, match=msg):
>           to_datetime(malformed, errors='raise', cache=cache)
E           AssertionError: Pattern '\(u?'Unknown string format:', '1/100/2000'\)|day is out of range for month' not found in 'Unknown string format: 1/100/2000'
```
 Certainly strange. Looks like it is a result of this PR though. Maybe revert the changes to pandas/_libs/tslibs/strptime.pyx (or other cython modules) and see if the error disappears - could certainly be differences with how Cython handles super calls versus Python This error message shows up in #22511 also, so must be something else. If it`s only my code, its very strange. I`ll look into that. thanks @topper-123 