employees = [ { "first_name": "Bob", "last_name": "Doe", "email": "bdoe@email.com", "address": { "city": "New York", "street": "1st Street", "house_number": 1 } }, { "first_name": "Mark", "last_name": "Markson", "email": "mmarkson@email.com", "address": { "city": "San Diego", "street": "2nd Street", "house_number": 2 } } ] # Flatten the records first employees_flat = [flatten_dict(emp) for emp in employees] pd.DataFrame(employees_flat)