How to filter out Column data From Multiple rows data?

[firaki12345]

Hi firaki12345,

Try this :

I hope it works for you :-

wdf.join(wdf['primaryOffer'].str.split(':', 1, expand=True).rename(columns={0:'minPrice', 1:'maxPrice', 2:'offerPrice}))

I hope this works for you, let me know what output you get with that code, and will try to modify it if you don't get the result you want.

Edit :- I tried it and it didn't work for me, so I will work on a solution for you, sorry about this.

Best Regards

Eddie Winch

hi, thanks for the quick reply, actually i found last night a better solution we all can use and it was hiding in plain sight.

json_normalize