You have two text columns in pandas and you want to combine them into a single column.
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)