Question: Write a python script that will filter the below table based on the Name column and send that filtered table to that all the people

Write a python script that will filter the below table based on the "Name" column and send that filtered table to that all the people whose names are in that name column and their corresponding rows. there are total 5 people and everyone will get an email with the attached file.

Name Email Work Rent
Moon MonLee.mail Moon_Resturant $1,200
Sun SunWong.mail Sun_Resturant $2,000
Wong WongSon.mail Wong_Resturant $4,000
Lee LeeSang.mail Lee_Resturant $3,599
Quin QuinFeen.mail Quin_Resturant $3,444
Moon MonLee.mail Moon_Hotel $1,200
Sun SunWong.mail Sun_Hotel $2,000
Wong WongSon.mail Wong_Hotel $4,000
Lee LeeSang.mail Lee_Hotel $3,599
Quin QuinFeen.mail Quin_Hotel $3,444
Moon MonLee.mail Moon_Market $1,200
Sun SunWong.mail Sung_Market $2,000
Wong WongSon.mail Wong_Market $4,000
Lee LeeSang.mail Lee_Market $3,599
Quin QuinFeen.mail Quin_Market $3,444

For instance, Moon will get an email at MonLee.mail with an attached file of 3 rows where her name is present.

Name Email Work Rent
Moon MonLee.mail Moon_Resturant $1,200
Moon MonLee.mail Moon_Hotel $1,200
Moon MonLee.mail Moon_Market $1,200

Likewise, all the people will get the same type of email with an attached file where their name is present.

Please write a python script that will do the above work.

Thank you in advance for your help!

No, it is an excel file.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!