Faster way to concatenate two series in a pandas data frame

Question

I have to string type series columns in a pandas data frame and want to concatenate the two of them separated by a ", " to get a result like 'A1, B1'. How can I do this in a quick way without using a for loop?

Lambda · Accepted Answer · 2019-11-05 07:06:44Z

2

make sure column A and B are both string type and then use

df.A + "," + df.B

answered Nov 5, 2019 at 7:06

Lambda

1,3941 gold badge9 silver badges12 bronze badges

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

1 Comment

Aryerez Over a year ago

Or even better. don't pre-"make sure" and do: df.A.astype(str) + "," + df.B.astype(str)

Sai Teja Limbagiri · Accepted Answer · 2019-11-05 07:09:10Z

1

Syntax: Series.str.cat(others=None, sep=None, na_rep=None)

new = data["B1"].copy()

data["A1"]= data["A1"].str.cat(new, sep =", ")

source:https://www.geeksforgeeks.org/python-pandas-series-str-cat-to-concatenate-string/

or using dataframe

df["A1"]=df["A1"]+","+df["B1"]

answered Nov 5, 2019 at 7:09

Sai Teja Limbagiri

332 silver badges6 bronze badges

Collectives™ on Stack Overflow

Faster way to concatenate two series in a pandas data frame

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related