CODEWITHSUNDEEP
pythonpandas
Ilyas
Ilyas

Reputation: 25

Python - How to split a Pandas value and only get the value between the slashs

Example: I the df['column'] has a bunch of values similar to: F/4500/O or G/2/P

The length of the digits range from 1 to 4 similar to the examples given above.

How can I transform that column to only keep 1449 as an integer?

I tried the split method but I can't get it right. Thank you!

enter image description here

Upvotes: 1

Views: 51

Answers (2)

mozway
mozway

Reputation: 261974

You could extract the value and convert to_numeric:

df['number'] = pd.to_numeric(df['column'].str.extract('/(\d+)/', expand=False))

Example:

     column  number
0  F/4500/O    4500
1     G/2/P       2

Upvotes: 1

Igor Rivin
Igor Rivin

Reputation: 4864

How's about:

df['column'].map(lambda x: int(x.split('/')[1]))

Upvotes: 0

Related Questions