擅长:python、mysql、java
<p>您想使用<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.findall.html" rel="nofollow noreferrer">^{<cd1>}</a>或<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.extractall.html" rel="nofollow noreferrer">^{<cd2>}</a>:</p>
<pre><code>In [11]: REGEX = '(?<!No\s)(?<!new)(?!2016)(\d{2,4})+€?'
In [12]: s = df2017['Items']
In [13]: s.str.findall(REGEX)
Out[13]:
0 [20]
1 [430]
2 [2015, 30]
3 [016, 80, 20, 00]
4 [30, 13]
5 [016, 100]
6 [016, 016, 70]
dtype: object
In [14]: s.str.extractall(REGEX)
Out[14]:
0
match
0 0 20
1 0 430
2 0 2015
1 30
3 0 016
1 80
2 20
3 00
4 0 30
1 13
5 0 016
1 100
6 0 016
1 016
2 70
</code></pre>
<p><em>通常<code>extractall</code>是首选,因为它使您保持numpy状态,而不是使用一系列python列表。</em></p>