Python: Create csv from json/dictionary

Question

I have the following data that needs to be transformed into a csv:

 "tfeOrganizations": [
        {
            "org": "MyOrg1",
            "org_admins": [
                "[email protected]", "[email protected]"
            ],
            "org_viewers": [
                "[email protected]","[email protected]"
            ],
            "teams": {
                "genericresources-admins": {
                    "ci_cd_token_regenerate": False,
                    "members": ["[email protected]", "[email protected]"],
                    "workspaces": [
                        [
                            "genericresources-dev",
                            "write"
                        ],
                        [
                            "genericresources-qa",
                            "write"
                        ],
                        [
                            "genericresources-prod",
                            "write"
                        ]
                    ]
                 },
                 "genericresources-contributors": {
                    "ci_cd_token_regenerate": False,
                    "members": ["[email protected]", "[email protected]", "[email protected]"],
                    "workspaces": [
                        [
                            "genericresources-dev",
                            "write"
                        ],
                        [
                            "genericresources-qa",
                            "write"
                        ],
                        [
                            "genericresources-prod",
                            "plan"
                        ]
                    ]
                }
            },
            "workspaces": [
                "genericresources-dev",
                "genericresources-qa",
                "genericresources-prod"
            ]
        }
    ]

The result should be something like this whereas the header is built dynamically based on the longest array for the members across all organisations.

organisation,workspace,org_admin1,org_admin2,org_viewer1,org_viewer2,member1,member2,member3,...

MyOrg1,genericresources-dev,[email protected],[email protected],[email protected],[email protected],firstUser@test,[email protected],...

MyOrg1,genericresources-qa,[email protected],[email protected],[email protected],[email protected],firstUser@test,[email protected],...

MyOrg1,genericresources-prod,[email protected],[email protected],[email protected],[email protected],firstUser@test,[email protected],...

Currently I do not how to tackle this problem.

I don't think having a dynamic number of pivoted columns is going to be a good idea — bherbruck
– bherbruck, Commented Jan 12, 2021 at 13:08

perymerdeka · Accepted Answer · 2021-05-05 12:52:25Z

1

you can create with pandas

example

import pandas as pd

# access your json file
your_json = data['tfeOrganizations']


data_frame = pd.DataFrame(your_json)


data_frame.to_csv('result.csv',data_frame)

edited May 5, 2021 at 12:52

answered Jan 12, 2021 at 9:48

perymerdeka

83312 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python: Create csv from json/dictionary

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related