Generation

generate functionMon, 15 May 2023

take a .csv format with 7 rows of data and translate that into the following format for json { "identifier": "example@otprivacy.com", "requestInformation": "eyJhbGciOiJSUzUxMiJ9.eyJvdEp3dFZlcnNpb24iOjEsInByb2Nlc3NJZCI6ImJjNTNkMTU0LTEyZTEtNDBhOC04NDMzLTM1MWQ5ZTg2MTMyNyIsInByb2Nlc3NWZXJzaW9uIjoxLCJpYXQiOiIyMDIzLTAxLTExVDE2OjIxOjIzLjQwNyIsIm1vYyI6IkFQSSIsInBvbGljeV91cmkiOm51bGwsInN1YiI6IkVtYWlsIiwiaXNzIjpudWxsLCJ0ZW5hbnRJZCI6IjdlMTQ5MjgzLTMyNDEtNDFjZS04ZGE3LWMxOGYwZWI5ZWY3ZiIsImRlc2NyaXB0aW9uIjoiQWNjb3VudCBDcmVhdGlvbiBUcmlnZ2VycyB0aGlzIENQICIsImNvbnNlbnRUeXBlIjoiQ09ORElUSU9OQUxUUklHR0VSIiwiYWxsb3dOb3RHaXZlbkNvbnNlbnRzIjpmYWxzZSwiZG91YmxlT3B0SW4iOmZhbHNlLCJwdXJwb3NlcyI6W3siaWQiOiJlZDUxN2VhZC1kNWE2LTRkN2YtODVjNC1iMjY0N2IzNDAxNGMiLCJ2ZXJzaW9uIjoxLCJwYXJlbnRJZCI6bnVsbCwidG9waWNzIjpbXSwiY3VzdG9tUHJlZmVyZW5jZXMiOlt7ImlkIjoiNmIzOTk3M2EtMzEzYS00Y2NjLWJkZWQtYjJhOWMxYzk3MGI3IiwiaXNSZXF1aXJlZCI6ZmFsc2UsIm9wdGlvbnMiOlsiOTdjZGI1M2MtNGVjMC00ZmY3LWEyMzktY2JmZGE4ZGNiOTA2IiwiNzJiOGViMTgtNzVmNi00MmMxLWI3ZDUtNTVlOTc4MDQ2ZTViIiwiMWZmOWM0MTktZTFlZC00M2U0LWE1ZTYtMGY4NzQ1YjExZjQ0Il19XSwiZW5hYmxlR2VvbG9jYXRpb24iOmZhbHNlfSx7ImlkIjoiZTJhNjYxMmYtODg2My00MzQ1LTkzNjctN2E0YTMxODUzMTliIiwidmVyc2lvbiI6MSwicGFyZW50SWQiOm51bGwsInRvcGljcyI6W10sImN1c3RvbVByZWZlcmVuY2VzIjpbXSwiZW5hYmxlR2VvbG9jYXRpb24iOmZhbHNlfV0sIm5vdGljZXMiOltdLCJkc0RhdGFFbGVtZW50cyI6W10sImF1dGhlbnRpY2F0aW9uUmVxdWlyZWQiOmZhbHNlLCJyZWNvbmZpcm1BY3RpdmVQdXJwb3NlIjpmYWxzZSwib3ZlcnJpZGVBY3RpdmVQdXJwb3NlIjp0cnVlLCJkeW5hbWljQ29sbGVjdGlvblBvaW50IjpmYWxzZSwiYWRkaXRpb25hbElkZW50aWZpZXJzIjpbXSwibXVsdGlwbGVJZGVudGlmaWVyVHlwZXMiOmZhbHNlLCJlbmFibGVQYXJlbnRQcmltYXJ5SWRlbnRpZmllcnMiOmZhbHNlLCJwYXJlbnRQcmltYXJ5SWRlbnRpZmllcnNUeXBlIjpudWxsLCJhZGRpdGlvbmFsUGFyZW50SWRlbnRpZmllclR5cGVzIjpbXSwiZW5hYmxlR2VvbG9jYXRpb24iOnRydWV9.FSQBut6afDM4YFC3I3teMO-8CPbxr1B5fEj5pOcs82SwUbrSJfTC11iZi_yF3jTL3PWOsogvUMDFEkmc38beeJNHCb3dGPVpfibZazjJyog-SX8zmrZcQ8-IVDVx0YDXrEwyZfP3uVF0WB9cQBRFN0h6uR7dn4-Wo_GqV5VSGZn8oPCZiOLGItdA5eMGpP4_iO1j7U0R6ECA-7EiXf_9Ftp6_64clHBttVmxrC_zclDn8r7HfPekz1B1r84xfG6gVRI31_U8SrEAniBgvGt88UhhZ9LfNJU8a6smBLSfjyXXTDJf_YAO6CuIw84WdjP-OH3OVjYrWcDq-UR94XP5TM88wvX8AFRXTbV3NWP1vUlGKVU-uyOdvqmU8Bex1On1rfxYA39iKt0v_wKE5L7CAhnHAzdKwC6uqLLiEUwfZwjTG5KwiMXNN-ebkTa0N3cIEmfDi53ykZdZgdNbx30oPU-G3R1sPZXAg0LXc6Hnqoa-tzTYgmfIslOS478WXVy7TlyCk94LUg-skyyP2vJSEPuldirSgTvlOFpPb5xAxzJAjLLZyD-gNzUDaL25TuzcCHkKmMOewyS7aNrde9UAGgnDsd0MP7MjnIIwSbxHSBjIBIorRPywzePp1rs9wTl_OlfIsXhrkeqay0df1UMYmghzDLHLkX5xtcZGaRB87wE", "purposes": [ { "Id": "ed517ead-d5a6-4d7f-85c4-b2647b34014c", "TransactionType": "CONFIRMED", "CustomPreferences": [ { "Id": "6b39973a-313a-4ccc-bded-b2a9c1c970b7", "Options": [ "97cdb53c-4ec0-4ff7-a239-cbfda8dcb906", "72b8eb18-75f6-42c1-b7d5-55e978046e5b", "1ff9c419-e1ed-43e4-a5e6-0f8745b11f44" ] } ] }, { "Id": "e2a6612f-8863-4345-9367-7a4a3185319b", "TransactionType": "CONFIRMED" } ] }

import json import csv with open('test1.csv', mode='r') as csv_file: csv_reader = csv.DictReader(csv_file) line_count = 0 purposes = [] for row in csv_reader: if line_count == 0: print(f'Column names are {", ".join(row)}') line_count += 1 print(f'\t{row["PurposeId"]} works in the {row["TransactionType"]} department, and was born in {row["EnableGeolocation"]}.') line_count += 1 purpose = { "Id": row["PurposeId"], "TransactionType": row["TransactionType"], "CustomPreferences": [ { "Id": row["CustomPreferenceId"], "Options": row["Options"].split(",") } ], "EnableGeolocation": bool(row["EnableGeolocation"]) } purposes.append(purpose)

Questions about programming?Chat with your personal AI assistant