O02

2024-12-18 10:56:03,250 - INFO - Processing data from: C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation
2024-12-18 10:56:03,250 - INFO - Monthly reports folder: C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\monthly_reports
2024-12-18 10:56:03,250 - INFO - Output folder: C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data
2024-12-18 10:56:03,250 - INFO - Created output folder: C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data
2024-12-18 10:56:03,250 - INFO - 
Step 1: Processing Monthly Reports
2024-12-18 10:56:03,250 - INFO - Processing Monthly Reports from: C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\monthly_reports
2024-12-18 10:56:03,250 - INFO - Processing file: ACL Monthly Report 15.01.24.xlsx
2024-12-18 10:56:04,155 - WARNING - Found columns with all null values in ACL Monthly Report 15.01.24.xlsx: ['Contract Type']
2024-12-18 10:56:04,165 - WARNING - Found columns with >90% null values in ACL Monthly Report 15.01.24.xlsx: ['Contract Type', 'Review Date']
2024-12-18 10:56:04,169 - INFO - Data validation for ACL Monthly Report 15.01.24.xlsx:
2024-12-18 10:56:04,171 - INFO -   - Total rows: 521
2024-12-18 10:56:04,172 - INFO -   - Columns: 25
2024-12-18 10:56:04,271 - INFO - Processed 299 records from ACL Monthly Report 15.01.24.xlsx
2024-12-18 10:56:04,272 - INFO - Processing file: ACL Monthly Report 15.05.23.xlsx
2024-12-18 10:56:04,505 - WARNING - Found columns with all null values in ACL Monthly Report 15.05.23.xlsx: ['Contract Type']
2024-12-18 10:56:04,509 - WARNING - Found columns with >90% null values in ACL Monthly Report 15.05.23.xlsx: ['Contract Type', 'Review Date']
2024-12-18 10:56:04,511 - INFO - Data validation for ACL Monthly Report 15.05.23.xlsx:
2024-12-18 10:56:04,512 - INFO -   - Total rows: 514
2024-12-18 10:56:04,513 - INFO -   - Columns: 25
2024-12-18 10:56:04,612 - INFO - Processed 285 records from ACL Monthly Report 15.05.23.xlsx
2024-12-18 10:56:04,614 - INFO - Processing file: ACL Monthly Report 16.10.23.xlsx
2024-12-18 10:56:04,932 - WARNING - Found columns with all null values in ACL Monthly Report 16.10.23.xlsx: ['Contract Type']
2024-12-18 10:56:04,934 - WARNING - Found columns with >90% null values in ACL Monthly Report 16.10.23.xlsx: ['Contract Type', 'Review Date']
2024-12-18 10:56:04,934 - INFO - Data validation for ACL Monthly Report 16.10.23.xlsx:
2024-12-18 10:56:04,934 - INFO -   - Total rows: 526
2024-12-18 10:56:04,934 - INFO -   - Columns: 25
2024-12-18 10:56:05,001 - INFO - Processed 299 records from ACL Monthly Report 16.10.23.xlsx
2024-12-18 10:56:05,001 - INFO - Processing file: ACL Monthly Report 17.04.23.xlsx
2024-12-18 10:56:05,329 - WARNING - Found columns with all null values in ACL Monthly Report 17.04.23.xlsx: ['Contract Type']
2024-12-18 10:56:05,333 - WARNING - Found columns with >90% null values in ACL Monthly Report 17.04.23.xlsx: ['Contract Type', 'Review Date']
2024-12-18 10:56:05,334 - INFO - Data validation for ACL Monthly Report 17.04.23.xlsx:
2024-12-18 10:56:05,334 - INFO -   - Total rows: 516
2024-12-18 10:56:05,335 - INFO -   - Columns: 25
2024-12-18 10:56:05,415 - INFO - Processed 284 records from ACL Monthly Report 17.04.23.xlsx
2024-12-18 10:56:05,426 - INFO - Processing file: ACL Monthly Report 17.07.23.xlsx
2024-12-18 10:56:05,763 - WARNING - Found columns with all null values in ACL Monthly Report 17.07.23.xlsx: ['Contract Type']
2024-12-18 10:56:05,763 - WARNING - Found columns with >90% null values in ACL Monthly Report 17.07.23.xlsx: ['Contract Type', 'Review Date']
2024-12-18 10:56:05,763 - INFO - Data validation for ACL Monthly Report 17.07.23.xlsx:
2024-12-18 10:56:05,777 - INFO -   - Total rows: 528
2024-12-18 10:56:05,779 - INFO -   - Columns: 25
2024-12-18 10:56:05,874 - INFO - Processed 298 records from ACL Monthly Report 17.07.23.xlsx
2024-12-18 10:56:05,876 - INFO - Processing file: ACL Monthly Report 18.03.24.xlsx
2024-12-18 10:56:06,181 - WARNING - Found columns with all null values in ACL Monthly Report 18.03.24.xlsx: ['Contract Type']
2024-12-18 10:56:06,181 - WARNING - Found columns with >90% null values in ACL Monthly Report 18.03.24.xlsx: ['Contract Type', 'Review Date']
2024-12-18 10:56:06,188 - INFO - Data validation for ACL Monthly Report 18.03.24.xlsx:
2024-12-18 10:56:06,188 - INFO -   - Total rows: 521
2024-12-18 10:56:06,192 - INFO -   - Columns: 25
2024-12-18 10:56:06,282 - INFO - Processed 299 records from ACL Monthly Report 18.03.24.xlsx
2024-12-18 10:56:06,289 - INFO - Processing file: ACL Monthly Report 18.09.23.xlsx
2024-12-18 10:56:06,568 - WARNING - Found columns with all null values in ACL Monthly Report 18.09.23.xlsx: ['Contract Type']
2024-12-18 10:56:06,568 - WARNING - Found columns with >90% null values in ACL Monthly Report 18.09.23.xlsx: ['Contract Type', 'Review Date']
2024-12-18 10:56:06,568 - INFO - Data validation for ACL Monthly Report 18.09.23.xlsx:
2024-12-18 10:56:06,575 - INFO -   - Total rows: 527
2024-12-18 10:56:06,575 - INFO -   - Columns: 25
2024-12-18 10:56:06,648 - INFO - Processed 297 records from ACL Monthly Report 18.09.23.xlsx
2024-12-18 10:56:06,648 - INFO - Processing file: ACL Monthly Report 18.12.23.xlsx
2024-12-18 10:56:06,781 - WARNING - Found columns with all null values in ACL Monthly Report 18.12.23.xlsx: ['Contract Type']
2024-12-18 10:56:06,790 - WARNING - Found columns with >90% null values in ACL Monthly Report 18.12.23.xlsx: ['Contract Type', 'Review Date']
2024-12-18 10:56:06,791 - INFO - Data validation for ACL Monthly Report 18.12.23.xlsx:
2024-12-18 10:56:06,793 - INFO -   - Total rows: 528
2024-12-18 10:56:06,794 - INFO -   - Columns: 25
2024-12-18 10:56:06,819 - INFO - Processed 300 records from ACL Monthly Report 18.12.23.xlsx
2024-12-18 10:56:06,819 - INFO - Processing file: ACL Monthly Report 19.02.24.xlsx
2024-12-18 10:56:07,002 - WARNING - Found columns with all null values in ACL Monthly Report 19.02.24.xlsx: ['Contract Type']
2024-12-18 10:56:07,004 - WARNING - Found columns with >90% null values in ACL Monthly Report 19.02.24.xlsx: ['Contract Type', 'Review Date']
2024-12-18 10:56:07,005 - INFO - Data validation for ACL Monthly Report 19.02.24.xlsx:
2024-12-18 10:56:07,006 - INFO -   - Total rows: 523
2024-12-18 10:56:07,007 - INFO -   - Columns: 25
2024-12-18 10:56:07,045 - INFO - Processed 302 records from ACL Monthly Report 19.02.24.xlsx
2024-12-18 10:56:07,047 - INFO - Processing file: ACL Monthly Report 19.06.23.xlsx
2024-12-18 10:56:07,242 - WARNING - Found columns with all null values in ACL Monthly Report 19.06.23.xlsx: ['Contract Type']
2024-12-18 10:56:07,244 - WARNING - Found columns with >90% null values in ACL Monthly Report 19.06.23.xlsx: ['Contract Type', 'Review Date']
2024-12-18 10:56:07,248 - INFO - Data validation for ACL Monthly Report 19.06.23.xlsx:
2024-12-18 10:56:07,249 - INFO -   - Total rows: 524
2024-12-18 10:56:07,250 - INFO -   - Columns: 25
2024-12-18 10:56:07,287 - INFO - Processed 293 records from ACL Monthly Report 19.06.23.xlsx
2024-12-18 10:56:07,287 - INFO - Processing file: ACL Monthly Report 20.11.23.xlsx
2024-12-18 10:56:07,525 - WARNING - Found columns with all null values in ACL Monthly Report 20.11.23.xlsx: ['Contract Type']
2024-12-18 10:56:07,536 - WARNING - Found columns with >90% null values in ACL Monthly Report 20.11.23.xlsx: ['Contract Type', 'Review Date']
2024-12-18 10:56:07,536 - INFO - Data validation for ACL Monthly Report 20.11.23.xlsx:
2024-12-18 10:56:07,536 - INFO -   - Total rows: 528
2024-12-18 10:56:07,536 - INFO -   - Columns: 25
2024-12-18 10:56:07,618 - INFO - Processed 301 records from ACL Monthly Report 20.11.23.xlsx
2024-12-18 10:56:07,618 - INFO - Processing file: ACL Monthly Report 21.08.23.xlsx
2024-12-18 10:56:07,895 - WARNING - Found columns with all null values in ACL Monthly Report 21.08.23.xlsx: ['Contract Type']
2024-12-18 10:56:07,899 - WARNING - Found columns with >90% null values in ACL Monthly Report 21.08.23.xlsx: ['Contract Type', 'Review Date']
2024-12-18 10:56:07,901 - INFO - Data validation for ACL Monthly Report 21.08.23.xlsx:
2024-12-18 10:56:07,904 - INFO -   - Total rows: 528
2024-12-18 10:56:07,905 - INFO -   - Columns: 25
2024-12-18 10:56:07,952 - INFO - Processed 300 records from ACL Monthly Report 21.08.23.xlsx
2024-12-18 10:56:07,966 - INFO - Starting contract change tracking...
2024-12-18 10:56:08,610 - INFO - Processed contract changes for 339 staff members
2024-12-18 10:56:08,610 - INFO - Found 0 staff with multiple contracts
2024-12-18 10:56:09,556 - INFO - Data validation for final_staff_data:
2024-12-18 10:56:09,557 - INFO -   - Total rows: 3557
2024-12-18 10:56:09,558 - INFO -   - Columns: 9
2024-12-18 10:56:09,560 - INFO - Monthly reports processing completed!
2024-12-18 10:56:09,560 - INFO - Processed data for 339 staff members
2024-12-18 10:56:09,560 - INFO - Generated 4081 contract records
2024-12-18 10:56:09,654 - INFO - 
Step 2: Processing Tutor Pay Report
2024-12-18 10:56:09,656 - INFO - Processing Tutor Pay Report...
2024-12-18 10:56:21,925 - INFO - Data validation for tutor_pay_report:
2024-12-18 10:56:21,925 - INFO -   - Total rows: 51214
2024-12-18 10:56:21,925 - INFO -   - Columns: 23
2024-12-18 10:56:21,951 - INFO -   - Potential Hours: 1 null values (0.0%)
2024-12-18 10:56:23,333 - WARNING - Found invalid staff roles: ['Facilitator' 'Curriculum Manager' 'Senior Management' 'Volunteer'
 'Operational']
