How to join multiple text columns in Pandas dataframe

Question

How can i merge/join multiple text columns within a single pandas dataframe without concatenating the columns individually

e.g

d = pd.DataFrame({'A':['one','two','three'],'B':['London','New York','Tokyo'],'C':['UK','USA','Japan'],'D':['Hot','Hot','Cold']})

the output should be

0         one London UK Hot
1      two New York USA Hot
2    three Tokyo Japan Cold
Name: combined, dtype: object

The problem with using concat here is that i need to mention column names individually. — Riya Gupta
– Riya Gupta, Commented Jul 10, 2019 at 11:19

Space Impact · Accepted Answer · 2019-07-10 11:17:59Z

1

Use DataFrame.apply along axis=1 with join:

d.apply(' '.join, axis=1)

0         one London UK Hot
1      two New York USA Hot
2    three Tokyo Japan Cold
dtype: object

answered Jul 10, 2019 at 11:13

Space Impact

13.3k26 silver badges51 bronze badges

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

1 Comment

This is exactly what i was looking for. Thanks a lot :)