Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 Information

Project_ID

Responsible Person

State

Type

3344

Moon Lee

ID

Food

4436

Lee Song

MN

Flower

5563

Moon Lee

FL

Fry

6803

Quian Fan

AZ

Food

7786

Quian Fan

CO

River

8980

Lee Song

WA

Market

1019

Moon Lee

ID

Movie

Email excel file :

Name

Email

Moon Lee

Moon.lee@outlook.com

Lee Song

Lee.song@outlook.com

Quian Fan

Quian.Fan@outlook.com

Please write a python script which first pulls data from oracle through SQL query , save it as an excel file and then match responsible column with the name column of email excel file, then send those matched rows to matched email address.

Output:

Email : moon.lee@outlook.com

Hello Moon Lee

Here are the project you are responsible for:

Project_ID

Responsible Person

State

Type

3344

Moon Lee

ID

Food

5563

Moon Lee

FL

Fry

1019

Moon Lee

ID

Movie

Likewise, Lee Song and Quian Fan will get their projects lists.

Please do not copy the answer from another Chegg answer. This is the third time I am posting this question, and everyone is just copying the wrong answer from another Chegg question. Please I need help with this homework badly. Thank you in advance.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Students also viewed these Databases questions