Create a kiwi-compatible DX label CSV from Eibi CSV

gistfile1.txt

"""
Use at your own risk.
"""

import csv

FILENAME = 'sked-a23.csv' # Eibi CSV file

outrow = []

with open(FILENAME, 'r') as inf:
    reader = csv.reader(inf, delimiter=';')
    next(reader) # skip the header line
    for row in reader:
        khz = float(row[0])
        begin, end = row[1].split('-')
        if begin == "0000":
            begin = "0001"
        if end == '2400':
            end = '2359'
        day = row[2]
        itu = row[3]
        ident = row[4]
        lang = row[5]
        target = row[6]
        rem = row[7]
        if not rem:
            notes = f'{itu}. Target: {target}. Lang: {lang}'
        else:
            notes = f'{itu} via {rem}. Target: {target}. Lang: {lang}'
        outrow.append([khz,"QAM",ident,notes,'','','','','','',begin,end])


with open('kiwi.csv', 'w', newline='', encoding='utf-8') as outf:
    writer = csv.writer(outf, delimiter=';', quotechar='"', quoting=csv.QUOTE_MINIMAL)
    for row in outrow:
        writer.writerow(row)

"""
Remember to sort the lines of kiwi.csv as the frequencies
are not perfectly sorted in the original Eibi file
"""