PYTHON HELP. Will give thumbs up! Below are the header names for different enrol

Question

PYTHON HELP. Will give thumbs up!

Below are the header names for different enrollment files that must be processed. You are tasked to create a harmonized header format that includes all the information from different files. There must be no repeated data. For example, EMPLOYEE_NAME and “MemberFirstName & MemberLastName” provide the same information and can’t all be in the harmonized format.

Start by creating a list for each header type.

ClientID,EmployeeID,MemberFirstName,MemberLastName,DeductionAttempted,DeductionCollected,Status,DeductionDate

ClientID| EmployeeID| MemberFirstName| MemberLastName| DeductionAttempted| DeductionCollected| Status| DeductionDate

EMPLOYEE_NAME,EMPLOYEE_NUMBER,REMITTANCE_AMOUNT,PRODUCT_TYPE

ClientID,EmployeeID,DeductionAttempted,DeductionCollected,Status,DeductionDate,KRO-PAY-000284

MemberFirstName,MemberLastName,EmployeeID

"FirstName","MiddleName","LastName","EmployeeId","SSN","BenId","OptionId","TierId","Amount Taken","Month"

Explanation / Answer

Below are the header names from different files without duplicate information.

Please find below header names.

EmployeeID, MemberFirstName, MemberLastName, Status, ProductType, RemittanceAmount, DeductionDate

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.