#!/usr/bin/python3
import os
import csv
import pandas


def extract_lines_from_files(filename, dirpath):
    filename  = os.path.join(dirpath, filename)

    search_keywords = ['Apple','Pear','Cherry']                # 3 Columns

    with open(filename, 'r',errors='ignore') as Text_file:

         for line in Text_file:
            found = False
            for word in search_keywords:
                if word in line:
                    found = True
            if found:
                lines = []
                lines.append(line)

                with open("a.csv",'a') as csv_file:
                    writer = csv.writer(csv_file)
                    writer.writerow([line])

#main
directory = 'C:/Users/home/Desktop/files/'
for root, dirs, files in os.walk(directory):
    for f in files:
        extract_lines_from_files(f, directory)
#done

Apple  1     |   Pear  1   |   Cherry  1

      Apple   2    |   Pear  2    |  Cherry  2