Forum Discussion
JSON - Remove Specific Row/Column
Anonymous not sure if this answers your question as I might need more context. Are you just trying to parse the JSOn object and only return the elements except for "customer notes". If so I recommend trying the json-normalize library. Try "from pandas.io.json import json_normalize" then "json_normalize(#API Response JSON Object#)" to convert the json object into a DF you want. From there simply parse the DF and do not extract the values of "customer notes" and feed this data into a new data structure that you can feed into Power BI via CSV or however else you are doing it. Apologies if I totally misunderstood the context or what you were asking for. Best!
Anonymous not sure if this answers your question as I might need more context. Are you just trying to parse the JSOn object and only return the elements except for "customer notes". If so I recommend trying the json-normalize library. Try "from pandas.io.json import json_normalize" then "json_normalize(#API Response JSON Object#)" to convert the json object into a DF you want. From there simply parse the DF and do not extract the values of "customer notes" and feed this data into a new data structure that you can feed into Power BI via CSV or however else you are doing it. Apologies if I totally misunderstood the context or what you were asking for. Best!
Yes exactly, I am trying to return all the elements except customer notes!
Let me look into that getting this all to even work was a whirlwind so I appreciate the help.
Anonymous no worries. let me know if you need further help with normalizing the JSON or parsing the DF you create. I can possibly send over snippets of the Python code I used to pull data from the Google Maps Distance matrix API if it would help you. Best!