Outc2
user_1718919
plain_text
4 months ago
3.7 kB
3
Indexable
Current working directory: C:\Users\mayur.kripalani\Downloads\Staff Utilisation\FreshStart\Staff Utilisation Files in current directory: - .ipynb_checkpoints - monthly_reports - processed_data - process_tutor_data.ipynb - TutorPayReport_New 23.24 FY 22.11.24.xlsx Reading tutor report from: TutorPayReport_New 23.24 FY 22.11.24.xlsx Reading staff data from: processed_data\staff_monthly_data.csv Tutor report shape: (51214, 23) Sample of PEOPLENAME and PEOPLESURNAME: PEOPLENAME PEOPLESURNAME 0 Sheila Hilliard ... 1 Jane Jones ... 2 Sian Lewis ... 3 Sian Lewis ... 4 Sheila Hilliard ... Staff data shape: (3557, 11) Sample of staff names: Staff_Standard 0 Abbie Cairns 1 Abbie Jones 2 Adele Roberts 3 Aida Alonso Triguero 4 Aida Alonso Triguero Total unique staff in monthly_summary: 0 Total staff processed with data: 0 ERROR: No staff data was processed. Checking data: Staff data shape: (3557, 11) First few rows of staff_df: Assignment Number Staff_Standard Staff_Known_As \ 0 E1020023267 Abbie Cairns Abbie, Cairns 1 E1020028627 Abbie Jones Abbie, Jones 2 E1020007305 Adele Roberts Adele, Roberts 3 E1020021903 Aida Alonso Triguero Aida, Alonso Triguero 4 E1020021903-2 Aida Alonso Triguero Aida, Alonso Triguero Position Name Contract_Type Target_Hours Manager_Standard \ 0 Tutor Sessional 1.306254 Julie Kane 1 Tutor Salaried 840.000000 Emma Hodgkinson 2 Tutor Sessional 1.306254 Caron Muldoon 3 Tutor Salaried 209.997823 Carmen Griffith 4 Tutor Salaried 420.000000 Sonia Clark Manager_Known_As Report_Date Previous_Contract Contract_Changed 0 Julie, Kane 2023-04-17 NaN True 1 Emma, Hodgkinson 2023-04-17 NaN True 2 Caron, Muldoon 2023-04-17 NaN True 3 Carmen, Griffith 2023-04-17 NaN True 4 Sonia, Clark 2023-04-17 Salaried False First few rows of monthly_summary: Empty DataFrame Columns: [Staff_Standard, Year, Month, Activity_Category, Actual_Hours] Index: [] --------------------------------------------------------------------------- ValueError Traceback (most recent call last) Cell In[1], line 186 183 exit() 185 # Process the data --> 186 processed_data = process_tutor_report(input_file, staff_data) 188 # Save the results 189 save_processed_data(processed_data, output_folder) Cell In[1], line 139, in process_tutor_report(file_path, staff_data_path) 137 print("\nFirst few rows of monthly_summary:") 138 print(monthly_summary.head()) --> 139 raise ValueError("No data to process - check the debug output above") 141 monthly_summary_with_utilization = pd.concat(monthly_utilization) 143 return { 144 'daily_summary': daily_summary, 145 'weekly_summary': weekly_summary, 146 'monthly_summary': monthly_summary_with_utilization, 147 'detailed_data': df 148 } ValueError: No data to process - check the debug output above
Editor is loading...
Leave a Comment