Hi, I need help with this Python program. Using Python only (No pandas), I need to algorithmically manipulate the excel csv data to convert the input data to output:

Input:

Output:

NAME COLOR ROLE STUDENT LOCATION MA BOB RED BOB MA RED STUDENT STUDENT MA BOB BOB MA ID 1 2 3 4 5 6 7 8 9 BLUE BLUE YELLOW BOB MA MA YELLOW BOB TOM STUDENT STUDENT STUDENT BARISTA BARISTA TEACHER TEACHER TOM NY NY CA CA SARAH SARAH RED RED 10 ID NAME LOCATION BLUE NO 1 BOB MA MA BOB ROLE STUDENT STUDENT STUDENT BARISTA NO COLOR NO NO YES RED YES NO NO NO YES YELLOW NO NO YES NO BOB G AN 2 3 4 5 MA NO NO NO TOM NY YES SARAH TEACHER CA NO NO NO