read list of dict using pandas code example

Example: python list of dict to dataframe

# Supposing d is your list of dicts, simply
df = pd.DataFrame(d)
# Note: this does not work with nested data