当我运行它时,我可以要求我输入密码,但是当它启动我的“ for”循环时,在重新格式化数据时出现错误。
import csv, smtplib, ssl
import pandas as pd
newhire = pd.read_csv('New_Hires_Test.csv', delimiter = ",", skiprows=7) #Open up the document and
skip header
newhire["Email"] = "[email protected]" #Add a row 'Email' and add email address
mask = newhire["New IT Item"] == "New" #brings back only new in "New IT Item column"
message = """\Subject: {Effective Date}
From: [email protected]
To: [email protected]
Hello IT,
We have a new user by the name of {StartDate}. The new user will be starting on {Employee} and will
be working at {PC}.
Their title will be {Title} and their supervisor is {Supervisor}"""
from_address = "[email protected]"
password = input("Type your password and press enter: ")
context = ssl.create_default_context()
with smtplib.SMTP_SSL("smtp.gmail.com", 465, context=context) as server:
server.login(from_address, password)
for Employee, StartDate, PC, Title, Supervisor, Email in newhire[mask]:
server.sendmail(
from_address,
Email,
message.format(Employee=Employee, StartDate=StartDate, PC=PC, Title=Title, Email=Email,
Supervisor=Supervisor)
)
print('Emails were sent successfully!')
***ValueError: too many values to unpack (expected 6)***
我正在查看我的“ for”循环,看到其中有6列正在寻找。我的数据都是字符串,我设置了一个定界符只是为了确保所有数据都正确分开。
****New_Hires_Test.csv***
Report: ,,,All HR Action Requests: IT CAFs - New Hires (KB
Copy),,,,,,,,,,,,,
Sorted By: ,,,Effective Date Descending,,,,,,,,,,,,,
Filtered By: ,,,Initiator Filter: All Employees; Employee Filter: All
Employees; Approver Filter: All Employees; HR Action = Hire Employee (Staff)
- Step 2,,,,,,,,,,,,,
Date & Time: ,,,01/06/2020 09:12p,,,,,,,,,,,,,
Generated By: ,,,Haywood,,,,,,,,,,,,,
Company: ,,,Corp Solutions(6122261),,,,,,,,,,,,,
,,,,,,,,,,,,,,,,
New IT Item,StartDate,Effective Date,Employee Name,PC,Title,Supervisor
Name,Manager 2 Name,O365,ID
Badge,Computer,Avionte,GP,Hotspot,Tablet,TimeZone,HR Action
New,01/13/2020,02/03/2020,Elizabeth Anne Everts,Internal Staff/003 -
003,Onboarding Specialist,Suzanne Mitchell,Angela
Robbins,Yes,,No,Yes,No,No,No,Eastern,Hire Employee (Staff) - Step 2
New,01/13/2020,01/13/2020,Karla Ramirez,Internal Staff/204 - 003,
Recruiter,Scott Clark,Shane Houser,Yes,,Standard
Laptop,Yes,Yes,No,No,Central,Hire Employee (Staff) - Step 2
New,01/13/2020,01/06/2020,Megan Arreola,Internal Staff/221 -
003,Recruiter,Elsa Muneton,Amanda Stewart,Yes,,No,Yes,No,No,No,Eastern,Hire
Employee (Staff) - Step 2
最佳答案
将您的循环替换为iterrows()
调用,如下所示:
for i, r in newhire[mask].iterrows():
server.sendmail(
from_address,
r["Email"],
message.format(Employee=r["Employee"],
StartDate=r["StartDate"],
PC=r["PC"],
Title=r["Title"],
Email=r["Email"],
Supervisor=r["Supervisor"]
)
)
编辑1:
newhire[mask]
中的for a,....,c in newhire[mask]
将解压缩newhire[mask]
int a,....,c
的内容(整个数据帧)。您要做的是仅解压缩单行的内容。为此,您可以使用newhire[mask].iterrows()
,它在每一行上返回其索引和行实例本身。您也可以按照此问题Pandas for loop over dataframe gives too many values to unpack所述使用
itertuples()