Dictionary to Pandas Dataframe Python

Question

I have two python dictionaries.

Sample:

{
'hello' : 10
'phone' : 12
'sky' : 13
}

{
'hello' : 8
'phone' :15
'red' :4
}

This is the dictionary of counts of words in books 'book1' and 'book2' respectively.

How can I generate a pd dataframe, which looks like this:

   hello phone  sky  red
book1 10    12     13   NaN
book2 8     15     NaN   4

I have tried :

pd.DataFrame([words,counts])

It generated:

    hello phone  sky  red
0     10    12     13   NaN
1      8    15     NaN   4

How can I genrate a required output?

Hi @WeNYoBen, I didn't get you. Sorry. Can you please elaborate? — ramu suri
– ramu suri, Commented Oct 12, 2019 at 1:21
can u add the rest of the codes related to pd.DataFrame([words,counts]) — Eshaka
– Eshaka, Commented Oct 12, 2019 at 1:27

M_S_N · Accepted Answer · 2019-10-12 02:30:50Z

1

You need this:


pd.DataFrame([words, counts], index=['books1', 'books2'])

Output:

      hello phone  red  sky
books1  10   12    NaN  13.0
books2  8    15    4.0  NaN

edited Oct 12, 2019 at 2:30

answered Oct 12, 2019 at 2:09

M_S_N

2,8061 gold badge19 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shishir Naresh · Accepted Answer · 2019-10-12 03:20:06Z

1

try the below code,hope this helps

dict1 = {
'hello' : 10,
'phone' : 12,
'sky' : 13
}

dict2 = {
'hello' : 8,
'phone' :15,
'red' :4
}


import pandas as pd
df = pd.DataFrame([dict1,dict2], index=['book1','book2'])
print(df)

Ouput will be:

       hello  phone   sky  red
book1     10     12  13.0  NaN
book2      8     15   NaN  4.0

answered Oct 12, 2019 at 3:20

Shishir Naresh

7634 silver badges10 bronze badges

Comments

user11553043 · Accepted Answer · 2019-10-12 01:24:54Z

0

Use df.set_index([‘book1’, ‘book2’]). See the docs here: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.set_index.html

answered Oct 12, 2019 at 1:24

user11553043

Comments

Dani Mesejo · Accepted Answer · 2019-10-12 03:04:17Z

0

Assuming you have a list of dictionaries, you could do something like this:

import pandas as pd
from itertools import chain

data = [{
    'hello': 10,
    'phone': 12,
    'sky': 13,
},
    {
        'hello': 8,
        'phone': 15,
        'red': 4
    }]

df = pd.DataFrame(data=data, columns=set(chain.from_iterable(d.keys() for d in data)))
print(df)

Output

    sky  phone  hello  red
0  13.0     12     10  NaN
1   NaN     15      8  4.0

answered Oct 12, 2019 at 3:04

Dani Mesejo

62.2k6 gold badges56 silver badges86 bronze badges

Collectives™ on Stack Overflow

Dictionary to Pandas Dataframe Python

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related