fork download
  1. import pandas as pd
  2.  
  3. pets = [{'species': 'cat', 'name': 'Murka', 'age': 3},
  4. {'species': 'dog', 'name': 'Barbos', 'weight': 10},
  5. {'species': 'cat', 'weight': 6}]
  6.  
  7. df = pd.io.json.json_normalize(pets)
  8.  
  9. print (df)
Success #stdin #stdout 0.5s 60880KB
stdin
Standard input is empty
stdout
   age    name species  weight
0  3.0   Murka     cat     NaN
1  NaN  Barbos     dog    10.0
2  NaN     NaN     cat     6.0