QST: How to export json as zip without directories

[danymat]

Hello Everyone, I searched a possible answer for my question without success.

Suppose I start my python script in the root directory of this structure tree:

.
├── Dockerfile
├── files
├── scripts

In this script I read a csv from files, with a read_csv('files/filename.csv')

When I try to export a modified dataframe with to_json('files/export.zip', compression='zip'), I get a zipped file with the correct name, but when unzipping, I get a folder named files, and the json inside.

How can I export the json file in zip without having the root files directory listed ?

Note: This is a related problem below, but I was hoping a builtin solution with to_json()
https://unix.stackexchange.com/questions/182032/zip-the-contents-of-a-folder-without-including-the-folder-itself

[twoertwein]

to_csv does the same. Changing the behavior should be fairly easy, simply adding

if archive_name is not None:
    archive_name = os.path.basename(archive_name)

before

pandas/pandas/io/common.py

Line 776 in 671cf86

self.archive_name = archive_name

Do you want to create a PR? This probably needs some discussion as some people might expect the nested behavior.

[robbiesumner]

I tried it myself and it didn't happen for me, the zip archive gives me only the export json. Is this still an issue?

[mroeschke]

Thanks for the issue, but it appears this hasn't gotten traction in a while so closing