0

I am working on a csv file that contains a lot of location data (addresses) and I want to acquire the street name information without the house number.

A sample of the data:

pd.DataFrame({'OWNERADDR': ['6612 HOLLY RD', '7618 DRESHER RD', '9062 STEINSVILLE '],
             'STREETADDR': ['7713 DRESHER RD', '7606 DRESHER RD', '9072 STEINSVILLE RD']})

Pre

What I want is:

enter image description here

Both columns are of str type. But I just want to get rid of the numeric part.

I think there must be a concise way to do it with regular expression. But my lack of knowledge of RE has prevented me from doing so.

Thanks.

Bowen Liu
  • 1,065
  • 1
  • 11
  • 24

0 Answers0