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