Joining Multiple columns of same dataframe in python

Question

I want to join multiple columns of the same dataframe into a single column. The columns dosent have any labels.

input:

 0  1  2  3  4
 a  b  c  d  e

Result:

0
a,b,c,d,e

please help me with this.

I already tried data1['all'] = data[data.columns[1:]].apply(lambda x: ','.join(x.dropna().astype(str)),axis=1)

but I am not able to get the result as required.

Can yo ube more specific why not working? Why first column is removed? — jezrael
– jezrael, Commented Apr 1, 2020 at 11:13

jezrael · Accepted Answer · 2020-04-01 11:14:41Z

4

Your solution working for me with small modification removed filering out first column and assign to same DataFrame:

data['all'] = data.apply(lambda x: ','.join(x.dropna().astype(str)),axis=1)

If no missing values and no numeric values:

data['all'] = data.apply(','.join,axis=1)

print (data)
   0  1  2  3  4        all
0  a  b  c  d  e  a,b,c,d,e

If need new one column DataFrame:

df = = data.apply(lambda x: ','.join(x.dropna().astype(str)),axis=1).to_frame('new')
#df = data.apply(','.join,axis=1).to_frame('new')
print (df)
         new
0  a,b,c,d,e

answered Apr 1, 2020 at 11:14

jezrael

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

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

3 Comments

Raj Rajeshwari Prasad Over a year ago

Thanks a lot for your help. Although, I am thinking my data is somewhat poor that is why i am having the issue.

Raj Rajeshwari Prasad Over a year ago

I am still not sure. I started working on dummy data and will late import the real data and will see if it is working or not. Thanks a lot for your help and concern. will update asap.

jezrael Over a year ago

@RajRajeshwariPrasad - Super! Let me know how it will work

sammywemmy · Accepted Answer · 2020-04-01 11:19:19Z

0

You could avoid apply altogether and use Pandas' built in string methods ; in this case , string concatenate

#merge the other columns to '0' and specify a delimiter
df['0'].str.cat(df.loc[:,'1':],sep=',')

 0    a,b,c,d,e
Name: 0, dtype: object

answered Apr 1, 2020 at 11:19

sammywemmy

28.9k4 gold badges21 silver badges35 bronze badges

Collectives™ on Stack Overflow

Joining Multiple columns of same dataframe in python

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related