code help to convert log file to csv format

[bmunagala]

Need to convert a logfile that will have some information into a csv format.

Sample Data:

Output:
 
Info type: PERSON_NAME; Count: 25
Info type: LOCATION; Count: 25
Info type: CREDIT_CARD_NUMBER; Count: 2
Info type: EMAIL_ADDRESS; Count: 150
Info type: US_VEHICLE_IDENTIFICATION_NUMBER; Count: 20
Info type: MALE_NAME; Count: 13
Info type: LAST_NAME; Count: 85
Info type: DOMAIN_NAME; Count: 150
Info type: SSN; Count: 1000

I need this to be converted in to csv format. I am trying with the below logic but

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

import os import sys import csv     ip_file=r"C:\Users\bmunagala\Desktop\Output.log" op_file=ip_file.split(".")   print("Opening " + ip_file)   f0 = open(ip_file,"r") lstInput = [] for oLine in f0:     try:         lstLine = oLine.replace("\n","").split("Info type:")     except Exception as e:         print(e)         pass     lstInput.append(lstLine)       f0.close()   fw = open(op_file[0] + ".csv", "w") for oLine in lstInput:     szWriteLine = ",".join(oLine)     fw.write(szWriteLine + "\n") fw.close()

But output is like this

Output:
, PERSON_NAME; Count: 25
, LOCATION; Count: 25
, CREDIT_CARD_NUMBER; Count: 2
, EMAIL_ADDRESS; Count: 150
, US_VEHICLE_IDENTIFICATION_NUMBER; Count: 20
, MALE_NAME; Count: 13
, LAST_NAME; Count: 85
, DOMAIN_NAME; Count: 150
, SSN; Count: 1000

[snippsat]

Example,and i didn't see the point with the starting ,.

1 2 3 4

with open('log1.txt') as f,open('out.csv', 'w') as f_out:     for line in f:         line = line.strip().split('Info type: ')[1]         f_out.write(f'{line}\n')

Output:
PERSON_NAME; Count: 25
LOCATION; Count: 25
CREDIT_CARD_NUMBER; Count: 2
EMAIL_ADDRESS; Count: 150
US_VEHICLE_IDENTIFICATION_NUMBER; Count: 20
MALE_NAME; Count: 13
LAST_NAME; Count: 85
DOMAIN_NAME; Count: 150
SSN; Count: 1000

[bmunagala]

Hi I am trying to run with the above code but getting the below error

TypeError: expected str, bytes or os.PathLike object, not _io.TextIOWrapper

[snippsat]

What's your input and what version of Python do you use?
In my code i copy this from your first post,and save(utf-8) as log1.txt.

Output:
Info type: PERSON_NAME; Count: 25
Info type: LOCATION; Count: 25
Info type: CREDIT_CARD_NUMBER; Count: 2
Info type: EMAIL_ADDRESS; Count: 150
Info type: US_VEHICLE_IDENTIFICATION_NUMBER; Count: 20
Info type: MALE_NAME; Count: 13
Info type: LAST_NAME; Count: 85
Info type: DOMAIN_NAME; Count: 150
Info type: SSN; Count: 1000

Then running code in my post gives this in out.csv:

Output:
PERSON_NAME; Count: 25
LOCATION; Count: 25
CREDIT_CARD_NUMBER; Count: 2
EMAIL_ADDRESS; Count: 150
US_VEHICLE_IDENTIFICATION_NUMBER; Count: 20
MALE_NAME; Count: 13
LAST_NAME; Count: 85
DOMAIN_NAME; Count: 150
SSN; Count: 1000