I have a dataset as shown below:
Cola colb
1.2/1.4/1.5/1.6 A
3.3/5.6 B
I want to have one column
COlA Colb
1.2 A
1.4 A
1.5 A
1.6 A
3.3 B
5.6 B
How do I do this in python
I have a dataset as shown below:
Cola colb
1.2/1.4/1.5/1.6 A
3.3/5.6 B
I want to have one column
COlA Colb
1.2 A
1.4 A
1.5 A
1.6 A
3.3 B
5.6 B
How do I do this in python
Import as a pandas dataframe, and use str.split
and explode
:
df['Cola'] = df.Cola.str.split('/')
df.explode('Cola')
Cola colb
0 1.2 A
0 1.4 A
0 1.5 A
0 1.6 A
1 3.3 B
1 5.6 B