Question: Please write a python script that will filter an excel file on the Name column and send those filtered rows with a header to correspond

Please write a python script that will filter an excel file on the "Name" column and send those filtered rows with a header to correspond email

Excel File: Information

Name Project ID Type Location Email
Munia 343 Food AZ munia@email.com
Muntaha 345 Fry TX muntaha@email.com
Moon 342 Flower NY Moon@email.com
Wasif 456 Food NY wasif@email.com
Azmat 384 Flower MN Azmat@email.com
Arefin 898 Movie CT Arefin@email.com
Munia 342 Fry TX munia@email.com
Muntaha 456 Flower NY muntaha@email.com
Moon 384 Food NY Moon@email.com
Wasif 898 Food AZ wasif@email.com
Azmat 384 Fry TX Azmat@email.com
Arefin 898 Flower NY Arefin@email.com
Munia 342 Food NY munia@email.com
Muntaha 456 Flower MN muntaha@email.com
Moon 384 Movie CT Moon@email.com
Wasif 223 Food NY wasif@email.com
Azmat 224 Fry NY Azmat@email.com
Arefin 112 Flower MN Arefin@email.com

Output will be like :

email: munia@email.com

Munia

please see the below list :

Name Project ID Type Location Email
Munia 343 Food AZ munia@email.com
Munia 342 Fry TX munia@email.com
Munia 342 Food NY munia@email.com

Likewise, all the people will get their project lists whose name is present in the "Name" column.

Please help me with this homework. 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!

Q:

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

Q:

Write a python script that will filter the below table based on the "Name" column and send that filtered table to that all the people whose names are in that name column and their corresponding rows....

Q:

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

Q:

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

Q:

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

Q:

PYTHON : please help me to write a python script which will send project lists to who is assign to that project. Excel file : Project ID State Name Email 3345 MN Bob Bobby Bob.bobby@email.com 7382 NC...

Q:

PYTHON : please help me to write a python script which will send project lists to who is assign to that project. Excel file : Project ID State Name Email 3345 MN Bob Bobby Bob.bobby@email.com 7382 NC...

Q:

ACBZ420 Accounting Information Systems, Semester 2 2022. Assignment 3: Dashboard Design and Financial Modelling Due Date: Week 11. Friday 14 October 2022. 11:55pm (evening) AEST Weighting/Value: 20%...

Q:

Can you help me to write a python script which will send project lists to who is assign to that project. Excel file : Project ID State Name Email 3345 MN Sana Khan Sana.khan@email.com 7382 NC Sana...

Q:

Can you help me to write a python script which will send project lists to who is assign to that project. Excel file : Project ID State Name Email 3345 MN Jessica Mara Jessica.mara@email.com 7382 NC...

Q:

Tamarisk Company acquired a plant asset at the beginning of Year 1. The asset has an estimated service life of 5 years. An employee has prepared depreciation schedules for this asset using three...

Q:

Given raw training data (x, y) for i = 1,...,n and j = 1,...,d, we often "standardize" the data before working with it, which gives standardized features zij = (x-T)/8 and targets y = (y )/syr....

Q:

Question 1 8 HomeworkUnansweredDue Mar 2 5 th , 1 1 : 5 9 PM Mark as: None correct answers are hidden What is the PI of a project that costs $ 3 5 , 0 0 0 today and is expected to generate annual...

Q:

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...

Q:

How is the audience likely to respond to this message?

Q:

If the company is small and all employees work in the same location, which medium would you recommend for communicating this message?

Q:

Based on this audience analysis, would you use the direct or the indirect approach for this message? Explain your reasoning.