title: Extracting group by data for each group
body: <p>I have a Excel sheet</p>
  
  <p>participantData.xlsx</p>
  
  <pre><code>email      Name     Date        RegPushupCount    EasyPushupCount    DifficultPushupCount
  a@b.com    John     2020-05-01         5                  0                   0
  a@b.com    John     2020-05-01         5                  0                   0
  a@b.com    John     2020-05-02         0                  5                   0
  a@b.com    Jane     2020-05-02         5                  0                   0
  a@b.com    Jane     2020-05-01         0                  0                   5
  b@a.com    Bill     2020-05-01         0                  0                   5
  b@a.com    Bill     2020-05-02         0                  5                   0
  </code></pre>
  
  <p>I want to send an email to every email, a summary of how many pushups they have done. I got a function send_email( email_address, email_text) this will take  care of the email part.</p>
  
  <p>I want to send email like this</p>
  
  <p><strong>email to: a@b.com</strong></p>
  
  <pre><code>John               Regular Push ups     Easy Push ups   Difficult Pushups
        2020-05-01          10               0                    0
        2020-05-02          0                5                    0
  Jane               Regular Push ups     Easy Push ups   Difficult Pushups
        2020-05-01          5                0                    0
        2020-05-02          0                5                    0
  </code></pre>
  
  <hr>
  
  <p><strong>email to: b@a.com</strong></p>
  
  <pre><code>Bill               Regular Push ups     Easy Push ups   Difficult Pushups
        2020-05-01          10               0                    0
        2020-05-02          0                5                    0
  </code></pre>
  
  <p>I hope this explains clearly.</p>
  
  <p>Here is how far I have come:</p>
  
  <pre><code>participantsData = pd.DataFrame(
  ...       pushupCountXLS.groupby(['Email', 'Name', 'Date'] ).sum().astype(int))
  </code></pre>
  
  <p>Please can you guide me how I can extract the data for each email address from the dataframe and send them email about the push ups they have done. </p>
  
  <p>Just in case if you are wondering, a group of us friends are running a 100 days pushups challenge, we enter this data in google sheet and this is like a confirmation email to them from the google sheet :)</p>