How to string-concatenate multiple string columns in pandas?

Question

I want to concatenate two rows in a DataFrame into one row. My current code:

import pandas as pd

df = pd.DataFrame(columns = ['string1', 'string2'])
df.loc[len(df), :] = ['Hello', 'This is Sam']
df.loc[len(df), :] = ['how are you?', 'from Canada']

#create the next row: ['Hello how are you?', 'This is Sam from Canada']

How to do it?

You can test the code here.

Hi, please post some example data and what the result should look like — entropy
– entropy, Commented Mar 15, 2019 at 13:30
You asked "How to concatenate rows..." but you really meant "How to string-concatenate multiple text columns...?" Since you want to string-concatenate string1 column between rows 1 and 2, e.g. 'This is Sam' + 'from Canada'. That's concatenating columns not rows, and it's string-concatenation (multiple strings into one string, not the usual concatenating multiple rows into one dataframe containing multiple rows). — smci
– smci, Commented Jun 17, 2019 at 20:49

cs95 · Accepted Answer · 2019-03-15 13:31:16Z

4

Use agg with append:

df = df.append(df.agg(' '.join), ignore_index=True)
df

              string1                  string2
0               Hello              This is Sam
1        how are you?              from Canada
2  Hello how are you?  This is Sam from Canada

answered Mar 15, 2019 at 13:31

cs95

406k106 gold badges744 silver badges797 bronze badges

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

Collectives™ on Stack Overflow

How to string-concatenate multiple string columns in pandas?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related