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 Email 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

The Answer is in the image, click to view ...

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	Email
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

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!

Write a python script that will match two excel files based on the State column and those matched rows as a list , send to those responsible people who assign to that state through email as an...

Write a python script that will pull data from Oracle SQL table and match it with an excel file and where name row match, send those rows to those people through email. Oracle SQL Table: Project...

Write a python script that will pull data from two excel files and send an outlook email with an attached file which is combined information of those two excel files. Excel File 1: Project...

Table 1 . Data Description \ table [ [ Field , Description ] , [ ID , The ID of the patient is automatically assigned ] , [ Age , The recorded Age of the patient ] , [ sex , The Gender of the patient...

Written in Java. Please help. Any information would be greatly appreciated. Even shelling of the code would be beneficial if you cannot understand the whole thing. Thank you!!!!!!!!!!!!!!!!!! Example...

Introduction and learning objectives When you were learning about operational analysis earlier in the term, we talked about jobs that require multiple visits to the CPU (or servers) to receive their...

ATTENTION TUTORS PLEASE HELP ME IN ANSWERING THIS ATTACHMENT WORKSHEET I NEED IT FOR CLASS IN ACCOUNTING THANK YOU HAVE THE ANSWERS IN YELLOW PLEASE SEE ATTACHMENT Question 1 of 15 1. A small...

1. On a Profit & Loss statement, you wish to show only line items with transactions for the period. How can you ? A.Filter the report for amounts greater than zero. B.Select the Advanced Option...

5. Let X, X2,..., Xn be integrable random variables (i.e., EX n} = 0 otherwise. 7. Let X, X2 be independent exponentially distributed random variables, with densities fi(x) = Ae-1 and f2(x) = 2e-2...

In Exercises 1 and 2, find the distance from the point Q to the plane P. 1. Q = (2, 2, 2), P with equation x + y - z = 0 2. Q = (O, 0, O), P with equation x - 2y + 2z = 1

Assume for the moment that I am trying to get cost of equity for a firm whose stock currently trades at $ 5 0 per share. My estimate of next year's dividend is $ 5 . 0 0 . I expect that dividend to...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

3. In terms of your career, do you think you are or will mostly be a. fixed in place? b. always moving? _______

9. In terms of style, are you a. solid and mainstream? b. always on the cutting edge? _______

8. Do you tend to see a. the possibilities in a situation? b. the realities of a situation? _______