Outc2

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