Converting pandas data frame to dictionary in python

Question

My pandas dataframe (df):

Pattern      Support

Bread         4
Milk          4
Bread,Milk    4

My code:

x = df.set_index('Pattern').to_dict()
print(x)

Output of my code:

{'Support':{'MILK': 4,'BREAD':4, 'BREAD,MILK':4}}

Expected Output:

{'MILK': 4,'BREAD':4, 'BREAD,MILK':4}

I do not want the name of the second column 'Support' to be the main key, just want to get the elements and the count as in the expected output. Is there any pythonic (python 3.5) way?

Hun · Accepted Answer · 2016-04-03 06:33:18Z

5

Packed too much in one line, but it will give you what you want.

list(df.set_index('Pattern').to_dict().values()).pop()

answered Apr 3, 2016 at 6:33

Hun

3,9972 gold badges17 silver badges16 bronze badges

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

1 Comment

Karan Bari Over a year ago

It worked!! can you explain what does pop() function do here? @Hun

Collectives™ on Stack Overflow

Converting pandas data frame to dictionary in python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related