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 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 ( Please see that attached file of your projects list) 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 Thank you

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

Question: Write a python script that will match two excel files based on the State column and those matched rows as a list , send to

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 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: ( Please see that attached file of your projects list)

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.

Thank you!

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

Write a python script which will pull data from two excel files based on name column and send found information from those excel files to their emails whose name are present in name columns. Table 1:...

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

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

1) Project Instructions (this document me) - requirements of the project. 2) Cycles processes and other information (document file) - description of what needs to be done for each process, list of...

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

pleass hslp ms on hos to complete this assignment with the steps i also attached Font 10 N Company Name Actual Expenses Sheet First Two Quarters of 2021 February June Trends May Total lan Percent of...

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

1. Why isnt the time of the dentists appointment protected by the Fourth Amendment in this case? 2. Did the police go too far in this case by requesting confidential information from the dentists...

All of the following would be considered a company with high operating leverage, except O A. Airline company OB. Amusement park C. Hotel chain D. T-shirt kiosk in a mall

What are the effects of financing and regimes on global environmental conditions?

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

LO2 Discuss important legal areas regarding safety and health.

LO4 Recognize the activities that constitute effective safety management.

4. Data security breaches at many large retailers, financial institutions, and government agencies highlight a need for extreme vigilance on the part of everyone who handles data for organizations....