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

Time:10-20

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

CodePudding user response:

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

CodePudding user response:

How's about:

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