根据某列值参照其他列生成订单号

import pandas as pd

# 读取数据表
data = pd.read_csv("data.csv")

# 遍历每一行数据
for index, row in data.iterrows():
    # 获取参照列的值
    ref_value = row['A列']
    
    # 根据参照列的值生成订单号
    if ref_value == 'xxx':
        order_number = 'xxx-001'
    elif ref_value == 'yyy':
        order_number = 'yyy-001'
    else:
        order_number = 'unknown'
    
    # 将订单号写入生成订单号的列
    data.at[index, 'B列'] = order_number

# 保存修改后的数据表
data.to_csv("data_with_order_number.csv", index=False)