Need idea or clue for parsing a column into multiple columns

Hi, Gurus.

I am newbie in the data science and python etc. I have a question in front of me to parse a column into multiple columns, with part of the value being used as column name and other as a value

for example

one column has “{abc:abc_value},{xyz:xyz_value}” i want to populate two extra columns

col_1|col_2

abc | xyz
abc_value | xyz_value

The extra column counts or names are not fixed they are floating or variable.

Can anyone please suggest, ? I tried using lambda function but no luck.

1 Like