Delete characters on dataframe python

Question

ID Duration 
0   6-month
1   12-month
2   24-month

I want to delete '-month'. Can you help me ?

Thanks

Does this answer your question? [substring of an entire column in pandas dataframe](https://stackoverflow.com/questions/36505847/substring-of-an-entire-column-in-pandas-dataframe) — Nicholas Hansen-Feruch, Sep 26 '22 at 19:51

score 0 · Answer 1 · answered Sep 26 '22 at 22:05

0

Assuming that month number comes before the '-month' in duration

You can use regex to extract the digits.

df['Duration']=df['Duration'].str.extract(r'(\d*)')
df

    ID  Duration
0    0       6
1    1      12
2    2      24

answered Sep 26 '22 at 22:05

Naveed

score 0 · Answer 2 · answered Sep 26 '22 at 22:28

0

Here's another solution

df['Duration']= df['Duration'].apply(lambda x:x.replace('-month',''))

answered Sep 26 '22 at 22:28

Daniel Gonçalves

2 Answers2