A Python code to read data from the cvs file named "employee-sample.csv."

Life without SQL . A comma separated values (csv) file is given on Canvas: employee-sample.csv. It contains a dataset with employee salary information, which includes Full Name, Current Annual Salary, Gross Pay Received, Overtime Pay, Department (This is the abbreviation of department name; for example BOA stands for Board of Appeals), Division, Assignment Category (Parttime-Regular, Fulltime-Regular), Position Title (Supervisor, Manager, Social worker, Library assistant, ), and Date First Hired.

Problem: You have to write a Python program to answer one of queries a) or b) below. Your code must process the csv data file directly (meaning, solve the problem without importing the data in a DBMS and using SQL.)

1. Query: Search for and list the names of all employees who work in the same department as Adcock Sr Gerald W- himself excluded.

Note: The department in which Adcock works must be found programmatically, by searching the csv file it must not be hardcoded in your program; the same applies for finding the employees working in that department. Hint: there are 29 employees that your code should find.