I have a text file ' ' separated. First two columns are text and third one is in JSON format like {type: [{a: a1, timestamp: 1}, {a:a2, timestamp: 2}]}
How can i put it into DF correctly?
I would like to parse line like factor1 param1 {type: [{a: a1, timestamp: 1}, {a:a2, timestamp: 2}]}
into DF like
factor_column param_column a_column ts_column
factor1 param1 a1 1
factor1 param1 a2 2
See Question&Answers more detail:os