bswn.py

#  bswn.py -- Munge results from BSWN events to a usable format

import csv

with open('data.txt','r') as input_file:
    lines = input_file.read().split('\n')

    # Remove the first 8 lines of tile, header, etc.
    lines = lines[8:]

    for line in lines:
        # Strip out the class separator lines 
        if line.startswith('          '):
            lines.remove(line)

with open('output.csv', 'w') as output_file:
    fieldnames = ['name', 'class']
    writer = csv.DictWriter(output_file, fieldnames=fieldnames)

    for i in range(len(lines)):
        writer.writerow({'name': lines[i][:21],
                        'class': lines[i][22:32]})