Adding columns to a dataframe using a dict

Question

I have a dataframe df1

df1 = pd.DataFrame({'c1': [1],
                    'c2': [2],
                    'c3': [3]})

I want to add columns to this dataframe using a dictionary dict

my_dict = {'c4': 4, 'c5': 5}

so I ultimately want df1 to become

df2 = pd.DataFrame({'c1': [1],
                    'c2': [2],
                    'c3': [3],
                    'c4': [4],
                    'c5': [5]})

What I have found on SO is only example where a dictionary is turned into a DataFrame along the rows, e.g. this thread - and not along columns as in the above question.

jezrael · Accepted Answer · 2018-04-04 07:39:37Z

3

Use:

df = df1.join(pd.DataFrame([my_dict]))

Or:

df = pd.concat([df1, pd.DataFrame([my_dict])], axis=1)

print (df)
   c1  c2  c3  c4  c5
0   1   2   3   4   5

answered Apr 4, 2018 at 7:39

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Comments

piRSquared · Accepted Answer · 2018-04-04 07:41:08Z

3

Use pd.DataFrame.assign unpacking the dictionary into keyword arguments.

df1.assign(**my_dict)

   c1  c2  c3  c4  c5
0   1   2   3   4   5

answered Apr 4, 2018 at 7:41

piRSquared

296k68 gold badges509 silver badges654 bronze badges

Collectives™ on Stack Overflow

Adding columns to a dataframe using a dict

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related