Python pandas read_csv每两列合并一次，并将它们作为数据帧读取

import pandas as pd

def merge_columns(df, col1, col2, new_col_name):
    df[new_col_name] = df[col1].astype(str) + df[col2].astype(str)
    return df

# 读取CSV文件
df = pd.read_csv('your_file.csv')

# 获取列名列表
columns = df.columns.tolist()

# 初始化新的数据帧
new_df = pd.DataFrame()

# 遍历列名列表，每两列合并一次
for i in range(0, len(columns), 2):
    if i + 1 < len(columns):
        new_col_name = f"{columns[i]}_{columns[i+1]}"
        df = merge_columns(df, columns[i], columns[i+1], new_col_name)
        new_df[new_col_name] = df[new_col_name]
    else:
        # 如果列数为奇数，最后一个列单独处理
        new_df[columns[i]] = df[columns[i]]

# 查看新的数据帧
print(new_df)