O02
user_1718919
plain_text
4 months ago
23 kB
3
Indexable
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!
Editor is loading...
Leave a Comment