Flatten Json Nested Loop in Python

Question

I've a CSV which has a column in JSON format. Could please let me know ways to flatten JSON for the following with Python?

{
    "xxx": {
        "A": "741",
        "B": "Jacob",
        "C": {
            "UId": "1234",
            "Name": "Jacob",
            "Class": "Two",
            "Age": "07"
        },
        "D": "None",
        "E": "None",
        "F": "None",
        "G": "None",
        "H": "None",
        "I": "None",
        "J": "None",
        "K": "None",
        "L": {
            "Id1": "852",
            "CompanyName": "Jacob and Sons",
            "Id2": "963",
            "Address": "zoo",
            "J": {
                "Product": [{
                    "AId": "789",
                    "AName": "Rice",
                    "AType": "Basmati"
                }, {
                    "AId": "456",
                    "AName": "Soup",
                    "AType": "Tomato"
                }, {
                    "AId": "123",
                    "AName": "Milk",
                    "AType": "Almond"
                }, {
                    "AId": "000",
                    "AName": "Yogurt",
                    "AType": "Greek"
                }]
            }
        },
        "Order": {
            "Pending": "None",
            "Orders": [{
                "A": "159",
                "B": "753",
                "C": "ABC",
                "D": "EFG",
                "E": "blablabla",
                "Date": "2016-10-02T17:27:04Z",
                "Status": "Completed",
                "xxx": {
                    "F": "789",
                    "G": "456",
                    "H": "qwe",
                    "I": "asd",
                    "J": "123",
                    "K": "None"
                },
                "Z": "None"
            }, {
                "A": "951",
                "B": "357",
                "C": "mnb",
                "D": "lkj",
                "E": "hehehe",
                "Date": "2016-10-02T17:27:04Z",
                "Status": "Completed",
                "xxx": {
                    "F": "",
                    "G": "",
                    "H": "",
                    "I": "",
                    "J": "215737",
                    "K": "None"
                },
                "Z": "None"
            }],
            "Y": [{
                "A": "456",
                "B": "963",
                "C": "tyu",
                "D": "fgh",
                "E": "vbn",
                "H": "2016-10-02T17:22:38Z",
                "J": "2016-10-02T17:27:04Z",
                "K": "None",
                "Z": {
                    "A": "846",
                    "B": "ABC",
                    "C": "def",
                    "D": "rdx",
                    "F": "cde",
                    "G": "opk",
                    "H": "yum",
                    "J": "852"
                }
            }]
        },
        "Values": "None"
    },
    "ValidErrors": {
        "Errors": [{
            "Code": "123",
            "Description": "No detail"
        }, {
            "Code": "456",
            "Description": "No Service"
        }, {
            "Code": "789",
            "Description": "Try again"
        }]
    },
    "Status": "Active",
    "Number": "789654321"
}

https://stackoverflow.com/questions/39899005/how-to-flatten-a-pandas-dataframe-with-some-columns-as-json — gre_gor, Jul 13 '22 at 18:45

score -2 · Answer 1 · edited Jul 13 '22 at 20:43

-2

You can use the json library => https://docs.python.org/3/library/json.html

import json
flattenJsonStr = json.dumps(json.loads(jsonStr))

this should do the job

edited Jul 13 '22 at 20:43

gre_gor

6,669
9
47
52

answered Oct 23 '20 at 14:31

GabrielC

322
1
6

dumps just makes it a string I even used json_normalize but the nested loop doesn't flatten into a dataframe or dictionary – Niki Oct 23 '20 at 14:50
By flatten they don't mean "JSON in a single line". – gre_gor Jul 13 '22 at 18:09

Flatten Json Nested Loop in Python

1 Answers1