otld.utils.caseload_utils

Utilities to support caseload.py

Functions

analyze_ambiguous_values(df)

Display ambiguous values in data frame (0, -, blank)

analyze_guam_data(df)

Extract and analyze Guam's data

clean_dataset(df)

Clean dataset

clean_state(state)

Clean up state names

extract_missing_average(path, average[, ...])

format_final_dataset(df[, output_columns])

Format dataset

merge_datasets(families_df, recipients_df, year)

Merge families and recipients datasets

process_1997_1998_1999_data(year, df, ...)

Process data for years 1997-1999, preserving original value representations.

process_sheet(file_path, sheet_name, ...)

Load caseload worksheet