Combine two columns of text in Pandas DataFrame

Example:

# Importing pandas package
import pandas as pd

# Creating a dictionary of student marks
d = {
    "Name":['Hari','Mohan','Neeti','Shaily'],
    "Age":[25,36,26,21],
    "Gender":['Male','Male','Female','Female'],
    "Profession":['Doctor','Teacher','Singer','Student'],
    "Title":['Mr','Mr','Ms','Ms']
}

# Now, Create DataFrame
df = pd.DataFrame(d)

# Printing the original DataFrame
print("Original DataFrame:\n")
print(df,"\n\n")

# Now, Combine the values of Name and 
# title using str.cat() function
df['Full_Name'] = df['Title'].str.cat(df['Name'], sep =".")

# Now, Printing the modified DataFrame
print("Combined column:\n")
print(df)

Output:

Original DataFrame:

     Name  Age  Gender Profession Title
0    Hari   25    Male     Doctor    Mr
1   Mohan   36    Male    Teacher    Mr
2   Neeti   26  Female     Singer    Ms
3  Shaily   21  Female    Student    Ms 


Combined column:

     Name  Age  Gender Profession Title  Full_Name
0    Hari   25    Male     Doctor    Mr    Mr.Hari
1   Mohan   36    Male    Teacher    Mr   Mr.Mohan
2   Neeti   26  Female     Singer    Ms   Ms.Neeti
3  Shaily   21  Female    Student    Ms  Ms.Shaily