#There is a file with logs, get list of ding ids that appear in this file and write to txt file, #get list mac,ding_id and write into csv file import json, csv with open('delete_many_one_05_08_2019.csv', 'r') as csv_file, open('output.csv', 'w') as save_file: file = csv.DictReader(csv_file) jason = [x['json'].replace('""', '"') for x in file] for x in jason: data = json.loads(x) device_id = data['device_id'] ding_id = data['ding_id'] save_file.write(f'{device_id},{ding_id}\n')