27 lines
674 B
Python
27 lines
674 B
Python
import csv
|
|
import json
|
|
import codecs
|
|
from certificate import Certificate
|
|
from io import StringIO
|
|
|
|
|
|
def convert(csv_string):
|
|
csv_stuff = StringIO(csv_string)
|
|
csv_reader = csv.reader(csv_stuff, delimiter=";")
|
|
data = {}
|
|
for rows in csv_reader:
|
|
if rows[0]:
|
|
cur_row = rows[0].strip()
|
|
if cur_row.find("Svar") != -1:
|
|
cur_row = "questions"
|
|
if cur_row not in data:
|
|
data[cur_row] = []
|
|
if rows[1] != '':
|
|
data[cur_row].append(f'text:{rows[1].strip()}')
|
|
return Certificate.from_dict(data)
|
|
|
|
|
|
if __name__ == "__main__":
|
|
cert = convert("opg1_dansk.csv")
|
|
print(cert)
|