我正在构建一个python代码,以使用pandas验证给定CSV文件中的电子邮件地址和电话号码,并且我想编写一个单独的CSV文件,其中只包含验证过的值。我对python完全陌生,我已经为该功能编写了如下代码:
from email_validator import validate_email, EmailNotValidError
import pandas as pd
import re
file = r'sample.csv'
filtered = r'filtered.csv'
valid = r'Valid.csv'
df=pd.read_csv(file)
def eVali(dataFrame):
try:
validate_email(dataFrame)
return True
except EmailNotValidError:
return False
def phoneValid(dataFrame):
if re.search("\w{3}-\w{3}-\w{4}",dataFrame):
return True
else:
return False
df["Email_validate"] = df['email'].apply(eVali)
df_fltrd = df[df['Email_validate']]
#del df_fltrd['Email_validate']
print(df_fltrd)
df_fltrd["Phone_validate"] =df_fltrd['phone'].apply(phoneValid)
df_valid = df_fltrd[df_fltrd["Phone_validate"]]
del df_valid["Phone_validate", "Email_validate"]
print(df_valid)
df_fltrd.to_csv(filtered)
df_valid.to_csv(valid)
这段代码运行良好,我可以根据需要创建一个带有验证值的新CSV。但是当我试图用正确的方法将代码组织为一个正确的类时,它给出了一个错误提示
Traceback (most recent call last):
File "E:\myTasks\validator.py", line 7, in <module>
class Validator:
File "E:\myTasks\validator.py", line 47, in Validator
validation(self.file)
AttributeError: module 'self' has no attribute 'file'
这是我创建的类
Validator.py
import self as self
from email_validator import validate_email, EmailNotValidError
import pandas as pd
import re
class Validator:
def __init__(self):
self.file = r'sample.csv'
self.outFile =r'filteredSample.csv'
def emailValid(dataframe):
try:
validate_email(dataframe)
return True
except EmailNotValidError:
return False
def phoneValid(dataframe):
if re.search("\w{3}-\w{3}-\w{4}", dataframe):
return True
else:
return False
def validation(self):
df = pd.read_csv(self.file)
df = df.copy();
df["Email_validate"] = df['email'].apply(Validator.emailValid)
df_filtered = df[df['Email_validate']]
print(df_filtered)
df_filtered["Phone_validate"] = df_filtered['phone'].apply(Validator.phoneValid)
df_valid = df_filtered[df_filtered["Phone_validate"]]
del df_valid["Email_validate"]
del df_valid["Phone_validate"]
print(df_valid)
df_valid.to_csv(self.outFile)
validation(self)
谁能帮我一下吗。非常感谢。提前谢谢
您不导入self。 self是代码执行时所处的实例
你的问题是你还不了解课程。您试图在类中调用python不喜欢的类方法
我建议你看看https://docs.python.org/3/tutorial/classes.html和/或https://www.w3schools.com/python/python_classes.asp
要将最后一行推到末尾并添加
嗯,您不能从类本身调用实例方法
该位应该在类之外,例如,可以在实例化验证器对象后从主函数调用它
相关问题 更多 >
编程相关推荐