import pandas as pd employees = { "bdoe@email.com": { "first_name": "Bob", "last_name": "Doe", "address": { "city": "New York", "street": "1st Street", "house_number": 1 } }, "mmarkson@email.com": { "first_name": "Mark", "last_name": "Markson", "address": { "city": "San Diego", "street": "2nd Street", "house_number": 2 } } } pd.DataFrame(employees)