ENH: Make to_csv('filename.csv.zip') compress the output
- [x] closes #39465 #26023
- [x] tests added / passed
- [x] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing.html#code-standards) for how to run them
- [x] dataframe.to_csv  with zip compression now works like gzip/xz, when use 'infer' and destination path 'xxxx.csv.zip' which endwith '.zip', to_csv will create a zip file with archive_name=xxxx.csv

close old PR,do some work after read pre commit guidelines
Hello @HQDragon! 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:





There are currently no PEP 8 issues detected in this Pull Request. Cheers! :beers: 

##### Comment last updated at 2021-03-16 00:40:58 UTC CI check failed is not caused by changed files, it exist in master branch.
It seems checks failed randomly. commit "582f454“ passed all checks ,commit "a555acd" failed, i only changed imports position between these commits.
How to restart partial checks without new commit @HQDragon can you add a whatsnew note also the precommit checks are failing This pull request is stale because it has been open for thirty days with no activity. Please update or respond to this comment if you're still interested in working on this. > Thanks @HQDragon, can you merge master and address the comments please? I think this is close to ready.

@HQDragon, can you merge master and address the comments please? Appears that this PR has gone stale thought it's close to ready. Going to close for now but let us know if you'd like to continue working on this and we'd be happy to reopen.