Loop through rows of pandas dataframe and create variables based on columns

Question

I have a pandas.DataFrame with df.columns = ['jobID', 'emailAddress', 'jobTitle', 'jobSource', 'contactName'] and index_col = 'jobID'

My objective is to loop through each row of this dataframe and create variables based on the value of each 'cell' (intersection of column and row) and pass that to a function I wrote that automates email generation and sending.

This is what I have so far, but this doesn't get it done.

for row in df.index():
    email = str(df['emailAddress'])
    jobTitle = str(df['jobTitle'])
    jobSource = str(df['jobSource'])
    jobID = str(df['jobID'])
    nameOfContact = str(df['contactName'])

    """ generate the email subject using string methods
    'This is a subject about %s' % (jobTitle)
    """
    subj = emailSubj(jobSource = jobSource,
              jobTitle = jobTitle,
              jobID = jobID)

    """
    create email body using similar logic as subject
    """
    body = create_emailBody(nameOfContact = nameOfContact)
    """
    Generate and send the email by passing email address, subject, body
    """
    emailTool(email = email,
              subj = subj,
              body = body)

This script does run, but I don't think I am properly looping through the rows and naming the variables. I am receiving the entire column instead of the cell.

Check this link -- > stackoverflow.com/questions/7837722/…. — Hara Chaitanya
– Hara Chaitanya, Commented Dec 28, 2017 at 15:44

MaxU - stand with Ukraine · Accepted Answer · 2017-12-28 15:56:18Z

1

you can use .apply(..., axis=1):

df.apply(lambda r: 
            emailTool(email=r['emailAddress'],
                      subj=emailSubj(jobSource=r['jobSource'],
                                     jobTitle=r['jobTitle'],
                                     jobID=r['jobID']),
                      body=create_emailBody(nameOfContact=r['contactName'])
            ),
         axis=1
)

answered Dec 28, 2017 at 15:56

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Loop through rows of pandas dataframe and create variables based on columns

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related