How to pandas df.assign() with variable names?

Question

I want to add a new column in a dataframe with values from some other dataframe. My new column name is a variable and I cannot hardcode it.

new_column = "my_new_column_name" 
df = df.assign(new_column=other_df['Column1'].values)

The problem is that, I am getting a new column named new_column. What I expect is a column named my_new_column_name

Can anyone please suggest a solution for this.

@Chris assign is useful in a longer chain of multiple operations — Paul H
– Paul H, Commented Sep 16, 2019 at 5:43

Chris · Accepted Answer · 2019-09-16 05:44:30Z

22

You can make a dict and unpack:

Given df:

print(df)
   col1  col2
0     1    10
1     2    20
2     3    30

new_column = "my_new_column_name" 
df = df.assign(**{new_column: df['col1'].values})
print(df)

Output:

   col1  col2  my_new_column_name
0     1    10                   1
1     2    20                   2
2     3    30                   3

answered Sep 16, 2019 at 5:44

Chris

29.8k3 gold badges34 silver badges56 bronze badges

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

1 Comment

Rishabh Bhatt Over a year ago

Thanks for the answer. Does this have any performance repercussions against df[new_column] = other_df['Column1'].values1 ?

Collectives™ on Stack Overflow

How to pandas df.assign() with variable names?

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