擅长:python、mysql、java
<p>下面是我如何解决这个问题的,如果你有任何优化的想法,请不要犹豫发表评论。非常感谢。感谢@Mayank Porwal的帮助</p>
<pre><code>participantsData = pushupCountXLS.groupby(['Email', 'Name', 'Date'], as_index=False ).agg(sum)
uniqueEmailAdd = participantsXLS['Email Address'].unique()
for em in uniqueEmailAdd:
if check_valid_email(str(em)):
temp = participantsData[participantsData['Email'].eq(em)]
temp = temp.astype({'Regular':int, 'Easy':int, 'Special':int})
uniqunames=(temp['Name'].unique())
strtemp2=""
for participant in uniqunames:
#strtemp2 = temp[['Date', 'Regular', 'Easy', 'Special']].to_string(index=False)
temp2 = temp[temp['Name'].eq(participant)]
strtemp2 = str(participant) + '\n'
strtemp2 += temp2[['Date', 'Regular', 'Easy', 'Special']].to_string(index=False)
emailcounter += 1
print(emailcounter)
send_email(em, strtemp2)
</code></pre>