校验:Kitty Du
自豪地采用谷歌翻译
# HIDDEN
# Clear previously defined variables
%reset -f
# Set directory for data loading to work properly
import os
os.chdir(os.path.expanduser('~/notebooks/08'))
# HIDDEN
import warnings
# Ignore numpy dtype warnings. These warnings are caused by an interaction
# between numpy and Cython and can be safely ignored.
# Reference: https://stackoverflow.com/a/40846742
warnings.filterwarnings("ignore", message="numpy.dtype size changed")
warnings.filterwarnings("ignore", message="numpy.ufunc size changed")
import numpy as np
import matplotlib.pyplot as plt
import pandas as pd
import seaborn as sns
%matplotlib inline
import ipywidgets as widgets
from ipywidgets import interact, interactive, fixed, interact_manual
import nbinteract as nbi
sns.set()
sns.set_context('talk')
np.set_printoptions(threshold=20, precision=2, suppress=True)
pd.options.display.max_rows = 7
pd.options.display.max_columns = 8
pd.set_option('precision', 2)
# This option stops scientific notation for pandas
# pd.set_option('display.float_format', '{:.2f}'.format)
在本节中,我们将介绍python内置的re
模块中 regex 的用法。因为我们只介绍了一些最常用的方法,所以您也可以参考有关re
模块的官方文档。
re.search(pattern, string)
在string
中的任意位置搜索 regexpattern
的匹配项。如果找到模式,则返回一个 TruthyMatch 对象;如果没有,则返回None
。
phone_re = r"[0-9]{3}-[0-9]{3}-[0-9]{4}"
text = "Call me at 382-384-3840."
match = re.search(phone_re, text)
match
<_sre.SRE_Match object; span=(11, 23), match='382-384-3840'>
虽然返回的 match 对象有各种有用的属性,但我们最常用re.search
来测试模式是否出现在字符串中。
if re.search(phone_re, text):
print("Found a match!")
Found a match!
if re.search(phone_re, 'Hello world'):
print("No match; this won't print")
另一个常用的方法re.match(pattern, string)
的行为与re.search
相同,但只检查string
开头的匹配项,而不是字符串中任何位置的匹配项。
我们使用re.findall(pattern, string)
提取与 regex 匹配的子字符串。此方法返回string
中所有匹配项的列表。
gmail_re = r'[a-zA-Z0-9]+@gmail\.com'
text = '''
From: email1@gmail.com
To: email2@yahoo.com and email3@gmail.com
'''
re.findall(gmail_re, text)
['email1@gmail.com', 'email3@gmail.com']
使用regex 组,我们通过将子模式括在括号( )
中指定要从 regex 提取的子模式。当 regex 包含 regex 组时,re.findall
返回包含子模式内容的元组列表。
例如,以下是我们熟悉的用 regex 从字符串中提取电话号码:
phone_re = r"[0-9]{3}-[0-9]{3}-[0-9]{4}"
text = "Sam's number is 382-384-3840 and Mary's is 123-456-7890."
re.findall(phone_re, text)
['382-384-3840', '123-456-7890']
为了将一个电话号码的三位或四位组成部分分开,我们可以将每个数字组用括号括起来。
# Same regex with parentheses around the digit groups
phone_re = r"([0-9]{3})-([0-9]{3})-([0-9]{4})"
text = "Sam's number is 382-384-3840 and Mary's is 123-456-7890."
re.findall(phone_re, text)
[('382', '384', '3840'), ('123', '456', '7890')]
正如所承诺的那样,re.findall
返回包含匹配电话号码的各个组成部分的元组列表。
re.sub(pattern, replacement, string)
用replacement
替换string
中所有出现的pattern
。此方法的行为类似于 python 字符串方法str.sub
,但使用 regex 来匹配模式。
在下面的代码中,我们通过用破折号替换日期分隔符来将日期更改为通用格式。
messy_dates = '03/12/2018, 03.13.18, 03/14/2018, 03:15:2018'
regex = r'[/.:]'
re.sub(regex, '-', messy_dates)
'03-12-2018, 03-13-18, 03-14-2018, 03-15-2018'
re.split(pattern, string)
在每次出现regex pattern
时分割输入的string
。此方法的行为类似于 python 字符串方法str.split
,但使用 regex 进行分割。
在下面的代码中,我们使用re.split
将一本书目录的章节名称和它们的页码分开。
toc = '''
PLAYING PILGRIMS============3
A MERRY CHRISTMAS===========13
THE LAURENCE BOY============31
BURDENS=====================55
BEING NEIGHBORLY============76
'''.strip()
# First, split into individual lines
lines = re.split('\n', toc)
lines
['PLAYING PILGRIMS============3',
'A MERRY CHRISTMAS===========13',
'THE LAURENCE BOY============31',
'BURDENS=====================55',
'BEING NEIGHBORLY============76']
# Then, split into chapter title and page number
split_re = r'=+' # Matches any sequence of = characters
[re.split(split_re, line) for line in lines]
[['PLAYING PILGRIMS', '3'],
['A MERRY CHRISTMAS', '13'],
['THE LAURENCE BOY', '31'],
['BURDENS', '55'],
['BEING NEIGHBORLY', '76']]
回想一下,pandas
Series对象有一个.str
属性,它支持使用 python 字符串方法进行字符串操作。很方便的是,.str
属性还支持一些re
模块的函数。我们演示了regex在pandas
中的基本用法,完整的方法列表在有关字符串方法的pandas
文档中。
我们在下面的DataFrame中保存了小说《小女人》(Little Women)前五句话的文本。我们可以使用pandas
提供的字符串方法来提取每个句子中的口语对话。
# HIDDEN
text = '''
"Christmas won't be Christmas without any presents," grumbled Jo, lying on the rug.
"It's so dreadful to be poor!" sighed Meg, looking down at her old dress.
"I don't think it's fair for some girls to have plenty of pretty things, and other girls nothing at all," added little Amy, with an injured sniff.
"We've got Father and Mother, and each other," said Beth contentedly from her corner.
The four young faces on which the firelight shone brightened at the cheerful words, but darkened again as Jo said sadly, "We haven't got Father, and shall not have him for a long time."
'''.strip()
little = pd.DataFrame({
'sentences': text.split('\n')
})
little
sentences | |
---|---|
0 | "Christmas won't be Christmas without any pres... |
1 | "It's so dreadful to be poor!" sighed Meg, loo... |
2 | "I don't think it's fair for some girls to hav... |
3 | "We've got Father and Mother, and each other,"... |
4 | The four young faces on which the firelight sh... |
由于口语对话位于双引号内,因此我们创建一个 regex,它捕获左双引号、除双引号外的任何字符序列和右双引号。
quote_re = r'"[^"]+"'
little['sentences'].str.findall(quote_re)
0 ["Christmas won't be Christmas without any pre...
1 ["It's so dreadful to be poor!"]
2 ["I don't think it's fair for some girls to ha...
3 ["We've got Father and Mother, and each other,"]
4 ["We haven't got Father, and shall not have hi...
Name: sentences, dtype: object
由于Series.str.findall
方法返回匹配项列表,pandas
还提供Series.str.extract
和Series.str.extractall
方法将匹配项提取到Series或DataFrame中。这些方法要求 regex 至少包含一个 regex 组。
# Extract text within double quotes
quote_re = r'"([^"]+)"'
spoken = little['sentences'].str.extract(quote_re)
spoken
0 Christmas won't be Christmas without any prese...
1 It's so dreadful to be poor!
2 I don't think it's fair for some girls to have...
3 We've got Father and Mother, and each other,
4 We haven't got Father, and shall not have him ...
Name: sentences, dtype: object
我们可以将此序列添加为little
DataFrame的列:
little['dialog'] = spoken
little
sentences | dialog | |
---|---|---|
0 | "Christmas won't be Christmas without any pres... | Christmas won't be Christmas without any prese... |
1 | "It's so dreadful to be poor!" sighed Meg, loo... | It's so dreadful to be poor! |
2 | "I don't think it's fair for some girls to hav... | I don't think it's fair for some girls to have... |
3 | "We've got Father and Mother, and each other,"... | We've got Father and Mother, and each other, |
4 | The four young faces on which the firelight sh... | We haven't got Father, and shall not have him ... |
我们可以通过打印原始文本和提取文本来确认字符串操作在DataFrame中的最后一句话上是否如预期执行:
print(little.loc[4, 'sentences'])
The four young faces on which the firelight shone brightened at the cheerful words, but darkened again as Jo said sadly, "We haven't got Father, and shall not have him for a long time."
print(little.loc[4, 'dialog'])
We haven't got Father, and shall not have him for a long time.
python 中的re
模块提供了一组使用正则表达式操作文本的实用方法。在处理DataFrame时,我们经常使用pandas
中实现的类似的字符串操作方法。
有关re
模块的完整文档,请参阅https://docs.python.org/3/library/re.html
有关pandas
字符串方法的完整文档,请参阅https://pandas.pydata.org/pandas-docs/stable/text.html