write a program assuming u have 1. Employee class having Id, Name, address, Dep_Id, Sal, Email 2. Any two Employee objects are if they are having same Id and Name 3. Now u have two CSV having list of Employees each having list of few employees having ID, Name, DepID, Salary. There are only two DepID (CS and EC). First CSV is for CS and Second is for EC. 4. There is one more CSV having list of all the employees haing the complete data (Name, Id, Address, Email)
U havew to write a program to read first two csvs and store the data of each CSV into any DataStructure and then comparte the two DataStructures and if both the DataStructures contains the same Employee (based on Name and ID) then sum the salary for both departments and put it into csv haing following data:
Name, ID, Address, Email, Dept_ID(comma separated), Total Salary of both departments u need to read the address and Email from third csv.