How to join two Series type object and make another column in Data Frame

Question

I have a Data Frame Transformer contains various columns, Among are Name and Sampling_Point i want to filter and join them to form another column Sample_gas. i.e,

Now i had filtered out df.NAME and df.SAMPLING_POINT but now want to join it and assigned it to some other column name called Sample_gas. I had written the code:

df['SAMPLE_GAS']=pd.concat([df.NAME,df.SAMPLING_POINT],axis=1)

but it give me error like:

Wrong number of items passed 2, placement implies 1

Please suggest the changes. The output should look like:

Please provide a **[mcve]**. This means no images/links, just text. See also [How to make good reproducible pandas examples](https://stackoverflow.com/questions/20109391/how-to-make-good-reproducible-pandas-examples). — jpp, Sep 26 '18 at 18:21

score 2 · Accepted Answer · answered Sep 26 '18 at 18:26

2

df['SAMPLE_GAS'] = df['NAME'].str.cat(df['SAMPLING_POINT'], sep=' ')

Or,

df['SAMPLE_GAS'] = [x + ' ' + y for x, y in zip(df['NAME'], df['SAMPLING_POINT'])]

For performance.

answered Sep 26 '18 at 18:26

cs95

379,657
97
704
746

Thank you so much for help. – MD Rijwan Oct 11 '18 at 17:46

score 1 · Answer 2 · answered Sep 26 '18 at 18:22

1

According to your output, you need to simply add your strings,

df['SAMPLE_GAS'] = df['NAME'] +' '+ df['SAMPLING_POINT']

answered Sep 26 '18 at 18:22

Raunaq Jain

917
7
13

How to join two Series type object and make another column in Data Frame

2 Answers2