How to delete the same words in each row of a column?

Question

I have a dataframe df:

        workhours
0       0 days 01:45:13.250000000
1       0 days 04:23:56.723404255
2       0 days 07:11:01.688888888
3       0 days 06:02:48.160000000
4       0 days 06:27:57.280000000
5       0 days 07:00:26.551020408
6       0 days 09:04:01.039215686
7       0 days 08:50:11.941176470
8       0 days 07:30:59.725490196
...

And I just want to have the hours and not the "= days". How can I delete this from each row?

if the pattern of the data is same, `df.workhours.str.split().str[-1]` also works — anky, Aug 30 '19 at 09:21

Grzegorz Skibinski · Accepted Answer · 2019-08-30T09:29:26.163

0

Try this one:

import re

df["workhours"] = df["workhours"].apply(lambda x: re.sub("\d+ days ", "", x))

edited Aug 30 '19 at 09:29

answered Aug 30 '19 at 09:20

Grzegorz Skibinski

12,624
2
11
34

I get the error that the name "re" is not defined. what do I have to import ? – Melli Aug 30 '19 at 09:27
You need just to ```import re``` - I edited the answer – Grzegorz Skibinski Aug 30 '19 at 09:29
or use `df["workhours"].str.replace("\d+ days ", "")` – help-ukraine-now Aug 30 '19 at 09:31

How to delete the same words in each row of a column?

1 Answers1