Convert list of dictionaries to Dataframe

I have a list of dictionaries like this:

    [{'points': 50, 'time': '5:00', 'year': 2010}, 
    {'points': 25, 'time': '6:00', 'month': "february"}, 
    {'points':90, 'time': '9:00', 'month': 'january'}, 
    {'points_h1':20, 'month': 'june'}]

and I want to turn this into a pandas DataFrame like this:

          month  points  points_h1  time  year
    0       NaN      50        NaN  5:00  2010
    1  february      25        NaN  6:00   NaN
    2   january      90        NaN  9:00   NaN
    3      june     NaN         20   NaN   NaN

Note: Order of the columns does not matter.

Ultimately, the goal is to write this to a text file and this seems like the best solution I could find. How can I turn the list of dictionaries into a pandas DataFrame as shown above?

Supposing d is your list of dicts, simply:



Back to homepage or read more recommendations: