Join Text of Two Columns in pandas DataFrame in Python (Example Code)
This article explains how to concatenate text in variables of a pandas DataFrame in Python.
Creation of Example Data
import pandas as pd # Import pandas |
import pandas as pd # Import pandas
my_df = pd.DataFrame({'A':['xxx', 'yyy', 'zzz'], # Construct DataFrame in Python 'B':['hey', 'hi', 'yoyo']}) print(my_df) # Display DataFrame in console # A B # 0 xxx hey # 1 yyy hi # 2 zzz yoyo |
my_df = pd.DataFrame({'A':['xxx', 'yyy', 'zzz'], # Construct DataFrame in Python 'B':['hey', 'hi', 'yoyo']}) print(my_df) # Display DataFrame in console # A B # 0 xxx hey # 1 yyy hi # 2 zzz yoyo
Example: Merge Multiple Text Columns of pandas DataFrame
my_df['C'] = my_df['A'] + my_df['B'] # Combine two variables print(my_df) # Display updated DataFrame # A B C # 0 xxx hey xxxhey # 1 yyy hi yyyhi # 2 zzz yoyo zzzyoyo |
my_df['C'] = my_df['A'] + my_df['B'] # Combine two variables print(my_df) # Display updated DataFrame # A B C # 0 xxx hey xxxhey # 1 yyy hi yyyhi # 2 zzz yoyo zzzyoyo