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

I tried merging my original JSON file with the new JSON file but it did not give me the results I needed.