2024-12-18 10:56:23,392 - INFO - Calculating actual hours...
2024-12-18 10:56:24,436 - WARNING - Found 14468 entries with zero actual hours
2024-12-18 10:56:24,472 - INFO - Categorizing activities...
2024-12-18 10:56:25,447 - INFO - Creating monthly summaries...
2024-12-18 10:56:25,482 - INFO - Adding contract information...
2024-12-18 10:56:31,532 - INFO - Calculating monthly utilization...
2024-12-18 10:56:33,907 - INFO - Creating additional summaries...
2024-12-18 10:56:34,127 - INFO - Tutor pay report processing completed!
2024-12-18 10:56:34,282 - INFO - Saved daily_summary to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\daily_summary.csv
2024-12-18 10:56:34,337 - INFO - Saved weekly_summary to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\weekly_summary.csv
2024-12-18 10:56:34,383 - INFO - Saved monthly_summary to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\monthly_summary.csv
2024-12-18 10:56:34,422 - INFO - Saved venue_summary to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\venue_summary.csv
2024-12-18 10:56:34,451 - INFO - Saved curriculum_summary to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\curriculum_summary.csv
2024-12-18 10:56:34,957 - INFO - Saved detailed_data to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\detailed_data.csv
2024-12-18 10:56:34,958 - INFO - 
Step 3: Processing Qualification Data
2024-12-18 10:56:34,959 - INFO - Processing qualification lists...
2024-12-18 10:56:41,164 - INFO - Data validation for approved_qualifications:
2024-12-18 10:56:41,166 - INFO -   - Total rows: 8201
2024-12-18 10:56:41,166 - INFO -   - Columns: 3
2024-12-18 10:56:41,176 - INFO - Data validation for archived_qualifications:
2024-12-18 10:56:41,177 - INFO -   - Total rows: 8852
2024-12-18 10:56:41,177 - INFO -   - Columns: 3
2024-12-18 10:56:41,248 - INFO - Processed 17053 unique qualifications:
2024-12-18 10:56:41,254 - INFO -   - Approved: 8201
2024-12-18 10:56:41,276 - INFO -   - Archived: 8852
2024-12-18 10:56:41,288 - INFO - Processing Terms caseloading data...
2024-12-18 10:57:22,422 - INFO - Adding contract information...
2024-12-18 10:57:49,425 - INFO - Calculating monthly learner counts...
2024-12-18 10:57:49,484 - INFO - Creating summary dataframes...
2024-12-18 10:57:49,621 - INFO - Terms caseloading processing completed!
2024-12-18 10:57:50,303 - INFO - Saved terms_detailed to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\terms_detailed.csv
2024-12-18 10:57:50,307 - INFO - Saved learner_summary to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\learner_summary.csv
2024-12-18 10:57:50,369 - INFO - Saved qualification_summary to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\qualification_summary.csv
2024-12-18 10:57:50,389 - INFO - Saved level_summary to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\level_summary.csv
2024-12-18 10:57:50,404 - INFO - Saved activity_summary to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\activity_summary.csv
2024-12-18 10:57:50,472 - INFO - Saved qualification_reference to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\qualification_reference.csv
2024-12-18 10:57:50,472 - INFO - 
Step 4: Processing PICS Data
2024-12-18 10:57:50,472 - INFO - Processing PICS data...
2024-12-18 10:57:50,472 - INFO - Reading hours lookup data...
2024-12-18 10:57:50,521 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,522 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,524 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,525 - WARNING - Error converting time value 03:12:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,526 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,526 - WARNING - Error converting time value 03:12:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,526 - WARNING - Error converting time value 03:12:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,527 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,528 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,529 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,529 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,530 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,531 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,533 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,533 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,534 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,535 - WARNING - Error converting time value 03:12:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,536 - WARNING - Error converting time value 03:12:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,537 - WARNING - Error converting time value 03:12:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,537 - WARNING - Error converting time value 03:12:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,538 - WARNING - Error converting time value 03:12:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,539 - WARNING - Error converting time value 03:12:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,540 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,541 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,542 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,543 - WARNING - Error converting time value 02:48:00: float() argument must be a string or a real number, not 'datetime.time'
2024-12-18 10:57:50,544 - WARNING - Found 26 entries with zero hours in lookup
2024-12-18 10:57:50,545 - WARNING - Zero-hour entries:
2024-12-18 10:57:50,547 - WARNING -   Accounts or Finance Assistant: 02:48:00
2024-12-18 10:57:50,548 - WARNING -   Adult Care Worker: 02:48:00
2024-12-18 10:57:50,549 - WARNING -   Assistant Accountant: 02:48:00
2024-12-18 10:57:50,550 - WARNING -   Associate Project Manager: 03:12:00
2024-12-18 10:57:50,550 - WARNING -   Business Administrator: 02:48:00
2024-12-18 10:57:50,551 - WARNING -   Children, Young People and Families Practitioner: 03:12:00
2024-12-18 10:57:50,552 - WARNING -   Coaching Professional: 03:12:00
2024-12-18 10:57:50,552 - WARNING -   Customer Service Practitioner: 02:48:00
2024-12-18 10:57:50,553 - WARNING -   Customer Service Specialist: 02:48:00
2024-12-18 10:57:50,553 - WARNING -   Cyber Security Technician: 02:48:00
2024-12-18 10:57:50,554 - WARNING -   Early Years Educator: 02:48:00
2024-12-18 10:57:50,555 - WARNING -   Early Years Practitioner: 02:48:00
2024-12-18 10:57:50,556 - WARNING -   Facilities Services Operative: 02:48:00
2024-12-18 10:57:50,557 - WARNING -   Healthcare Support Worker: 02:48:00
2024-12-18 10:57:50,558 - WARNING -   IT Solutions Technician: 02:48:00
2024-12-18 10:57:50,559 - WARNING -   Lead Adult Care Worker: 02:48:00
2024-12-18 10:57:50,560 - WARNING -   Lead Practitioner in Adult Care: 03:12:00
2024-12-18 10:57:50,561 - WARNING -   Leader in Adult Care: 03:12:00
2024-12-18 10:57:50,562 - WARNING -   Learning and Skills Mentor: 03:12:00
2024-12-18 10:57:50,566 - WARNING -   Operations Manager: 03:12:00
2024-12-18 10:57:50,567 - WARNING -   Professional Accounting or Taxation Technician: 03:12:00
2024-12-18 10:57:50,570 - WARNING -   School Business Professional: 03:12:00
2024-12-18 10:57:50,571 - WARNING -   Senior Healthcare Support Worker: 02:48:00
2024-12-18 10:57:50,572 - WARNING -   Supply Chain Warehouse Operative: 02:48:00
2024-12-18 10:57:50,573 - WARNING -   Teaching Assistant: 02:48:00
2024-12-18 10:57:50,574 - WARNING -   Team Leader: 02:48:00
2024-12-18 10:57:50,576 - INFO - Processed 26 standard titles with hours
2024-12-18 10:57:50,577 - INFO - Reading PICS caseload data...
2024-12-18 10:57:50,688 - WARNING - Found 233 invalid dates in Achieved_Date
2024-12-18 10:57:50,693 - WARNING - Found 112 invalid dates in Actual_End
2024-12-18 10:57:50,702 - INFO - Generating monthly snapshots...
2024-12-18 10:57:50,703 - INFO - Processing month: April 2023
2024-12-18 10:57:51,021 - INFO - Active students in April 2023: 251
2024-12-18 10:57:51,021 - INFO - Processing month: May 2023
2024-12-18 10:57:51,324 - INFO - Active students in May 2023: 240
2024-12-18 10:57:51,324 - INFO - Processing month: June 2023
2024-12-18 10:57:51,754 - INFO - Active students in June 2023: 226
2024-12-18 10:57:51,756 - INFO - Processing month: July 2023
2024-12-18 10:57:52,032 - INFO - Active students in July 2023: 223
2024-12-18 10:57:52,032 - INFO - Processing month: August 2023
2024-12-18 10:57:52,320 - INFO - Active students in August 2023: 220
2024-12-18 10:57:52,321 - INFO - Processing month: September 2023
2024-12-18 10:57:52,688 - INFO - Active students in September 2023: 202
2024-12-18 10:57:52,688 - INFO - Processing month: October 2023
2024-12-18 10:57:52,975 - INFO - Active students in October 2023: 211
2024-12-18 10:57:52,975 - INFO - Processing month: November 2023
2024-12-18 10:57:53,215 - INFO - Active students in November 2023: 207
2024-12-18 10:57:53,217 - INFO - Processing month: December 2023
2024-12-18 10:57:53,493 - INFO - Active students in December 2023: 204
2024-12-18 10:57:53,501 - INFO - Processing month: January 2024
2024-12-18 10:57:53,728 - INFO - Active students in January 2024: 194
2024-12-18 10:57:53,728 - INFO - Processing month: February 2024
2024-12-18 10:57:53,942 - INFO - Active students in February 2024: 184
2024-12-18 10:57:53,943 - INFO - Processing month: March 2024
2024-12-18 10:57:54,156 - INFO - Active students in March 2024: 185
C:\Users\mayur.kripalani\AppData\Local\Temp\ipykernel_18756\3007021869.py:174: FutureWarning: The behavior of DataFrame concatenation with empty or all-NA entries is deprecated. In a future version, this will no longer exclude empty or all-NA columns when determining the result dtypes. To retain the old behavior, exclude the relevant entries before the concat operation.
  monthly_df = pd.concat(monthly_data, ignore_index=True)
2024-12-18 10:57:54,169 - INFO - Creating summary views...
2024-12-18 10:57:54,185 - INFO - PICS data processing completed!
2024-12-18 10:57:54,207 - INFO - Saved detailed_monthly to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\pics_detailed_monthly.csv
2024-12-18 10:57:54,238 - INFO - Saved monthly_summary to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\pics_monthly_summary.csv
2024-12-18 10:57:54,238 - INFO - Saved programme_summary to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\pics_programme_summary.csv
2024-12-18 10:57:54,248 - INFO - Saved standard_summary to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\pics_standard_summary.csv
2024-12-18 10:57:54,248 - INFO - Saved hours_reference to C:\Users\mayur.kripalani\Downloads\Staff Utilisation\Employee reports FY 2324\New\Staff Utilisation\processed_data\pics_hours_reference.csv
2024-12-18 10:57:54,254 - INFO - 
All processing completed successfully!