extracting numeric string from text in python

Question

I am trying to extract numeric string from text using python - example : "大田区大森北3−24−27ルミエールN103 " I only want '3-24-27' from a column in df. I tried this but the error says invalid syntax. I am now working with Japanese script but I need this for other languages as well. I am new to python and request some help - Thanks.

is the numeric string always in the format #-##-##? For instance, you also have 103 at the end of the string, but don't seem to want that. So how do you decide which numeric characters are the ones you really want? — ALollz
– ALollz, Commented Jul 11, 2018 at 13:35
Try adding # -*- coding: utf-8 -*- to the top of your file before imports. Try putting your full code so we could figure out the answer — Mohammed Abuiriban
– Mohammed Abuiriban, Commented Jul 11, 2018 at 13:38
Welcome to Stack Overflow! Please review the guide to asking good questions. You should post an example of your code and errors. Since this is a syntax error, seeing your actual code would help check for typos or other issues. — Logan Bertram
– Logan Bertram, Commented Jul 11, 2018 at 13:46

Rakesh · Accepted Answer · 2018-07-11 13:41:53Z

2

Using str.extract

Ex:

import pandas as pd
df = pd.DataFrame({"a": [ "大田区大森北3−24−27ルミエールN103"]})
print( df["a"].str.extract(r"(\d+−\d+−\d+)") )

Output:

0    3−24−27
Name: a, dtype: object

Note: I have used − not the minus symbol in keyboard(-)

answered Jul 11, 2018 at 13:41

Rakesh

82.9k17 gold badges86 silver badges122 bronze badges

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

1 Comment

Rakesh Over a year ago

Please accept ans if it solved your problem(tick symbol near the ans) Thanks

pafreire · Accepted Answer · 2018-07-11 16:14:27Z

1

You can do that using only a regex standard library:

import re

pattern = '(\d+−\d+−\d+)'
text = '大田区大森北3−24−27ルミエールN103'
result = re.search(pattern, text)
print(result.group(0))

The pattern is using '\d+' to get only digits and '-', used as the separator in your example.

answered Jul 11, 2018 at 16:14

pafreire

1463 bronze badges

Collectives™ on Stack Overflow

extracting numeric string from text in python

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related