Load Json Nested to Dataframe Pandas

import pandas as pd

dct = {"info":[
    {"name":"LYDIANA","address":[{"home":"San Francisco"},{"work":"Carolina"}],"emails":[],"phones":[{"work":"1234567"},{"home":"4323455"}]},
    {"name":"John Doe","address":[{"home":"Laguna"},{"work":"Ivory"}],"emails":[{"email":"[email protected]"},{"email":"[email protected]"}],"phones":[{"work":"5435435"},{"work":"8678678"}]}
]}

all_data = []
for row in dct['info']:
    all_data.append({
            'name': row['name'],
            'address': ' | '.join('{}: {}'.format(k, v) for a in row['address'] for k, v in a.items()),
            'phones': [v for p in row['phones'] for v in p.values()]
        })

df = pd.DataFrame(all_data).explode('phones')
print(df)

Prints:

       name                               address   phones
0   LYDIANA  home: San Francisco | work: Carolina  1234567
0   LYDIANA  home: San Francisco | work: Carolina  4323455
1  John Doe            home: Laguna | work: Ivory  5435435
1  John Doe            home: Laguna | work: Ivory  8678678