Pages

▼

Monday, July 20, 2015

Turn a {key, value} Python Dictionary into a Pandas DataFrame

Quick solution to a problem I had today. I had a dictionary of {key, values} that I wanted into a dataframe. My solution:

import pandas as pd
pd.DataFrame([[key,value] for key,value in python_dict.iteritems()],columns=["key_col","val_col"])
at

2 comments:

  1. UnknownSeptember 14, 2015 at 2:31 AM

    why do you want to do that when it can be done directly as :
    l = [{k1:v11, k2:v21},
    {k1:v21, k2:v22}, .....]

    pd.DataFreame(l)

    ReplyDelete
    Replies
    1. William CoxSeptember 14, 2015 at 4:51 AM

      That only works if you already have a list. My usecase was when I only had a single dictionary full of keys and values. You have to make it a list first.

      Delete