Fixed rendering of ticks in error bars
- [x] closes #17467
- [x] tests passed
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [ ] whatsnew entry

# [Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/17468?src=pr&el=h1) Report
> Merging [#17468](https://codecov.io/gh/pandas-dev/pandas/pull/17468?src=pr&el=desc) into [master](https://codecov.io/gh/pandas-dev/pandas/commit/aed9b921394efb13ed1b7870508e8638db951101?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/17468/graphs/tree.svg?width=650&token=eZ4WkYLtcO&height=150&src=pr)](https://codecov.io/gh/pandas-dev/pandas/pull/17468?src=pr&el=tree)

```diff
@@            Coverage Diff             @@
##           master   #17468      +/-   ##
==========================================
- Coverage   91.23%   91.21%   -0.02%     
==========================================
  Files         163      163              
  Lines       50102    50102              
==========================================
- Hits        45712    45703       -9     
- Misses       4390     4399       +9
```

| Flag | Coverage Δ | |
|---|---|---|
| #multiple | `89.03% <ø> (ø)` | :arrow_up: |
| #single | `40.31% <ø> (-0.06%)` | :arrow_down: |

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

------

[Continue to review full report at Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/17468?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/17468?src=pr&el=footer). Last update [aed9b92...0289098](https://codecov.io/gh/pandas-dev/pandas/pull/17468?src=pr&el=lastupdated). Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments).
 How did this change changed the coverage? Any feedback on this PR would be appreciated... In https://github.com/pandas-dev/pandas/pull/17462 we're discussing changing the style to seaborn or matplotlib 2.0's new defaults. I think both of those also suppress the caps for error bars (by default).

Any reason you want to explicitly add them? Just a style thing? Well, as is, the code in the example doesn't yield the rendered result. I had (using matplotlib 2.0 and ggplot/default style) to add the `cap` related option. So this PR is mostly for the sake of correctness of the documentation.  I think if you were to set `matplotlib.style.use('seaborn')` before making
the plot, you'll see the caps. But since we're changing the style used in
the docs, I don't think we need the changes here, unless I'm
misunderstanding something.

On Mon, Sep 11, 2017 at 1:58 PM, Dror Atariah <notifications@github.com>
wrote:

> Well, as is, the code in the example doesn't yield the rendered result. I
> had (using matplotlib 2.0 and ggplot/default style) to add the cap
> related option. So this PR is mostly for the sake of correctness of the
> documentation.
>
> —
> You are receiving this because your review was requested.
> Reply to this email directly, view it on GitHub
> <https://github.com/pandas-dev/pandas/pull/17468#issuecomment-328625539>,
> or mute the thread
> <https://github.com/notifications/unsubscribe-auth/ABQHIsLrdrL16Bo32Jmb2qUphX5yd1Icks5shYLGgaJpZM4PQRH->
> .
>
 If the change you plan will fix the rendered plot, then you're right. In any case, the current status where the rendered image is *not* yielded by the sample code is confusing.  > In any case, the current status where the rendered image is not yielded by the sample code is confusing

Yeah it's strange since those aren't static images, they're generated as the code runs. Maybe a version mismatch between your environment and the docs?

Either way I think aesthetically the version without caps looks better. What do you think? Regarding the environment: could be... I failed to installed the environment as described [here](https://pandas.pydata.org/pandas-docs/stable/contributing.html#creating-a-development-environment) but this is a different story I guess.

As for the aesthetic aspect --- I think the caps are crucial for faster and better perception of the error bars. Hello @drorata! Thanks for updating the PR.

 - In the file [`pandas/io/sql.py`](https://github.com/pandas-dev/pandas/blob/0289098ae20ef1c88437186d224ec11dc689a828/pandas/io/sql.py), following are the PEP8 issues :

> [Line 113:80](https://github.com/pandas-dev/pandas/blob/0289098ae20ef1c88437186d224ec11dc689a828/pandas/io/sql.py#L113): [E501](https://duckduckgo.com/?q=pep8%20E501) line too long (80 > 79 characters)

 @drorata It seems something went wrong with the latest update, as there is now some unrelated code in the diff. As per @TomAugspurger [comment](https://github.com/pandas-dev/pandas/pull/17468#issuecomment-328628462) I guess this PR should be closed and not merged.