如何在设置条件后从csv文件中获取头文件

Question

我正在寻找一种方法，以获得列名称的文件后，把条件行的CSV

我得到了想要的输出，但是没有得到列名，我必须在excel中得到带有列名或行标题的输出

include_cols = ['TICKETID', 'TICKETNAME', 'TICKETSENTDATE', 
                'TICKETREQUESTER', 'TICKETCATEGORYNAME',
                'TICKETLOCATION', 'SERVICEGROUPNAME', 
                'SERVICETYPENAME', 'SERVICESTATENAME', 'REACTIONTIME', 
                'SOLUTIONTIME']

search_for = ['Resolved','Closed','Rejected']

with open(files3, "rt", encoding='utf-8') as f:
    reader = csv.DictReader(f, delimiter=';')
    for row in reader:
        if '+' in row['SOLUTIONTIME'] and row['SERVICESTATENAME'] not in search_for:
            content = list(row[i] for i in include_cols)
            print(content)

Answer 1

为什么不使用https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_csv.html将csv加载到熊猫数据帧中呢？这将使检索列的名称更加容易