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)