Argthtjtr

my input file

INCIDENT 677700 password reset

INCIDENT 677742 C: drive full

INCIDENT 500901 mouse not working

INCIDENT 500942 unable to connect oracle box

INCIDENT 500949 high cpu utilization

INCIDENT 600901 sql server clustering failed

INCIDENT 490203 Low disk space issue

INCIDENT 10I891 Lotus Notes client failed

INCIDENT 489011 Low disk space issue

INCIDENT 89G901 SSIS Load failed



words =["password","drive full","disk space","SSIS","sql server","cpu utilization","oracle","Lotus Notes","mouse"]

I would like assign category in my output file should be: and how to add future words.

Password,INCIDENT 677700 password reset

drive full,INCIDENT 677742 C: drive full

mouse,INCIDENT 500901 mouse not working

Oracle,500942 unable to connect oracle box

cpu utilization,INCIDENT 500949 high cpu utilization

sql server,INCIDENT 600901 sql server clustering failed

disk space, INCIDENT 490203 Low disk space issue

Lotus Notes,INCIDENT 10I891 Lotus Notes client failed

disk space,INCIDENT 489011 Low disk space issue

SSIS,INCIDENT 89G901 SSIS Load failed

Just iterate over each line and each word, and if the word exists in the line, then write the new line word,line to the output file.

Some assumptions:

• You want to do caseless matching e.g. Disk space and disk space would match.


• Each entry in the log file only has one matching word. If there are more, then the line would get written twice with each separate entry.

Demo:

words = [

    "password",

    "drive full",

    "disk space",

    "SSIS",

    "sql server",

    "cpu utilization",

    "oracle",

    "Lotus Notes",

    "mouse",

]



with open("input.txt") as file, open("output.txt", "w") as out:

    for line in file:

        for word in words:

            # Do lowercase matching

            if word.lower() in line.lower():

                out.write("%s,%s" % (word, line))

output.txt:

password,INCIDENT 677700 password reset

drive full,INCIDENT 677742 C: drive full

mouse,INCIDENT 500901 mouse not working

oracle,INCIDENT 500942 unable to connect oracle box

cpu utilization,INCIDENT 500949 high cpu utilization

sql server,INCIDENT 600901 sql server clustering failed

disk space,INCIDENT 490203 Low disk space issue

Lotus Notes,INCIDENT 10I891 Lotus Notes client failed

disk space,INCIDENT 489011 Low disk space issue

SSIS,INCIDENT 89G901 SSIS Load failed

You can also condense the two nested loops with itertools.product():

from itertools import product



with open("input.txt") as file, open("output.txt", "w") as out:

    for line, word in product(file, words):

        if word.lower() in line.lower():

            out.write("%s,%s" % (word, line))