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

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: Information Table

Name

Type

Address

Project

Lee Song

Food

1122 street

12 Projects

Moon Lee

Song

2345 Steet

32 Projects

Sun Fun

Movies

3456 Street

23 Projects

Foon Lee

Clothes

7894 Street

20 Projects

Lee Song

Chinese

5566 Street

24 Projects

Moon Lee

Korea

3352 Street

90 Projects

Sun Fun

Restaurant

0023 Street

22 Projects

Foon Lee

Market

1010 Street

44 Projects

Table 2: Email Information

Name

Email

Lee Song

Firstname.lastname@email

Moon Lee

Firstname.lastname@email

Sun Fun

Firstname.lastname@email

Foon Lee

Firstname.lastname@email

So output email will be like: Email :: Lee.Song@email.com

Hello Lee Song,

Here is the all projects you have :

Name

Type

Address

Project

Lee Song

Food

1122 street

12 Projects

Lee Song

Chinese

5566 Street

24 Projects

And thats how all the people will get email whose name is present in the name column.

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!