otld.utils.caseload_utils.format_final_dataset

otld.utils.caseload_utils.format_final_dataset(df: DataFrame, output_columns: List[str] = ['FiscalYear', 'State', 'Total Families', 'Two Parent Families', 'One Parent Families', 'No Parent Families', 'Total Recipients', 'Adult Recipients', 'Children Recipients']) → DataFrame

Format dataset

This function performs the following actions:

• Generate columns as NaN if missing

• Format fiscal year as in integer

• Add commas to numeric columns

• Convert column names to title case

Args:

df (pd.DataFrame): Data frame to format output_columns (List[str]): Columns to include in final dataset

Returns:

pd.DataFrame: Formatted data frame