Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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_2

Step: 3

blur-text-image_3

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

Learning MySQL Get A Handle On Your Data

Authors: Seyed M M Tahaghoghi

1st Edition

0596529465, 9780596529468

More Books

Students also viewed these Databases questions

Question

107 MA ammeter 56 resistor ? V voltmeter

Answered: 1 week ago

Question

Generally If Drug A is an inducer of Drug B , Drug B levels will

Answered: 1 week ago

Question

How is the audience likely to respond to this message?

Answered: 1 week ago