How to combine two text columns in pandas

Problem –

You have two text columns in pandas and you want to combine them into a single column.

Solution –

import pandas as pd
url = "https://raw.githubusercontent.com/bprasad26/lwd/master/data/clothing_store_sales.csv"
df = pd.read_csv(url)
df.head()

Let’s say that you want to add the gender and marital status columns into one column. Since both the columns are string, you can concatenate them directly.

df['Gender'] + '_' + df['Marital Status']

To make it more readable, I have added an white space between them.

Now, suppose one column is string but the other one is a integer. Now how do you add that?

To add these columns you have to first convert the integer column into a string using astype method in pandas.

let’s add the Age and gender column.

df['Gender'] + ' ' + df['Age'].astype(str)

If you want to add more than two columns at once, then use the same method that we used so far.

df['Gender'] + ' ' + df['Marital Status'] + ' ' + df['Age'].astype(str)

Related Posts –

1 . Pandas – astype() – Change column data type in pandas