import json

with open('log_file.txt', 'r') as f:
    lines = f.readlines()

dings_list = []
macs_list = []
new_line = None
for line in lines[1:]:
    new_line = line[:line.rfind(',')]
    almost_json = new_line.replace('""', '"')
    #print(almost_json)

    new_json = json.loads(almost_json[1:-1])
    ding_id = new_json['ding_id']
    mac = new_json['device_id']
    #print(ding_id)

    dings_list.append(ding_id)
    macs_list.append(mac)

with open('dings.txt', 'w') as f:
    f.write('\n'.join(dings_list))

with open('macs+dings.csv', 'w') as f:
    f.write('mac,ding\n')
    result = zip(macs_list, dings_list)
    for x, y in result:
        f.write(f'{x},{y}\n')