STYLE, TYP Turn black formatter off for overloads
State: closed

Following on from the monthly meeting's discussion, some things were suggested:

- turning off the black formatter for the overloads, keeping them in `.py` files (what I've done here)
- moving overloads to `.pyi` files, writing a script to keep them in sync (I tried that this, and it seems that `mypy` behaves a bit differently with a `.pyi` file than it does with a `.py` file - will look into this more closely, but it'll take more time)
- keeping overloads out of `.py` files and "injecting" them before running `mypy` via a script - IMO this might be slightly disruptive to the usual workflow of just running `mypy pandas`, but other than that seems like a potentially good idea
- doing away with overloads, and just using `cast` and `assert` - TBH this strikes me as more error-prone, and if pandas will expose types to users, then I think it'd be better to have the correct type revealed rather than having them do `cast` / `assert`

Even if `inplace` is removed in version 2, there are other places in the codebase where there's a parameter which changes the return type, so I do think finding a solution here is worthwhile.

For now, I've gone with the first solution, though I will give some more thought to the second one

Labels:
name: Typing
description: type annotations, mypy/pyright type checking

Comments:
Hello @MarcoGorelli! Thanks for updating this PR. We checked the lines you've touched for [PEP 8](https://www.python.org/dev/peps/pep-0008) issues, and found:

* In the file [`pandas/core/array_algos/take.py`](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/array_algos/take.py):

> [Line 31:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/array_algos/take.py#L31): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 33:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/array_algos/take.py#L33): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)

* In the file [`pandas/core/arrays/datetimelike.py`](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/arrays/datetimelike.py):

> [Line 432:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/arrays/datetimelike.py#L432): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 434:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/arrays/datetimelike.py#L434): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 436:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/arrays/datetimelike.py#L436): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 438:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/arrays/datetimelike.py#L438): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)

* In the file [`pandas/core/arrays/datetimes.py`](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/arrays/datetimes.py):

> [Line 1923:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/arrays/datetimes.py#L1923): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 1925:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/arrays/datetimes.py#L1925): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)

* In the file [`pandas/core/dtypes/cast.py`](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/dtypes/cast.py):

> [Line 450:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/dtypes/cast.py#L450): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 452:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/dtypes/cast.py#L452): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 1062:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/dtypes/cast.py#L1062): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 1064:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/dtypes/cast.py#L1064): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)

* In the file [`pandas/core/frame.py`](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py):

> [Line 1308:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L1308): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 1310:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L1310): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 1425:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L1425): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 1427:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L1427): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4654:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L4654): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4656:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L4656): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4658:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L4658): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4660:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L4660): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5003:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5003): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5005:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5005): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5007:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5007): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5009:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5009): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5011:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5011): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5013:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5013): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5015:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5015): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5017:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5017): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5019:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5019): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5021:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5021): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5400:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5400): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5402:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5402): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5404:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5404): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5406:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5406): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5408:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5408): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 5410:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/frame.py#L5410): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)

* In the file [`pandas/core/generic.py`](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py):

> [Line 686:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py#L686): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 688:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py#L688): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 690:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py#L690): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 692:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py#L692): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 7357:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py#L7357): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 7359:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py#L7359): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 7361:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py#L7361): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 7363:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py#L7363): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 7365:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py#L7365): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 7367:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py#L7367): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 7369:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py#L7369): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 7371:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py#L7371): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 7373:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py#L7373): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 7375:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/generic.py#L7375): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)

* In the file [`pandas/core/reshape/concat.py`](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/reshape/concat.py):

> [Line 57:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/reshape/concat.py#L57): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 59:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/reshape/concat.py#L59): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)

* In the file [`pandas/core/series.py`](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py):

> [Line 2012:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L2012): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 2014:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L2014): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 2016:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L2016): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 2018:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L2018): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4428:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L4428): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4430:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L4430): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4432:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L4432): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4434:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L4434): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4584:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L4584): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4586:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L4586): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4588:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L4588): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4590:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L4590): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4592:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L4592): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4594:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L4594): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4596:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L4596): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4598:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L4598): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4600:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L4600): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 4602:5](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/series.py#L4602): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)

* In the file [`pandas/core/tools/datetimes.py`](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/tools/datetimes.py):

> [Line 646:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/tools/datetimes.py#L646): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 648:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/tools/datetimes.py#L648): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 650:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/core/tools/datetimes.py#L650): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)

* In the file [`pandas/io/sas/sasreader.py`](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/io/sas/sasreader.py):

> [Line 47:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/io/sas/sasreader.py#L47): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 49:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/io/sas/sasreader.py#L49): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)

* In the file [`pandas/io/sql.py`](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/io/sql.py):

> [Line 216:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/io/sql.py#L216): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 218:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/io/sql.py#L218): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 319:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/io/sql.py#L319): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 321:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/io/sql.py#L321): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 406:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/io/sql.py#L406): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)
> [Line 408:1](https://github.com/pandas-dev/pandas/blob/f5efdd82ca70a1d2e47c4ae9fb4cb35b7fc60110/pandas/io/sql.py#L408): [E704](https://duckduckgo.com/?q=pep8%20E704) multiple statements on one line (def)



##### Comment last updated at 2021-04-25 13:23:37 UTC
looks like `pep8speaks` doesn't respect `noqa`...
> looks like `pep8speaks` doesn't respect `noqa`...

any objections to removing `pep8speaks`? We already fail CI if `flake8` fails, so I'm not sure what value it adds
I think I prefer the status quo
Sure, let's stick to that then :+1: