Extract a JSON from an API and I need to extract into different dataframes all information
In the JSON, I have information within each main object, which includes sub-objects and lists of objects with more details.
How do I convert a JSON file to a Dataframe while limiting the amount of data taken from JSON file?
I have a JSON file that is an output from a skip tracing API. It has my original data that includes columns for address, city, state, beds, and baths, combined with the data obtained from the API (name, telephones, emails. However, for some addresses, the API returned more than 3 names for the property. Each name has numerous telephone numbers and emails associated with it. Is it possible to convert this data to a dataframe, so that there is a separate column for each name, phone, and email while at the same time limiting the amount of names taken from the JSON file to maybe 3 or 4 names per address? Additionally, each row is a different address, and each name, email, and phone, must be in the same row per address, otherwise the data will not be correct. I am using Python. Example of JSON output from code