Updated the data-import script to use regex to find the department columns. In some older version of the data, there were multiple department columns - one with a number and one with the name. Had to add some extra logic to filter out the department number column, and focus on the department name. After those changes were complete and tested, re-ran the data-import script, which updated the departments.json file and the employees.csv files for the months where the previous data-import script was not able to find the department columns.
Updated the data-import script to use regex to find the department columns. In some older version of the data, there were multiple department columns - one with a number and one with the name. Had to add some extra logic to filter out the department number column, and focus on the department name. After those changes were complete and tested, re-ran the data-import script, which updated the departments.json file and the employees.csv files for the months where the previous data-import script was not able to find the department columns.