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 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…