Cleaning data in column of dataframe with Regex - Python [duplicate]

Question

I have a dataframe with a 'power' cars column of object type. I need to get the numeric values of ch. The data is like:

df = pd.DataFrame({'power': ['265 kW (360 ch)', '125 à 135 kW (170 à 184 ch)', '244 kW (332 ch) en 75D,']})

That's what I need:

df = pd.DataFrame({'power': [360, 184, 332]})

Can a power Regex person help me please? Or maybe with another technical expertise without being Regex?

Note: it's not just a question of how get a simple number in a string, please Mister Wiktor Stribizew, stoping mark people question as duplicated! Sorry if you have arrived to later to answer it! Thanks

Are these numbers of kW always 3 digits?

Erfan
– Erfan

2019-04-01 15:03:23 +00:00
Commented Apr 1, 2019 at 15:03 — Erfan
– Erfan, Commented Apr 1, 2019 at 15:03

a_guest · Accepted Answer · 2019-04-01 15:03:44Z

1

You can use df.apply with re.search:

>>> df.power.apply(lambda x: re.search(r'(\d+) ch', x).group(1))
0    360
1    184
2    332

answered Apr 1, 2019 at 15:03

a_guest

36.7k15 gold badges75 silver badges137 bronze badges

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

1 Comment

Mariana Belo Over a year ago

Yessss it works!!! Thanks brow :D

Collectives™ on Stack Overflow

Cleaning data in column of dataframe with Regex - Python [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related