CLN/COMPAT: for various py2/py3 in doc/bench scripts
State: closed

 - [ ] closes #xxxx
 - [ ] tests added / passed
 - [ ] passes ``git diff upstream/master -u -- "*.py" | flake8 --diff``
 - [ ] whatsnew entry


Labels:
name: Clean

Comments:
Hello @cclauss! Thanks for updating the PR.





 - In the file [`doc/sphinxext/ipython_sphinxext/ipython_directive.py`](https://github.com/pandas-dev/pandas/blob/a3efe34ccfbc65af5a275ab580e9e1661e37f437/doc/sphinxext/ipython_sphinxext/ipython_directive.py), following are the PEP8 issues :

> [Line 114:80](https://github.com/pandas-dev/pandas/blob/a3efe34ccfbc65af5a275ab580e9e1661e37f437/doc/sphinxext/ipython_sphinxext/ipython_directive.py#L114): [E501](https://duckduckgo.com/?q=pep8%20E501) line too long (84 > 79 characters)





##### Comment last updated on July 17, 2017 at 11:41 Hours UTC
instead of this would be happy with progress on https://github.com/pandas-dev/pandas/issues/13704

blow away most of these scripts 
# [Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/16984?src=pr&el=h1) Report
> Merging [#16984](https://codecov.io/gh/pandas-dev/pandas/pull/16984?src=pr&el=desc) into [master](https://codecov.io/gh/pandas-dev/pandas/commit/692b5eeeff9b8e8c750f3e64db0c39dc149a73e8?src=pr&el=desc) will **decrease** coverage by `0.01%`.
> The diff coverage is `n/a`.

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

```diff
@@            Coverage Diff             @@
##           master   #16984      +/-   ##
==========================================
- Coverage   90.99%   90.97%   -0.02%     
==========================================
  Files         161      161              
  Lines       49293    49293              
==========================================
- Hits        44854    44845       -9     
- Misses       4439     4448       +9
```

| Flag | Coverage Δ | |
|---|---|---|
| #multiple | `88.74% <ø> (ø)` | :arrow_up: |
| #single | `40.2% <ø> (-0.07%)` | :arrow_down: |

| [Impacted Files](https://codecov.io/gh/pandas-dev/pandas/pull/16984?src=pr&el=tree) | Coverage Δ | |
|---|---|---|
| [pandas/io/gbq.py](https://codecov.io/gh/pandas-dev/pandas/pull/16984?src=pr&el=tree#diff-cGFuZGFzL2lvL2dicS5weQ==) | `25% <0%> (-58.34%)` | :arrow_down: |
| [pandas/core/frame.py](https://codecov.io/gh/pandas-dev/pandas/pull/16984?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvZnJhbWUucHk=) | `97.76% <0%> (-0.1%)` | :arrow_down: |

------

[Continue to review full report at Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/16984?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/16984?src=pr&el=footer). Last update [692b5ee...eb02e03](https://codecov.io/gh/pandas-dev/pandas/pull/16984?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/16984?src=pr&el=h1) Report
> Merging [#16984](https://codecov.io/gh/pandas-dev/pandas/pull/16984?src=pr&el=desc) into [master](https://codecov.io/gh/pandas-dev/pandas/commit/692b5eeeff9b8e8c750f3e64db0c39dc149a73e8?src=pr&el=desc) will **decrease** coverage by `0.01%`.
> The diff coverage is `n/a`.

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

```diff
@@            Coverage Diff             @@
##           master   #16984      +/-   ##
==========================================
- Coverage   90.99%   90.97%   -0.02%     
==========================================
  Files         161      161              
  Lines       49293    49293              
==========================================
- Hits        44854    44845       -9     
- Misses       4439     4448       +9
```

| Flag | Coverage Δ | |
|---|---|---|
| #multiple | `88.74% <ø> (ø)` | :arrow_up: |
| #single | `40.2% <ø> (-0.07%)` | :arrow_down: |

| [Impacted Files](https://codecov.io/gh/pandas-dev/pandas/pull/16984?src=pr&el=tree) | Coverage Δ | |
|---|---|---|
| [pandas/io/gbq.py](https://codecov.io/gh/pandas-dev/pandas/pull/16984?src=pr&el=tree#diff-cGFuZGFzL2lvL2dicS5weQ==) | `25% <0%> (-58.34%)` | :arrow_down: |
| [pandas/core/frame.py](https://codecov.io/gh/pandas-dev/pandas/pull/16984?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvZnJhbWUucHk=) | `97.76% <0%> (-0.1%)` | :arrow_down: |

------

[Continue to review full report at Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/16984?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/16984?src=pr&el=footer). Last update [692b5ee...a3efe34](https://codecov.io/gh/pandas-dev/pandas/pull/16984?src=pr&el=lastupdated). Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments).

> instead of this would be happy with progress on #13704

@jreback  : I agree with this.  Should we close then?
#13704 has been open almost one year.  I can look into it but that is going to require me learning much more project context to make sure that useful code is not thrown away in the process.  The contents of this pull request are targeted changes to ensure that the entire project can pass a flake8 test.  I think that gives them value even if the files that they are in are deleted next week or next month.
> The contents of this pull request are targeted changes to ensure that the entire project can pass a flake8 test.

We actually don't check those files during `flake8`.

> I think that gives them value even if the files that they are in are deleted next week or next month.

That is fair.  I'm kind of indifferent given that there hasn't been much progress on this.  I'll leave it to @jreback to decide since he piloted the issue in the first place.
@cclauss you don't need to make these separate commits. I am going to squash this anyhow.
@jreback Yes, please squash!  Thanks.
So each time a push happens the CI's are all triggered. They do fail with duplicates (IOW a new push is spun up). You can certainly have many commits, just don't push after *each* one.
thanks @cclauss 
if you wanted to fix the remaining on this issue: https://github.com/pandas-dev/pandas/issues/13704

would be great.