python - Issue processing csv loaded data

Question

Below is a sample record that is being populated into dataframe.

Input format id |Date |TimeSession

123 |29/8/2019 |[{""start"":0;""end"":1;""time"":6};{""start"":768;""end"":781;""time"":18};]"

Would like find out how to transform this further to the following format? Output format

id |Date |start |end |time

123 |29/8/2019 |0 |1 |6 123 |29/8/2019 |768 |781 |18

Attempted with the following code which doesn't look correct due to the ovelapping delimiters in the column.

s = df['TimeSession'].str.split(' ').apply(pd.Series, 1).stack()
s.index = s.index.droplevel(-1) 
s.name = 'TimeSession' 
df.join(s.apply(lambda x: pd.Series(x.split('{'))))

question from:https://stackoverflow.com/questions/65912503/issue-processing-csv-loaded-data

Answer 1

Waitting for answers