otld.append.append_2015_2023.get_tanf_df

otld.append.append_2015_2023.get_tanf_df(tanf_path: str | PathLike, sheet: str, year: int, column_dict: dict, level: str) → DataFrame

Extract TANF data from Excel file

Args:

tanf_path (str | os.PathLike): Path to TANF Excel file sheet (str): Sheet name to extract data from year (int): Year of data column_dict (dict): Dictionary mapping line numbers to field names. level (str): Level of data: “State” or “Federal”.

Returns:

pd.DataFrame: Extracted TANF data