Advertisement
homeworkhelp111

Untitled

Dec 11th, 2023
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. import csv
  2.  
  3. def display_manager_solution(csv_data):
  4. employees = []
  5. managers = {}
  6. current_id = 1
  7.  
  8. reader = csv.DictReader(csv_data.splitlines())
  9.  
  10. for row in reader:
  11. manager_full_name = row['Manager']
  12. if manager_full_name and manager_full_name not in managers:
  13. managers[manager_full_name] = str(current_id)
  14. current_id += 1
  15.  
  16. # Assign an ID to the employee (who is not already a manager)
  17. employee_full_name = f"{row['FirstName']} {row['LastName']}"
  18. if employee_full_name not in managers:
  19. managers[employee_full_name] = str(current_id)
  20. current_id += 1
  21.  
  22. manager_id = managers.get(manager_full_name, '')
  23.  
  24. employees.append((managers[employee_full_name], manager_id, row['LastName'], row['FirstName']))
  25.  
  26. employees.sort(key=lambda x: x[0])
  27.  
  28. for employee in employees:
  29. print(','.join(employee))
  30.  
  31.  
  32. def main():
  33. csv_data = []
  34. with open('employees.csv') as f:
  35. csvreader = csv.reader(f)
  36. csv_data = list(csvreader)
  37. # Display the manager solution
  38. display_manager_solution(csv_data)
  39.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement