Pandas-如何拆分和合并名称相似的列？

import pandas as pd

# 创建一个示例 DataFrame
data = {
    'name_first': ['Alice', 'Bob'],
    'name_last': ['Smith', 'Johnson']
}
df = pd.DataFrame(data)

# 拆分列
first_names = df['name_first']
last_names = df['name_last']

print("First Names:")
print(first_names)
print("\nLast Names:")
print(last_names)

import pandas as pd

# 创建两个示例 DataFrame
data1 = {
    'name_first': ['Alice', 'Bob'],
    'age': [25, 30]
}
df1 = pd.DataFrame(data1)

data2 = {
    'name_last': ['Smith', 'Johnson'],
    'city': ['New York', 'Los Angeles']
}
df2 = pd.DataFrame(data2)

# 合并 DataFrame
merged_df = pd.concat([df1, df2], axis=1)

print("Merged DataFrame:")
print(merged_df)

merged_df = pd.concat([df1, df2], axis=1, suffixes=('_left', '_right'))

df2.rename(columns={'name_last': 'last_name'}, inplace=True)
merged_df = pd.concat([df1, df2], axis=1)