import pandas as pd

import os

if __name__ == '__main__':

    Folder_Path = 'c:\checklog'

    os.chdir(Folder_Path)

    file_list = os.listdir()

    writer = pd.ExcelWriter('c:\shuju\out.xlsx')

    list = []

    for item in file_list:

        file_path = os.path.join(Folder_Path, item)

        df = pd.read_excel(file_path, sheet_name=0)

        for index, row in df.iterrows():

            if isinstance(row['核查说明'], str):

                list.append(row)

    df2 = pd.DataFrame(list)

    df2.to_excel(writer, sheet_name='sheet1')

    writer.save()