power query / pandas project or regex python

Job ID: 36386465

Budget: $10 – $30 USD

I'm looking to clean up an excel /csv file and create multiple columns from a single column. i'm attaching explanation.
I need this either in power query, pandas or regex python. for speed purposes.
will pay $30

thank you,

Related categories: Python Machine Learning (ML) Data Mining Pandas Microsoft PowerBI