skip to Main Content

Converting JSON Dictionary to Dataframe

I am relatively new to JSON and after going through several tutorials I have decided to reach out here for additional advice. I am trying to convert the following JSON dictionary via Jupyternotebook/Pandas into a dataframe and later into a…

VIEW QUESTION

Json – Trying to iterate through a list of dictionaries

I have json list. I would like to iterate "PrivateIP" through a list of dirctories and append to the empty list: here's the code: InstanceId = [] message = [{"SNowTicket":"RITM00001","ServerIPList":[{"PrivateIP":"182.0.0.0", "HostName":"ip-182-0-0-0.ec2.internal", "Region":"us-east-1", "AccountID":"12345678"}, {"PrivateIP": "182.1.1.1", "HostName": "ip-182-1-1-1.ec2.internal", "Region": "us-east-1", "AccountID":…

VIEW QUESTION
Back To Top
Search