Enhancement dataframe to csv use zip method
Enhancement dataframe to csv use zip method,now df.to_csv('myfile.csv.zip') works like df.to_csv('myfile.csv.gz'), generate a zip file with a myfile.csv as content

- [ ] closes #39465 
- [ ] tests added / passed,simply test
- [ ] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing.html#code-standards) for how to run them
- [ ] whatsnew entry

## test code
>> import pandas as pd
a=pd.DataFrame({'a':[1,2,3,4,5],'b':[4,5,6,7,8]})
a.to_csv(r'z:/myfile.csv.zip')

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:



* In the file [`pandas/tests/frame/methods/test_to_csv.py`](https://github.com/pandas-dev/pandas/blob/f21de23589aafe0af00fbe3a47968704bba10dab/pandas/tests/frame/methods/test_to_csv.py):

> [Line 1336:1](https://github.com/pandas-dev/pandas/blob/f21de23589aafe0af00fbe3a47968704bba10dab/pandas/tests/frame/methods/test_to_csv.py#L1336): [W391](https://duckduckgo.com/?q=pep8%20W391) blank line at end of file

* In the file [`pandas/tests/io/formats/test_to_csv.py`](https://github.com/pandas-dev/pandas/blob/f21de23589aafe0af00fbe3a47968704bba10dab/pandas/tests/io/formats/test_to_csv.py):

> [Line 651:21](https://github.com/pandas-dev/pandas/blob/f21de23589aafe0af00fbe3a47968704bba10dab/pandas/tests/io/formats/test_to_csv.py#L651): [E126](https://duckduckgo.com/?q=pep8%20E126) continuation line over-indented for hanging indent



##### Comment last updated at 2021-03-11 07:51:12 UTC