Custom Filter on values in a dataframe column (Python)

Question

I have a column which has values of 6 charaters, followed by "-", followed by a number. I want to replace the original value with the number only.

For example - If the column has a value of ABCXYZ-123. I need to replace it with 123. Need it for all the rows of that column.

I was also able to right an Excel formula for the same - =NUMBERVALUE(MID(B2,(FIND("-",B2)+1),LEN(B2)))

How to do the same in Python?

Sociopath · Accepted Answer · 2019-12-02 07:28:33Z

1

You need:

df["col1"] = df["col1"].apply(lambda x: x.split("-")[-1])

Replace col1 with your column name

answered Dec 2, 2019 at 7:28

Sociopath

13.4k22 gold badges53 silver badges82 bronze badges

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

2 Comments

why not used str pandas functions?

@jezrael coz I couldn't come up with .str.str part

jezrael · Accepted Answer · 2019-12-02 07:31:54Z

1

I prefer here Series.str.split with str[-1]:

df["col1"] = df["col1"].str.str.split("-").str[-1]

answered Dec 2, 2019 at 7:31

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

should be faster then apply