BUG: DataFrame to_csv compression with 'zip' use zipfilename as archive name

[CyberQin]

• I have checked that this issue has not already been reported.

• I have confirmed this bug exists on the latest version of pandas.

• (optional) I have confirmed this bug exists on the master branch of pandas.

---

a=pd.DataFrame({'a':[1,2,3,4,5],'b':[4,5,6,7,8]})
a.to_csv('myfile.csv.zip')

Problem description

when use gzip method, the function works fine, a.to_csv('myfile.csv.gz') will create a gzip file with an archive file named myfile.csv.
the "zip" method works bad,a.to_csv('myfile.csv.zip') will create a zipfile with an archive file named myfile.csv.zip

[twoertwein]

the "zip" method works bad,a.to_csv('myfile.csv.zip') will create a zipfile with an archive file named myfile.csv.zip

Do you want to create a PR to remove the ".zip" suffix? If you need a workaround:
pd.to_csv("test.csv.zip", compression={"method": "zip", "archive_name": "test.csv"})

and an strange case shows that a large dataframe will report dumplicate archive name

are you using 1.2.1? #38714

[CyberQin]

the "zip" method works bad,a.to_csv('myfile.csv.zip') will create a zipfile with an archive file named myfile.csv.zip

Do you want to create a PR to remove the ".zip" suffix? If you need a workaround:
pd.to_csv("test.csv.zip", compression={"method": "zip", "archive_name": "test.csv"})

and an strange case shows that a large dataframe will report dumplicate archive name

are you using 1.2.1? #38714

@twoertwein

now i'm using 1.2.1,i add a pr(#39647 ) to do some work with the name problem,but not the large dataframe problem

[twoertwein]

do you still have the issue with the large dataframe when using 1.2.1?

[WillAyd]

Is this different than #26023?

[CyberQin]

Is this different than #26023?

same purpose, but my PR#40387 will take "myfile" as archive_name when "myfile.zip" used as zipfile name,just like gzip or xz. It won't add ".csv" to the end of "myfile" automatically.
"myfile.csv.zip"->"myfile.csv"
"myfile.zip"->"myfile"
"myfile.csv.csv.zip"->"myfile.csv.csv"