I’ve been back in the land of screen scraping 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 realized 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 not 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 skills. If you know a better way let me know in the comments.