-
Notifications
You must be signed in to change notification settings - Fork 2
Number Checker
echang97 edited this page Jul 29, 2019
·
5 revisions
| Function Name | Description |
|---|---|
| get_prefix(name) | Returns a String determined by keywords in name |
| get_num_col(df) | Returns 'Revenues' if present. Else return last column of df |
| get_sd(grouped_df, sd) | Returns standard deviation for each GroupBy object |
| make_config_path() | Creates folder 'num-conifg' if not present |
| print_cols(df) | Prints out a list of columns in df excluding the last column |
| get_col_input(df) | Prompts user to input columns to group by. Returns input |
| write_config(df, prefix) | Writes Groups and GroupBy Dictionary in a json file |
| update_config(df, prefix) | Changes GroupBy Dictionary based on Groups in json file |
| Function Name | Description |
|---|---|
| read_config(prefix) | Reads a json file based on prefix and returns groups and SD-dictionary |
| check_threshold(df, prefix) | Creates GroupBy Object and compares values to SD-Dictionary |
| set_groups(df, prefix) | Returns list of columns and SD-Dictionary based on json file. Will create json if not found |
| write_export(df, cells, pathname) | Writes an Excel file with outstanding values highlighted in red |