拆分pandas中的联合字符串

import pandas as pd

# 创建一个包含联合字符串的DataFrame
data = {'name': ['John Smith', 'Jane Doe', 'Mike Johnson'],
        'age': [25, 30, 35],
        'location': ['New York', 'London', 'Paris']}
df = pd.DataFrame(data)

# 拆分name列中的联合字符串
df[['first_name', 'last_name']] = df['name'].str.split(' ', expand=True)

# 打印拆分后的DataFrame
print(df)

           name  age  location first_name last_name
0   John Smith   25  New York       John     Smith
1     Jane Doe   30    London       Jane       Doe
2  Mike Johnson   35     Paris       Mike   Johnson