Pandas，应用字符串联接问题

import pandas as pd

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

# 使用 str.cat 方法进行字符串联接
df['full_name'] = df['first_name'].str.cat(df['last_name'], sep=' ')

print(df)

  first_name last_name    full_name
0       John       Doe     John Doe
1      Alice     Smith   Alice Smith
2        Bob   Johnson  Bob Johnson

# 示例 DataFrame 包含 NaN 值
data = {
    'first_name': ['John', None, 'Bob'],
    'last_name': ['Doe', 'Smith', 'Johnson']
}
df = pd.DataFrame(data)

# 使用 fillna 方法填充 NaN 值
df['first_name'] = df['first_name'].fillna('')
df['full_name'] = df['first_name'].str.cat(df['last_name'], sep=' ')

print(df)

  first_name last_name    full_name
0       John       Doe     John Doe
1             Smith            
2        Bob   Johnson  Bob Johnson

df['full_name'] = df['first_name'].str.cat(df['last_name'], sep=' ', na_action='ignore')

print(df)

  first_name last_name    full_name
0       John       Doe     John Doe
1      None     Smith            
2        Bob   Johnson  Bob Johnson