如何解析AttributeError:只能使用带字符串值的.str访问器

Question

当我使用下面的代码时，发生了AttributeError。详情如下所示

import pandas as pd
import numpy as np 
from pandas import DataFrame as df 
import re


data = {'Tim': 'Tim@google.com', 'Rob': 'Rob@gmail.com', 'Jen': 'Jen@gmail.com', 'Wes': np.nan}

data = pd.Series(data)
    
pattern = r'([A-Z0-9._%+-]+)@([A-Z0-9.-]+)\.([A-Z]{2,4})'

matches = data.str.match(pattern, flags=re.IGNORECASE)

matches.str.get(1)

下面显示的是发生的AttributeError

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-13-e12b5eab19b6> in <module>
      6 matches = data.str.match(pattern, flags=re.IGNORECASE)
      7 
----> 8 matches.str.get(1)




  AttributeError: Can only use .str accessor with string values!
---------------------------------------------------------------------------

如何解决上述错误以获得以下答案

In : matches.str.get(1) 
Out: 
    Tim     google 
    Rob     gmail 
    Jen     gmail 
    Wes     NaN 

Answer 1

您需要执行以下操作：

matches = data.str.findall(pattern, flags=re.IGNORECASE)
matches.str.get(0).str.get(1)