I’ve been back in the land of screen scrapping this week extracting data from the Game of Thrones wiki and needed to write a regular expression to pull out characters and actors.
Here are some examples of the format of the data:
Peter Dinklage as Tyrion Lannister Daniel Naprous as Oznak zo Pahl(credited as Stunt Performer) Filip Lozić as Young Nobleman Morgan C. Jones as a Braavosi captain Adewale Akinnuoye-Agbaje as Malko
So the pattern is:
<actor> as <character>
optionally followed by some other text that we’re not interested in.
The output I want to get is:
Peter Dinklage, Tyrion Lannister Daniel Naprous, Oznak zo Pahl Filip Lozić, Young Nobleman Morgan C. Jones, a Braavosi captain Adewale Akinnuoye-Agbaje, Malko
I started using the ‘split’ command on the word ‘as’ but that broke down when I realised some of the characters had the letters ‘as’ in the middle of their name. So regex it is!
This was my first attempt:
import re
strings = [
"Peter Dinklage as Tyrion Lannister",
"Filip Lozić as Young Nobleman",
"Daniel Naprous as Oznak zo Pahl(credited as Stunt Performer)",
"Morgan C. Jones as a Braavosi captain",
"Adewale Akinnuoye-Agbaje as Malko"
]
regex = "([A-Za-z\-'\. ]*) as ([A-Za-z\-'\. ]*)"
for string in strings:
print string
match = re.match( regex, string)
if match is not None:
print match.groups()
else:
print "FAIL"
print ""Peter Dinklage as Tyrion Lannister
('Peter Dinklage', 'Tyrion Lannister')
Filip Lozić as Young Nobleman
FAIL
Daniel Naprous as Oznak zo Pahl(credited as Stunt Performer)
('Daniel Naprous', 'Oznak zo Pahl')
Morgan C. Jones as a Braavosi captain
('Morgan C. Jones', 'a Braavosi captain')
Adewale Akinnuoye-Agbaje as Malko
('Adewale Akinnuoye-Agbaje', 'Malko')It works for 4 of the 5 scenarios but now for Filip Lozić. The ‘ć’ character causes the issue so we need to be able to match foreign characters which the current charset I defined in the regex doesn’t capture.
I came across this Stack Overflow post which said that in some regex libraries you can use ‘\p{L}’ to match all letters. I gave that a try:
regex = "([\p{L}\-'\. ]*) as ([\p{L}\-'\. ]*)"And then re-ran the script:
Peter Dinklage as Tyrion Lannister FAIL Daniel Naprous as Oznak zo Pahl(credited as Stunt Performer) FAIL Filip Lozić as Young Nobleman FAIL Morgan C. Jones as a Braavosi captain FAIL Adewale Akinnuoye-Agbaje as Malko FAIL
Hmmm, not sure if I did it wrong or if that isn’t available in Python. I’ll assume the latter but feel free to correct me in the comments and I’ll update the post.
I went search again and found this post which suggested another approach:
You can construct a new character class:
[^\W\d_]
instead of \w. Translated into English, it means “Any character that is not a non-alphanumeric character ([^\W] is the same as \w), but that is also not a digit and not an underscore”.
Let’s try plugging that in:
regex = "([A-Za-z\-'\.^\W\d_ ]*) as ([A-Za-z\-'\.^\W\d_ ]*)"
Peter Dinklage as Tyrion Lannister
('Peter Dinklage', 'Tyrion Lannister')
Daniel Naprous as Oznak zo Pahl(credited as Stunt Performer)
('Daniel Naprous as Oznak zo Pahl(credited', 'Stunt Performer)')
Filip Lozić as Young Nobleman
('Filip Lozi\xc4\x87', 'Young Nobleman')
Morgan C. Jones as a Braavosi captain
('Morgan C. Jones', 'a Braavosi captain')
Adewale Akinnuoye-Agbaje as Malko
('Adewale Akinnuoye-Agbaje', 'Malko')So that’s fixed Filip but now Daniel Naprous is being incorrectly parsed.
For Attempt #4 I decided to try excluding what I don’t want instead:
regex = "([^0-9\(]*) as ([^0-9\(]*)"
Peter Dinklage as Tyrion Lannister
('Peter Dinklage', 'Tyrion Lannister')
Daniel Naprous as Oznak zo Pahl(credited as Stunt Performer)
('Daniel Naprous', 'Oznak zo Pahl')
Filip Lozić as Young Nobleman
('Filip Lozi\xc4\x87', 'Young Nobleman')
Morgan C. Jones as a Braavosi captain
('Morgan C. Jones', 'a Braavosi captain')
Adewale Akinnuoye-Agbaje as Malko
('Adewale Akinnuoye-Agbaje', 'Malko')That does the job but has exposed my lack of regex skillz. If you know a better way let me know in the comments.
| Reference: | Python: Regex – matching foreign characters/unicode letters from our WCG partner Mark Needham at the Mark Needham Blog blog. |
