Formatting JSON data in Python

Question

I am sending JSON data over post method to one of my ML models, the problem is it is not able to pick which object to fetch for fields.

Below is the sample JSON

 {
    "a": {
        "asD": 1553990400000,
        "cust": "S65A00",
        "party": "1234",
        "custS": null,
        "sngldt: 1557014400000,
},
 "b": {
        "History": [],
        "cust": "S65A00",
        "mb_cntry": "US",
        "mbdt": 1490918400000,
        "mbsg_dt": 1553904000000,
}
}

How Can I Merge this JSON in the ML Code in single braces like below, I don't have the luxury to format the JSON itself during Post request.

{

        "asD": 1553990400000,
        "cust": "S65A00",
        "party": "1234",
        "custS": null,
        "sngldt: 1557014400000,
        "History": [],
        "mb_cntry": "US",
        "mbdt": 1490918400000,
        "mbsg_dt": 1553904000000,

}

Below is the code that I have tried but failing

@app.route('/', methods=['GET', 'POST'])
def execute():
    if request.method == 'POST':
        json_data = request.get_json()
        batch=json.dumps(json_data)
        dataFrame = pd.DataFrame(json_data)
        print(len(dataFrame.columns))
        df=pd.melt(dataFrame,id_vars=[' ','b'],  value_name='values')
        print(df)

Hariharan AR · Accepted Answer · 2019-07-23 10:05:09Z

2

merged = dict()
merged.update(obj.a)
merged.update(obj.b)

answered Jul 23, 2019 at 10:05

Hariharan AR

1,55614 silver badges22 bronze badges

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

Comments

RomanPerekhrest · Accepted Answer · 2019-07-23 10:09:31Z

1

With unpacking syntax:

...
json_data = dict(json_data['a'], **json_data['b'])
print(json_data)

prints:

{'asD': 1553990400000, 'cust': 'S65A00', 'party': '1234', 'custS': 'null', 'sngldt': 1557014400000, 'History': [], 'mb_cntry': 'US', 'mbdt': 1490918400000, 'mbsg_dt': 1553904000000}

answered Jul 23, 2019 at 10:09

RomanPerekhrest

93.1k4 gold badges75 silver badges112 bronze badges

Collectives™ on Stack Overflow

Formatting JSON data in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related