Question
Write a python script that will match two excel file based on State column and those matched rows as a list ,send to those responsible
Write a python script that will match two excel file based on State column and those matched rows as a list ,send to those responsible person who assign to that state through email as an attachment.
Excel file : Project Information
| Project_ID | State | Type |
| 3344 | ID | Food |
| 4436 | MN | Flower |
| 5563 | FL | Fry |
| 6803 | AZ | Food |
| 7786 | CO | River |
| 8980 | WA | Market |
| 1019 | ID | Movie |
| 3345 | ID | River |
| 7903 | MN | Market |
| 4245 | FL | Movie |
| 1457 | AZ | Food |
| 3030 | CO | Flower |
| 8902 | ID | Food |
Email excel file:
| Name | State | |
| Moon Lee | ID, MN | Moon.lee@outlook.com |
| Lee Song | FL, AZ | Lee.song@outlook.com |
| Quian Fan | CO, WA | Quian.Fan@outlook.com |
Output should look like this : For instance Moon Lee will get an email like below one
Email : moon.lee@outlook.com
Hello Moon Lee
Here is the project lists you are responsible for:
| Project_ID | State | Type | Name |
| 3344 | ID | Food | Moon Lee |
| 4436 | MN | Flower | Moon Lee |
| 3345 | ID | River | Moon Lee |
| 7903 | MN | Market | Moon Lee |
| 8902 | ID | Food | Moon Lee |
Likewise, Lee Song and Quian Fan will get their projects lists.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
