Sorry for the confusing title.
I have a csv file with rows structured like this:
1234567, Install X Software on Y Machine, ServiceTicket,"{'id': 47, 'name': 'SERVICE BOARD', '_info': {'board_href': 'https://MY-URl'}}","{'id': 897, 'name': 'Completed', '_info': {'status_href': 'https://MY-URl'}}...
The goal is to reformat it so that 'name' values under 'board' and 'status' keys are used instead. The desired format is:
1234567, Install X Software on Y Machine, ServiceTicket, SERVICE BOARD, Completed
I'm struggling with this task and would greatly appreciate any guidance.
Here's the code I've written to extract .json data from a GET request and convert it into a .csv file:
data = requests.get(url=TICKET_URL, headers=HEADER_AUTH) ### Get data from
data = data.json()
count = 0;
csvData = open("test.csv", "w")
csvWriter = csv.writer(csvData)
with open("data.json", "w") as f:
for item in data:
if count == 0:
header = item.keys()
csvWriter.writerow(header)
count += 1
csvWriter.writerow(item.values())
f.write("%s\n" % item)
csvData.close()
f.close()