Test conda 4.7.1
Testing conda 4.7.x
# [Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/26595?src=pr&el=h1) Report
> Merging [#26595](https://codecov.io/gh/pandas-dev/pandas/pull/26595?src=pr&el=desc) into [master](https://codecov.io/gh/pandas-dev/pandas/commit/7f318658b92155678b31780722277d1f8c8df569?src=pr&el=desc) will **decrease** coverage by `50.15%`.
> The diff coverage is `n/a`.

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

```diff
@@             Coverage Diff             @@
##           master   #26595       +/-   ##
===========================================
- Coverage   91.84%   41.69%   -50.16%     
===========================================
  Files         174      174               
  Lines       50644    50644               
===========================================
- Hits        46516    21116    -25400     
- Misses       4128    29528    +25400
```

| Flag | Coverage Δ | |
|---|---|---|
| #multiple | `?` | |
| #single | `41.69% <ø> (-0.11%)` | :arrow_down: |

| [Impacted Files](https://codecov.io/gh/pandas-dev/pandas/pull/26595?src=pr&el=tree) | Coverage Δ | |
|---|---|---|
| [pandas/io/formats/latex.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2Zvcm1hdHMvbGF0ZXgucHk=) | `0% <0%> (-100%)` | :arrow_down: |
| [pandas/io/sas/sas\_constants.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL3Nhcy9zYXNfY29uc3RhbnRzLnB5) | `0% <0%> (-100%)` | :arrow_down: |
| [pandas/core/groupby/categorical.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvZ3JvdXBieS9jYXRlZ29yaWNhbC5weQ==) | `0% <0%> (-100%)` | :arrow_down: |
| [pandas/tseries/plotting.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL3RzZXJpZXMvcGxvdHRpbmcucHk=) | `0% <0%> (-100%)` | :arrow_down: |
| [pandas/tseries/converter.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL3RzZXJpZXMvY29udmVydGVyLnB5) | `0% <0%> (-100%)` | :arrow_down: |
| [pandas/io/formats/html.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2Zvcm1hdHMvaHRtbC5weQ==) | `0% <0%> (-99.37%)` | :arrow_down: |
| [pandas/io/sas/sas7bdat.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL3Nhcy9zYXM3YmRhdC5weQ==) | `0% <0%> (-91.16%)` | :arrow_down: |
| [pandas/io/sas/sas\_xport.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL3Nhcy9zYXNfeHBvcnQucHk=) | `0% <0%> (-90.1%)` | :arrow_down: |
| [pandas/core/tools/numeric.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvdG9vbHMvbnVtZXJpYy5weQ==) | `10.14% <0%> (-89.86%)` | :arrow_down: |
| [pandas/io/s3.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL3MzLnB5) | `0% <0%> (-89.48%)` | :arrow_down: |
| ... and [128 more](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree-more) | |

------

[Continue to review full report at Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/26595?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/26595?src=pr&el=footer). Last update [7f31865...418351d](https://codecov.io/gh/pandas-dev/pandas/pull/26595?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/26595?src=pr&el=h1) Report
> Merging [#26595](https://codecov.io/gh/pandas-dev/pandas/pull/26595?src=pr&el=desc) into [master](https://codecov.io/gh/pandas-dev/pandas/commit/c9182df84736ce060c30d386c9f3a97614ca7778?src=pr&el=desc) will **increase** coverage by `1.35%`.
> The diff coverage is `100%`.

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

```diff
@@            Coverage Diff             @@
##           master   #26595      +/-   ##
==========================================
+ Coverage   90.64%      92%   +1.35%     
==========================================
  Files         180      180              
  Lines       50754    50754              
==========================================
+ Hits        46005    46695     +690     
+ Misses       4749     4059     -690
```

| Flag | Coverage Δ | |
|---|---|---|
| #multiple | `90.64% <100%> (ø)` | :arrow_up: |
| #single | `41.85% <0%> (?)` | |

| [Impacted Files](https://codecov.io/gh/pandas-dev/pandas/pull/26595?src=pr&el=tree) | Coverage Δ | |
|---|---|---|
| [pandas/compat/\_optional.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2NvbXBhdC9fb3B0aW9uYWwucHk=) | `100% <ø> (ø)` | :arrow_up: |
| [pandas/io/html.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2h0bWwucHk=) | `94.29% <100%> (ø)` | :arrow_up: |
| [pandas/util/testing.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL3V0aWwvdGVzdGluZy5weQ==) | `90.94% <0%> (+0.1%)` | :arrow_up: |
| [pandas/core/arrays/categorical.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvYXJyYXlzL2NhdGVnb3JpY2FsLnB5) | `95.92% <0%> (+0.12%)` | :arrow_up: |
| [pandas/core/indexes/datetimes.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvaW5kZXhlcy9kYXRldGltZXMucHk=) | `96.37% <0%> (+0.16%)` | :arrow_up: |
| [pandas/io/formats/printing.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2Zvcm1hdHMvcHJpbnRpbmcucHk=) | `86.72% <0%> (+0.94%)` | :arrow_up: |
| [pandas/io/clipboard/clipboards.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL2NsaXBib2FyZC9jbGlwYm9hcmRzLnB5) | `34.78% <0%> (+2.89%)` | :arrow_up: |
| [pandas/core/computation/expr.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvY29tcHV0YXRpb24vZXhwci5weQ==) | `97.8% <0%> (+3.02%)` | :arrow_up: |
| [pandas/core/computation/common.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2NvcmUvY29tcHV0YXRpb24vY29tbW9uLnB5) | `89.47% <0%> (+5.26%)` | :arrow_up: |
| [pandas/io/pytables.py](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree#diff-cGFuZGFzL2lvL3B5dGFibGVzLnB5) | `90.3% <0%> (+25.43%)` | :arrow_up: |
| ... and [1 more](https://codecov.io/gh/pandas-dev/pandas/pull/26595/diff?src=pr&el=tree-more) | |

------

[Continue to review full report at Codecov](https://codecov.io/gh/pandas-dev/pandas/pull/26595?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/26595?src=pr&el=footer). Last update [c9182df...869dab6](https://codecov.io/gh/pandas-dev/pandas/pull/26595?src=pr&el=lastupdated). Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments).
 The remaining failures are due to the `free` channel is no longer included. https://dev.azure.com/pandas-dev/pandas/_build/results?buildId=12064&view=logs&jobId=d6a36677-9147-59f9-684d-001fc5c44c5e&taskId=9cd84fbe-5446-5224-e7d9-fb3364f72566&lineStart=305&lineEnd=306&colStart=1&colEnd=1 and https://dev.azure.com/pandas-dev/pandas/_build/results?buildId=12064&view=logs&jobId=a69e7846-138e-5465-0656-921e8964615b&taskId=b5a8be37-ad64-5774-649a-2b5e4f73cc9a&lineStart=318&lineEnd=319&colStart=1&colEnd=1. Need to either bump those old package versions, remove those optional deps in those builds, or restore free. To summarize, conda is removing the `free` channel by default, so some of our older packages won't be installed. Here are the packages requiring bumps:

library | old pin | minimum conda | release date
------- | ------- | ------------- | ------------
pytz | 2015.4 | 2017.2 | March 2017
beautifulsoup4 | 4.4.1 | 4.6.0 | May 2017
xlwt | 1.0.0  | 1.2.0 | January 2017
python-dateutil | 2.5.0 | 2.6.1 | July 2017
xlsxwriter | 0.7.7 | 0.9.8 | July 2017
openpyxl | 2.4.0 | 2.4.8 | May 2017

Our options

1. Bump our minimum supported versions to those
2. Move to pip for the ones that can't come from Conda anymore
3. Add back the free channel


I think 1 or 2 is fine. I have a slight preference for 1, but either works. Releases are two years old at this point so I think option 1 is fine as well

Sent from my iPhone

> On Jun 11, 2019, at 1:03 PM, Tom Augspurger <notifications@github.com> wrote:
> 
> To summarize, conda is removing the free channel by default, so some of our older packages won't be installed. Here are the packages requiring bumps:
> 
> library	old pin	minimum conda	release date
> pytz	2015.4	2017.2	March 2017
> beautifulsoup4	4.4.1	4.6.0	May 2017
> xlwt	1.0.0	1.2.0	January 2017
> python-dateutil	2.5.0	2.6.1	July 2017
> xlsxwriter	0.7.7	0.9.8	July 2017
> openpyxl	2.4.0	2.4.8	May 2017
> Our options
> 
> Bump our minimum supported versions to those
> Move to pip for the ones that can't come from Conda anymore
> Add back the free channel
> I think 1 or 2 is fine. I have a slight preference for 1, but either works.
> 
> —
> You are receiving this because you are subscribed to this thread.
> Reply to this email directly, view it on GitHub, or mute the thread.
 I agree, ok with bumping Hopefully this next one passes, and we'll be ready.

Reminder: that we don't want to merge this. I'll make another PR for any additional prep changes (right now, just bumping the min version for pymysql) Bumping gcsfs to 0.2.2; That's needed for compatibility with recent versions of dask. FYI I've reverted the Conda-canary install of 4.7.x

This has a few more changes (version bumps) we should merge before 4.7.3 is released, which is happening soonish. Conda 4.7 is out now, so I think this is affecting PRs.

Merging later tonight if there are no objections.