Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ID:- 512
- NAME:- GOOSE
- PROJECT NAME:- Random
- REPORT ID:- 30321
- REPORT NAME:- ANIMAL
- KEYWORDS:- ['"help,goose,Grease,GB"']
- ID:- 566
- NAME:- MOOSE
- PROJECT NAME:- Random
- REPORT ID:- 30213
- REPORT NAME:- ANIMAL
- KEYWORDS:- ['"Moose, boar, hansel"']
- ID, NAME, PROJECT NAME, REPORT ID, REPORT NAME, KEYWORDS
- with open('test.txt', 'r') as in_file:
- stripped = (line.strip() for line in in_file)
- lines = (line for line in stripped if line)
- grouped = itertools.izip(*[lines] * 6)
- with open('extracted.csv', 'w') as out_file:
- writer = csv.writer(out_file)
- writer.writerow((‘ID’, ‘NAME’, ‘PROJECT NAME’, ‘REPORT ID’, ‘REPORT NAME’, ‘KEYWORDS’))
- writer.writerows(grouped)
- import re
- # `text` is your input text
- data = {}
- keys = ['ID', 'NAME', 'PROJECT NAME', 'REPORT ID', 'REPORT NAME', 'KEYWORDS']
- for k in keys:
- data[k] = re.findall(r'%s:- (.*)' % k, text)
- import csv
- csv_file = 'out.csv'
- with open(csv_file, 'w') as csvfile:
- writer = csv.DictWriter(csvfile, fieldnames=keys)
- writer.writeheader()
- for x in data:
- writer.writerow(x)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement