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 | 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 | 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!
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
