otld.append.caseload.process_workbook

otld.append.caseload.process_workbook(file_path: str, data_type: str, year: int, master_wide: DataFrame) → DataFrame

Extract and transform caseload data from Excel file

Args:

file_path (str): Path to caseload data data_type (str): Funding level of data (State, Federal, Total) year (int): The fiscal year associated with the caseload data. master_wide (pd.DataFrame): Wide data frame to append new records to

Raises:

FileNotFoundError: Raise a FileNotFoundError if the target file does not exist. AttributeError: Raise an AttributeError if either the families or recipients tab cannot be found.

Returns:

pd.DataFrame: Concatenated data frame.