# Need idea or clue for parsing a column into multiple columns

**URL:** <https://forum.anaconda.com/t/need-idea-or-clue-for-parsing-a-column-into-multiple-columns/30500>\
**Category:** Technical Topics\
**Created:** [August 7, 2022, 2:06am UTC](https://forum.anaconda.com/t/need-idea-or-clue-for-parsing-a-column-into-multiple-columns/30500 "2022-08-07T02:06:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Atul\_Bhingarde](https://avatars.discourse-cdn.com/v4/letter/a/80bc00/32.png) [@Atul\_Bhingarde](https://forum.anaconda.com/u/Atul_Bhingarde)\
**Post date:** [August 7, 2022, 2:06am UTC](https://forum.anaconda.com/t/need-idea-or-clue-for-parsing-a-column-into-multiple-columns/30500/1 "2022-08-07T02:06:59Z")

</div>

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.