数据标注员工作笔记：将文件内数据输出为cxcel

import os
import csv

path=r"C:\huangyaoqi_vendor\桌面\新建文件夹"
filelist=os.listdir(path)
result=[]
for dir in filelist:
    realpath=path+'\\'+dir
    if(os.path.isdir(realpath)):
        filelist2=os.listdir(realpath)
        tempresult=[]
        tempresult.append(dir)
        for eachpic in filelist2:
            tempresult.append(eachpic.split("_")[2])
        result.append(tempresult)   
with open("result.csv",'w',encoding="utf-8",newline="") as csv1:
    csvwriter = csv.writer(csv1,dialect = ("excel"))
    for row in result:
        csvwriter.writerow(row)