python-2.7 - 使用 Python pandas 从电子邮件中提取用户名

Question

我尝试从 CSV 文件中读取大量电子邮件地址，并使用 Pandas 从这些电子邮件地址中提取用户名，但收到以下错误消息。

ValueError:值的长度与索引的长度不匹配

这是我的代码，并不复杂。

import pandas as pd
import sys

input_file = sys.argv[1]

data_frame = pd.read_csv(input_file)

data_frame['Username'] = data_frame['Email Domain'].str.split("@")[0]

print(data_frame)

我做错了什么？谢谢，

Answer 1

严格尝试解释你做错了什么

data_frame['Email Domain'].str.split("@")[0]
#           splits the strings /           \ points to the first row of result

解决方案

data_frame['Email Domain'].str.split("@").str[0]

0       abc
1       xyz
2    blah24
Name: Email Domain, dtype: object

设置
谢谢A-Za-z

df = pd.DataFrame(
    {'username': ['<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="65040706250208040c094b060a08" rel="noreferrer noopener nofollow">[email protected]</a>', '<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="f9818083b98098919696d79a9694" rel="noreferrer noopener nofollow">[email protected]</a>', '<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="51333d3039636511363c30383d7f323e3c" rel="noreferrer noopener nofollow">[email protected]</a>']})