[DOC] Fix typo in Cheat sheet with regex
State: closed

- [x ] closes #25156
- [x ] tests added / passed
   tests not needed - just a doc change
- [x ] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
  not needed - just a doc change
- [x ] whatsnew entry
   Not needed - just a doc change

Small typo fixed in Powerpoint and PDF versions of cheat sheet.

Ideally, when merged, new PDF versions should push to current pandas release.


Labels:
name: Docs

Comments:
# [Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/25215?src=pr&el=h1) Report
> Merging [#25215](https://codecov.io/gh/pandas-dev/pandas/pull/25215?src=pr&el=desc) into [master](https://codecov.io/gh/pandas-dev/pandas/commit/683c7b55f5195fdf4f524239066cbf6f1301f0e7?src=pr&el=desc) will **increase** coverage by `<.01%`.
> The diff coverage is `n/a`.

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

```diff
@@            Coverage Diff             @@
##           master   #25215      +/-   ##
==========================================
+ Coverage   92.34%   92.35%   +<.01%     
==========================================
  Files         166      166              
  Lines       52314    52314              
==========================================
+ Hits        48311    48312       +1     
+ Misses       4003     4002       -1
```

| Flag | Coverage Δ | |
|---|---|---|
| #multiple | `90.78% <ø> (ø)` | :arrow_up: |
| #single | `42.84% <ø> (-0.01%)` | :arrow_down: |

| [Impacted Files](https://codecov.io/gh/pandas-dev/pandas/pull/25215?src=pr&el=tree) | Coverage Δ | |
|---|---|---|
| [pandas/util/testing.py](https://codecov.io/gh/pandas-dev/pandas/pull/25215/diff?src=pr&el=tree#diff-cGFuZGFzL3V0aWwvdGVzdGluZy5weQ==) | `88.05% <0%> (+0.09%)` | :arrow_up: |

------

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

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

```diff
@@            Coverage Diff             @@
##           master   #25215      +/-   ##
==========================================
- Coverage   91.72%   91.72%   -0.01%     
==========================================
  Files         173      173              
  Lines       52842    52843       +1     
==========================================
  Hits        48469    48469              
- Misses       4373     4374       +1
```

| Flag | Coverage Δ | |
|---|---|---|
| #multiple | `90.28% <ø> (ø)` | :arrow_up: |
| #single | `41.72% <ø> (ø)` | :arrow_up: |

| [Impacted Files](https://codecov.io/gh/pandas-dev/pandas/pull/25215?src=pr&el=tree) | Coverage Δ | |
|---|---|---|
| [pandas/util/testing.py](https://codecov.io/gh/pandas-dev/pandas/pull/25215/diff?src=pr&el=tree#diff-cGFuZGFzL3V0aWwvdGVzdGluZy5weQ==) | `87.57% <0%> (-0.1%)` | :arrow_down: |
| [pandas/core/dtypes/dtypes.py](https://codecov.io/gh/pandas-dev/pandas/pull/25215/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvZHR5cGVzL2R0eXBlcy5weQ==) | `95.6% <0%> (+0.01%)` | :arrow_up: |

------

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

it shows you are deleting a file, is that intentional? maybe need to update the .gitignore.
@jreback I think this is some odd bug in github reporting.  It shows on the files changed:
```
BIN -4 Bytes (100%) doc/cheatsheet/Pandas_Cheat_Sheet.pptx
```
But if you click on that file, it shows it is 103KB big, which is correct.  So I don't see the deletion that you refer to.

Looking at the file that is in master and the file in my pull request, the new file is 4 bytes smaller (makes sense - I only deleted a single quote), comparing to master.  The "-100%" is wrong.
Hmm that's weird. I suppose its the same issue we are seeing in #25032 then
@WillAyd Possibly so, but if there are two pending pull requests on the cheat sheet, they will not merge correctly. because the files are binary
For sure; whichever gets merged first will have to be accounted for in second PR
@Dr-Irv can you rebase here (sorry the other PR was first) :>
@jreback I've done that.  Note that I think these fixes should get published as soon as possible to the pandas doc web site rather than wait for a new release, since the changes here and in #25032 are just fixing typos.
I can upload these manually I think. Just ping me again once this is merged.

On Mon, Feb 11, 2019 at 8:40 AM Irv Lustig <notifications@github.com> wrote:

> @jreback <https://github.com/jreback> I've done that. Note that I think
> these fixes should get published as soon as possible to the pandas doc web
> site rather than wait for a new release, since the changes here and in
> #25032 <https://github.com/pandas-dev/pandas/pull/25032> are just fixing
> typos.
>
> —
> You are receiving this because you are subscribed to this thread.
> Reply to this email directly, view it on GitHub
> <https://github.com/pandas-dev/pandas/pull/25215#issuecomment-462351027>,
> or mute the thread
> <https://github.com/notifications/unsubscribe-auth/ABQHIrKgvAPf-aJRVZJmwA--xxkXuRboks5vMYD3gaJpZM4anesA>
> .
>

Hmm it looks like our current one is pretty out of data.

Does this get included anywhere in the rst documentation? Or is it just the
link from getting_started/tutorials.rst ->
pandas.pydata.org/Pandas_Cheat_Sheet.pdf?

On Mon, Feb 11, 2019 at 8:42 AM Tom Augspurger <tom.augspurger88@gmail.com>
wrote:

> I can upload these manually I think. Just ping me again once this is
> merged.
>
> On Mon, Feb 11, 2019 at 8:40 AM Irv Lustig <notifications@github.com>
> wrote:
>
>> @jreback <https://github.com/jreback> I've done that. Note that I think
>> these fixes should get published as soon as possible to the pandas doc web
>> site rather than wait for a new release, since the changes here and in
>> #25032 <https://github.com/pandas-dev/pandas/pull/25032> are just fixing
>> typos.
>>
>> —
>> You are receiving this because you are subscribed to this thread.
>> Reply to this email directly, view it on GitHub
>> <https://github.com/pandas-dev/pandas/pull/25215#issuecomment-462351027>,
>> or mute the thread
>> <https://github.com/notifications/unsubscribe-auth/ABQHIrKgvAPf-aJRVZJmwA--xxkXuRboks5vMYD3gaJpZM4anesA>
>> .
>>
>

@TomAugspurger I believe we just have the link as you wrote it, but there was supposed to be some process for copying over the PDF files to the location `pandas.pydata.org/Pandas_Cheat_Sheet.pdf` .

> Hmm it looks like our current one is pretty out of data. Does this get included anywhere in the rst documentation? Or is it just the link from getting_started/tutorials.rst -> pandas.pydata.org/Pandas_Cheat_Sheet.pdf? On Mon, Feb 11, 2019 at 8:42 AM Tom Augspurger <tom.augspurger88@gmail.com> wrote:
> […](#)
> I can upload these manually I think. Just ping me again once this is merged. On Mon, Feb 11, 2019 at 8:40 AM Irv Lustig ***@***.***> wrote: > @jreback <https://github.com/jreback> I've done that. Note that I think > these fixes should get published as soon as possible to the pandas doc web > site rather than wait for a new release, since the changes here and in > #25032 <#25032> are just fixing > typos. > > — > You are receiving this because you are subscribed to this thread. > Reply to this email directly, view it on GitHub > <[#25215 (comment)](https://github.com/pandas-dev/pandas/pull/25215#issuecomment-462351027)>, > or mute the thread > <https://github.com/notifications/unsubscribe-auth/ABQHIrKgvAPf-aJRVZJmwA--xxkXuRboks5vMYD3gaJpZM4anesA> > . >


Yep. https://github.com/pandas-dev/pandas-release/issues/6

On Mon, Feb 11, 2019 at 9:07 AM Irv Lustig <notifications@github.com> wrote:

> @TomAugspurger <https://github.com/TomAugspurger> I believe we just have
> the link as you wrote it, but there was supposed to be some process for
> copying over the PDF files to the location
> pandas.pydata.org/Pandas_Cheat_Sheet.pdf .
>
> Hmm it looks like our current one is pretty out of data. Does this get
> included anywhere in the rst documentation? Or is it just the link from
> getting_started/tutorials.rst -> pandas.pydata.org/Pandas_Cheat_Sheet.pdf?
> On Mon, Feb 11, 2019 at 8:42 AM Tom Augspurger tom.augspurger88@gmail.com
> wrote:
> … <#m_8789983984663818157_>
> I can upload these manually I think. Just ping me again once this is
> merged. On Mon, Feb 11, 2019 at 8:40 AM Irv Lustig ***@***.***> wrote: >
> @jreback <https://github.com/jreback> https://github.com/jreback I've
> done that. Note that I think > these fixes should get published as soon as
> possible to the pandas doc web > site rather than wait for a new release,
> since the changes here and in > #25032
> <https://github.com/pandas-dev/pandas/pull/25032> <#25032
> <https://github.com/pandas-dev/pandas/pull/25032>> are just fixing >
> typos. > > — > You are receiving this because you are subscribed to this
> thread. > Reply to this email directly, view it on GitHub > <#25215
> (comment)
> <https://github.com/pandas-dev/pandas/pull/25215#issuecomment-462351027>>,
> > or mute the thread >
> https://github.com/notifications/unsubscribe-auth/ABQHIrKgvAPf-aJRVZJmwA--xxkXuRboks5vMYD3gaJpZM4anesA
> > . >
>
> —
> You are receiving this because you were mentioned.
> Reply to this email directly, view it on GitHub
> <https://github.com/pandas-dev/pandas/pull/25215#issuecomment-462361324>,
> or mute the thread
> <https://github.com/notifications/unsubscribe-auth/ABQHIqmIw5SYG_oGQtEny4raI21NHffxks5vMYdLgaJpZM4anesA>
> .
>

thanks @Dr-Irv 
I updated the cheatsheets on pandas.pydata.org with the latest version.

On Mon, Feb 11, 2019 at 1:40 PM Jeff Reback <notifications@github.com>
wrote:

> Merged #25215 <https://github.com/pandas-dev/pandas/pull/25215> into
> master.
>
> —
> You are receiving this because you were mentioned.
> Reply to this email directly, view it on GitHub
> <https://github.com/pandas-dev/pandas/pull/25215#event-2131585871>, or mute
> the thread
> <https://github.com/notifications/unsubscribe-auth/ABQHIlyoNBhKJ7vROzS4F26QlCJFfFbpks5vMccqgaJpZM4anesA>
> .
>

@TomAugspurger can you check that?  If I go to http://pandas.pydata.org/Pandas_Cheat_Sheet.pdf, I'm seeing the old version.  You can tell by looking in two places:

1. On the left side, right above "Create DataFrame with a MultiIndex", there should be two right parens.
2. The last regex on the right side should have one single quote, not two.

It seems like these are getting cached pretty aggressively. I removed the
files completely, but we were still serving them.

When I scp the files from the server locally, I have the corrected version.

Let's check again tomorrow.

On Mon, Feb 11, 2019 at 8:26 PM Irv Lustig <notifications@github.com> wrote:

> @TomAugspurger <https://github.com/TomAugspurger> can you check that? If
> I go to http://pandas.pydata.org/Pandas_Cheat_Sheet.pdf, I'm seeing the
> old version. You can tell by looking in two places:
>
>    1. On the left side, right above "Create DataFrame with a MultiIndex",
>    there should be two right parens.
>    2. The last regex on the right side should have one single quote, not
>    two.
>
> —
> You are receiving this because you were mentioned.
> Reply to this email directly, view it on GitHub
> <https://github.com/pandas-dev/pandas/pull/25215#issuecomment-462587475>,
> or mute the thread
> <https://github.com/notifications/unsubscribe-auth/ABQHIhSfmcuHqXi_GINpv_Um-skd2YlUks5vMiZjgaJpZM4anesA>
> .
>

@TomAugspurger Looks good this morning.  Thanks