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