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.

Answer 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)


pd.to_csv('result.csv',dataframe)