csv['Date of Expiry'] = pd.to_datetime(csv['Date of Expiry'], errors='coerce')
today_date = pd.datetime.today().date()
csv2 = (csv['Date of Expiry'].dt.date - today_date).astype('timedelta64[D]')
def send_me_email():
server = smtplib.SMTP('Outlook.Office365.com', 587)
server.ehlo()
server.starttls()
server.ehlo()
server.login('XXX.XXXXXXX@XXX.com', 'XXXXXXXXXX')
msg = "Please consider changing your password, it will expire in two days"
server.sendmail("XXX.XXXXXXX@XXX.com", csv['Email id'], msg)
server.quit()
上面的代码运行良好,
但当我试图用下面的代码遍历文件中的所有用户时:
for k in csv:
if csv2 <= 2.0:
csv['Email id'].apply(send_me_email())
我得到以下错误:
ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().
请告诉我哪里出错了