import pandas as pd
pets = [{'species': 'cat', 'name': 'Murka', 'age': 3},
{'species': 'dog', 'name': 'Barbos', 'weight': 10},
{'species': 'cat', 'weight': 6}]
df = pd.io.json.json_normalize(pets)
print (df)
aW1wb3J0IHBhbmRhcyBhcyBwZAoKcGV0cyA9IFt7J3NwZWNpZXMnOiAnY2F0JywgJ25hbWUnOiAnTXVya2EnLCAnYWdlJzogM30sIAoJCXsnc3BlY2llcyc6ICdkb2cnLCAnbmFtZSc6ICdCYXJib3MnLCAnd2VpZ2h0JzogMTB9LCAKCQl7J3NwZWNpZXMnOiAnY2F0JywgJ3dlaWdodCc6IDZ9XQoKZGYgPSBwZC5pby5qc29uLmpzb25fbm9ybWFsaXplKHBldHMpCgpwcmludCAoZGYp