Create new dictionary column in Pandas dataframe of all the other columns combined with their headers

Question

Given a dataframe with multiple columns, whats the most pythonic way to combine them with their column headers into a new dataframe column. For example, given red, blue, and green, how do I add colors as a column.

   red  blue  green colors
0    1     2     dd      {'red':1, 'blue': 2, 'green': 'dd'}    
1    2     3     ee      {'red':2, 'blue': 3, 'green': 'ee'} 
2    3     4     ff      {'red':2, 'blue': 4, 'green': 'ff'}

akuiper · Accepted Answer · 2016-11-02 21:38:23Z

3

You can use to_dict() to create a list of dictionaries and then assign it back to df as a column

df['colors'] = df.to_dict("records")

answered Nov 2, 2016 at 21:38

akuiper

216k33 gold badges363 silver badges380 bronze badges

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

Collectives™ on Stack Overflow

Create new dictionary column in Pandas dataframe of all the other columns combined with their headers

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related