Answered step by step
Verified Expert Solution
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 | |
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 | |
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
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