Pandas - 追加到第一列

Question

我正在尝试向 campaign-device.csv 添加 2 个附加列( custom_conversion_id 和 custom_conversion_name )使用 Pandas ，但似乎没有选项将这两列附加到 .csv 的开头.有小费吗？

with open('output/campaign-device.csv', 'w', newline='') as outfile:
    w = csv.DictWriter(outfile,fieldnames=items[0].keys())
    w.writeheader()
    w.writerows(items)

csv_input = pandas.read_csv('output/campaign-device.csv')
csv_input['custom_conversion_id'] = '11197251455862'
csv_input['custom_conversion_name'] = 'total-device'
csv_input.to_csv('output/campaign-device.csv', index=0)

Answer 1

您不能将列附加到开头，但可以在添加列后重新排列列顺序

 with open('output/campaign-device.csv', 'w', newline='') as outfile:
     w = csv.DictWriter(outfile,fieldnames=items[0].keys())
     w.writeheader()
     w.writerows(items)
    
 csv_input = pandas.read_csv('output/campaign-device.csv')
    
 cols = [x for x in csv_input.columns]
 # or cols = csv_input.columns.tolist()
    
 csv_input['custom_conversion_id'] = '11197251455862'
 csv_input['custom_conversion_name'] = 'total-device'
    
 csv_input = csv_input[['custom_conversion_id', 'custom_conversion_name', *cols]]
    
 csv_input.to_csv('output/campaign-device.csv', index=0)