add default  zip file name in dataframe to_csv when use 'infer' + 'zip' method
fix #39465 

copy some code from gzip ,now df.to_csv('myfile.csv.zip') works like df.to_csv('myfile.csv.gz')


- [ ] closes #39465 
- [ ] tests added / passed
- [ ] 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
