##批量##
import os
import pandas as pd
#1，遍歷目錄下的文件
path = r"F:\項目\國美新\log\4-26/"
file_list = os.listdir(path)
#2，設置需要匹配的關鍵詞列表
kws = ["bad", "faild", "FAULTY", "error"]
#定義一個字典
get_result = []
#3，循環打開文件
for lines in file_list:
    with open(os.path.join(path+lines), 'r', encoding='utf-8', errors='ignore') as f:
#4，循環逐行讀取內容
        for i in f.readlines():
#5，比對文件中是否匹配自定義列表的關鍵字，出現則記錄
            if (any(kw in i for kw in kws)):
                get_result.append([lines, i])
#6，記錄日志到excel
name = ['host', 'txt']
contents = pd.DataFrame(columns=name, data=get_result)
contents.to_csv('log.csv', encoding='utf-8')