从pandas dataframe列中提取多个单词到同一列

import pandas as pd

# 创建示例DataFrame
data = {
    'First_Name': ['John', 'Jane', 'Alice'],
    'Last_Name': ['Doe', 'Smith', 'Johnson']
}
df = pd.DataFrame(data)

# 合并名字和姓氏
df['Full_Name'] = df['First_Name'] + ' ' + df['Last_Name']

print(df)

  First_Name Last_Name   Full_Name
0       John       Doe     John Doe
1       Jane     Smith   Jane Smith
2      Alice   Johnson  Alice Johnson

df['Full_Name'] = df['First_Name'].fillna('') + ' ' + df['Last_Name'].fillna('')

df['Full_Name'] = df['First_Name'].str.strip() + ' ' + df['Last_Name'].str.strip()
df['Full_Name'] = df['Full_Name'].str.replace('[^a-zA-Z\s]', '', regex=True)