Slice string colum in pandas

Question

Guys i would like slice the column 'Delivey' in pandas line by line. How i do that?

Actual Data:

OF	Delivery
BR1000	888000; 888001
BR1002	888002; 888003
BR1003	88804

New data:

OF	Delivery
BR1000	888000
BR1000	888001
BR1002	888002
BR1002	888003
BR1003	88804

Thanks, Regards

Corralien · Accepted Answer · 2021-12-09 14:36:58Z

2

Use str.split:

>>> df.assign(Delivery=df['Delivery'].str.split('; ')).explode('Delivery')
       OF Delivery
0  BR1000   888000
0  BR1000   888001
1  BR1002   888002
1  BR1002   888003
2  BR1003    88804

answered Dec 9, 2021 at 14:36

Corralien

121k8 gold badges44 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Slice string colum in pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related