Separating sprint column data using python

[Nitzan Matalon]

Hey Guys,

I loaded data from Jira to pandas df using python, but every row in Sprint column looks like this:

[{'id': 293, 'name': '20w53 - Backend Team', 'state': 'closed', 'boardId': 28, 'goal': '', 'startDate': '2020-12-29T07:00:02.668Z', 'endDate': '2021-01-12T07:00:00.000Z', 'completeDate': '2021-01-17T08:03:43.225Z'}, {'id': 296, 'name': '20w55 - Backend Team', 'state': 'closed', 'boardId': 28, 'goal': '', 'startDate': '2021-01-12T07:00:07.742Z', 'endDate': '2021-01-26T07:00:00.000Z', 'completeDate': '2021-01-31T07:08:46.238Z'}]

I would like to separate the data to different columns: id, name, state, boardid, goal, startdate, enddate,complete date.

Also I would like to create a new row for each sprint. In this example: having 2 rows for the same issue: for sprint 20w53 and sprint 20w55.

Is it possible?

Thank you very much!