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 Information Name Projects State Count Moon Lee Food AZ 23 Lee Wong Flower CA 34 Quian Fan Market GA 21 Moon Lee Movie TX 38 Lee Wong Food NY 44 Quian Fan House NC 23 Moon Lee Flower MN 56 Excel File 2 Outlook email information Name Email Moon Lee Moon lee outlook com Lee Wong Lee wong outlook com Quian Fan Quian fan outlook com Python script will first match the Name column in both of the excel files and based on name, from excel file 2, It will grab the email and will send information from excel file 1 whose email matched with the name column Output Email Moon lee outlook com Hello Moon Lee, Please see the below list of the projects you have Name Projects State Count Moon Lee Food AZ 23 Moon Lee Movie TX 38 Moon Lee Flower MN 56 Likewise, Lee Wong and Quian Fan will get their project lists at their outlook email address

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

Question: 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

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 Information

Name	Projects	State	Count
Moon Lee	Food	AZ	23
Lee Wong	Flower	CA	34
Quian Fan	Market	GA	21
Moon Lee	Movie	TX	38
Lee Wong	Food	NY	44
Quian Fan	House	NC	23
Moon Lee	Flower	MN	56

Excel File 2: Outlook email information

Name	Email
Moon Lee	Moon.lee@outlook.com
Lee Wong	Lee.wong@outlook.com
Quian Fan	Quian.fan@outlook.com

Python script will first match the Name column in both of the excel files and based on name, from excel file 2, It will grab the email and will send information from excel file 1 whose email matched with the name column.

Output:

Email : Moon.lee@outlook.com

Hello Moon Lee,

Please see the below list of the projects you have:

Name	Projects	State	Count
Moon Lee	Food	AZ	23
Moon Lee	Movie	TX	38
Moon Lee	Flower	MN	56

Likewise, Lee Wong and Quian Fan will get their project lists at their outlook email address.

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

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

1. There are two excel files that you need for this assignment File A. excel file for relevant Data: ?Assignment_2 data? for the data tables. File B. excel file for your answer. You need to use this...

Question 1.1 What is the cost of common equity - (i) using DGM (Dividend Growth Model) (ii) using CAPM (Capital asset pricing model)? Question 1.2 What is the cost of retained earnings? Question 1.3...

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

From the case study of Week # 5 please answer the question Who is responsible for this costly oversight? Who should take responsibility? Who is most likely to be blamed for the error? 11:33 1 5G+ 0 a...

Directions Dataset: You will be given two datasets: From the Continuous Glucose Sensor ( CGMData . csv ) From the insulin pump ( InsulinData . csv ) The output of the CGM sensor consists of three...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

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

I have to create a program in C and I can't figure it out. The program has to read a source file. Please help. /******************************************************************** PROJECT: Glossary...

A) How does Islamic banking differ from conventional banking?

Supply the intermediate mathematical steps in Justification 21.7.

MacDonald, Incorporated owns 8 0 % of the outstanding stock of Stahl Corporation. During the current year, Stahl made $ 1 2 5 , 0 0 0 in sales to MacDonald. How does this transfer affect the...

Question 1 Not yet answered Points out of 15.00 P Flag question Calculate transmission delay and propagation delay of a network communication, where: packet size = 100 Mbyte; transmission rate = 10...

As an auditor, why would transactions by the individuals with highest purchase amounts and highest number of transactions represent potential risk?

Hover over the individuals in the Benford Average visualization. What is the average Benford Expected value for the person (round to two decimal places) with the smallest Benford Average who also has...

In the clusters chart, click the individual with the highest number of transactions. What is the category or supplier group with the highest number of transactions?