python脚本：excel多列转为一列

import csv
import sys
reads = sys.argv[1]
writers = sys.argv[2]

with open(reads, encoding="utf-8") as f:
    reader = csv.reader(f)
   ### 获取需要处理的表头
    for i in reader:
        biaotou = i[5:]
        print(biaotou)
        break
    li = []
   ### next(reader)
    for i in reader:
        count = 5
        result={}
        for j in biaotou:
            result[j]=i[count].lstrip()
            count = count + 1
        results = str(result).replace(",", "$")
        ddd={'datekey' : i[0], 'lie1' : i[1], 'lie2' : i[2] , 'lie3' : i[3] , 'version' : i[4] , 'result' : results  }
        li.append(ddd)
headers = ['datekey', 'lie1','lie2','lie3','version','result']
with open(writers, 'w', newline='', encoding="utf-8") as d:
    ### 表头传入
    writer = csv.DictWriter(d, headers)
    ### writer.writeheader()

    ### 直接把li写入（多行）
    writer.writerows(li)