当我运行它时,我可以要求我输入密码,但是当它启动我的“ 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()

07-28 09:00