Python change multiple dictionaries to dataframe

Question

I am using jupyter notebook and getting data using API.

I have a list of names.

names = ['a','b','c','d']
for name in names:
    df=library.function(name)
    print(df)

Then I get multiple dictionaries.

{'name':'a', 'level':2, 'quality': 12}
{'name':'b', 'level':3, 'quality': 14}
{'name':'c', 'level':6, 'quality': 13}
{'name':'d', 'level':2, 'quality': 11}

The dictionaries are not defined as something like dict_1 ~ dict_4 or these are not a list of multiple dictionaries, so I have no idea what to do :( Is there any way that I can change/merge these multiple dictionaries to a pandas dataframe?

Thanks in advance!

Answer 1

you can add a list and it will create for you automatic data frame

import pandas as pd 
list_t =[
        {'name':'a', 'level':2, 'quality': 12},
        {'name':'b', 'level':3, 'quality': 14},
        {'name':'c', 'level':6, 'quality': 13},
        {'name':'d', 'level':2, 'quality': 11}
         ]



pd.DataFrame(list_t)


#output

    name    level   quality
0   a        2        12
1   b        3        14
2   c        6        13
3   d        2        11