Adding Multiple Columns

Question

How to add multiple columns from one dataframe to another dataframe i laready figured out to add a single column but not getting multiple columns. I am a newbie

df

new['Symbol']= pd.Series(df['Symbol'])
dfnew['Symbol']['Desc']= pd.Series(df['Symbol']['Desc'])

dfnew['Symbol']= pd.Series(df['Symbol']) # worked dfnew['Symbol']['Desc']= pd.Series(df['Symbol']['Desc']) # not working — Harry
– Harry, Commented Jun 14, 2019 at 8:13

anky · Accepted Answer · 2019-06-14 08:14:25Z

1

Use:

dfnew['Symbol'],dfnew['Desc']= df['Symbol'],df['Desc']

Or df.assign():

dfnew=dfnew.assign(Symbol=df.Symbol,Desc=df.Desc)

If needed initialize dfnew first as dfnew=pd.DataFrame()

answered Jun 14, 2019 at 8:14

anky

75.3k11 gold badges46 silver badges76 bronze badges

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

4 Comments

Harry Over a year ago

dfnew=dfnew.assign(Symbol=df.Symbol,Desc=df.Desc this worked for me thank you so much.

Harry Over a year ago

can you help with creating a file if exists add with number for Ex:SMA_Outliers.csv SMA_Outliers(1).csv ......

anky Over a year ago

@Hareesha that is a separate question which will require separate libraries, not pandas. :) I suggest you post a fresh question.

anky Over a year ago

@Hareesha may be you can check: stackoverflow.com/questions/17984809/…

Collectives™ on Stack Overflow

Adding Multiple Columns

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related