otld.utils.caseload_utils.process_sheet

otld.utils.caseload_utils.process_sheet(file_path: str, sheet_name: str, column_names: List[str], year: int) → DataFrame | None

Load caseload worksheet

Args:

file_path (str): Path to caseload workbook sheet_name (str): Sheet to load skiprows (int): Number of rows to skip column_names (List[str]): Names to assign to columns year (int): Fiscal year associated with caseload data

Returns:

Optional[pd.DataFrame]: Data frame