Index

A

add_google_sheet_comment() (fusetools.gsuite_tools.GSheets class method) add_google_sheet_tab() (fusetools.gsuite_tools.GSheets class method) api_request() (fusetools.commerce_tools.Discogs class method) AppAnnie (class in fusetools.marketing_tools) append_window_agg() (fusetools.analytics_tools.Pandas class method)

Asana (class in fusetools.pm_tools) auth() (fusetools.music_tools.Spotify class method) auth_tableau_server() (fusetools.dashboard_tools.Tableau class method) authorize_credentials() (fusetools.gsuite_tools.GDrive class method) (fusetools.marketing_tools.GoogleAnalytics static method)

B

bea_gdp() (fusetools.research_tools.Economics class method) bitly_url_shortener() (in module fusetools.web_tools) Blob (class in fusetools.text_tools) bls_query() (fusetools.research_tools.Economics class method)

bls_query_lookup() (fusetools.research_tools.Economics class method) build_html() (in module fusetools.comm_tools) bulk_add_google_sheet_comment() (fusetools.gsuite_tools.GSheets class method) bulk_update_cell_background_color() (fusetools.gsuite_tools.GSheets class method)

C

calculate_distance() (fusetools.research_tools.Geography class method) chi_squared_result() (fusetools.stat_tools.Test class method) con_oracle() (fusetools.db_conn_tools.Oracle class method) con_postgres() (fusetools.db_conn_tools.Postgres class method) concat_text_files() (fusetools.text_tools.Export class method) conn_pyodbc() (fusetools.db_conn_tools.TeraData class method) conn_rs_pg() (fusetools.db_conn_tools.Redshift class method) conn_rs_sa() (fusetools.db_conn_tools.Redshift class method) conn_sa() (fusetools.db_conn_tools.TeraData class method)

conn_td() (fusetools.db_conn_tools.TeraData class method) correlation() (fusetools.stat_tools.Test class method) cramers_corrected_stat() (fusetools.stat_tools.Test class method) create_service() (fusetools.gsuite_tools.GMail class method) create_service_serv_acct() (fusetools.gsuite_tools.GDrive class method) (fusetools.gsuite_tools.GMail class method) (fusetools.gsuite_tools.GSheets class method) create_task() (fusetools.pm_tools.Asana class method) create_upload_folder() (fusetools.gsuite_tools.GDrive class method)

D

db_apply_schema() (fusetools.db_etl_tools.Generic class method) delete_google_sheet_data() (fusetools.gsuite_tools.GSheets class method) delete_google_sheet_tab() (fusetools.gsuite_tools.GSheets class method) Desc (class in fusetools.stat_tools) Discogs (class in fusetools.commerce_tools)

dist_plot() (fusetools.stat_tools.Viz class method) download_email_attachment() (fusetools.gsuite_tools.GMail class method) download_file() (fusetools.gsuite_tools.GDrive class method) drop_duplicates() (fusetools.gsuite_tools.GSheets class method) dump_json() (fusetools.text_tools.Export class method) dump_sql() (fusetools.text_tools.Export class method)

E

Economics (class in fusetools.research_tools) eng_mysql() (fusetools.db_conn_tools.MySQL class method) eng_oracle() (fusetools.db_conn_tools.Oracle class method)

eng_oracle_addr() (fusetools.db_conn_tools.Oracle class method) eng_postgres() (fusetools.db_conn_tools.Postgres class method) Export (class in fusetools.text_tools)

F

filter() (fusetools.logging_tools.IgnoreThreadsFilter method) (fusetools.logging_tools.ThreadFilter method) find_na_holder() (fusetools.analytics_tools.Pandas class method) find_replace_text() (fusetools.text_tools.Export class method) freeze_rows_cols() (fusetools.gsuite_tools.GSheets class method) fusetools module fusetools.analytics_tools module fusetools.comm_tools module fusetools.commerce_tools module fusetools.dashboard_tools module fusetools.date_tools module fusetools.db_conn_tools module fusetools.db_etl_tools module

fusetools.gsuite_tools module fusetools.home_tools module fusetools.logging_tools module fusetools.marketing_tools module fusetools.ml_tools module fusetools.music_tools module fusetools.pm_tools module fusetools.research_tools module fusetools.stat_tools module fusetools.text_tools module fusetools.web_tools module

G

ga_pull_metrics() (fusetools.marketing_tools.GoogleAnalytics class method) GDrive (class in fusetools.gsuite_tools) Generic (class in fusetools.db_etl_tools) Geography (class in fusetools.research_tools) get_all_google_items() (fusetools.gsuite_tools.GDrive class method) get_all_sever_items() (fusetools.dashboard_tools.Tableau class method) get_authentication_token() (fusetools.commerce_tools.Discogs class method) get_chrome_history() (in module fusetools.web_tools) get_city_lat_lon() (fusetools.research_tools.Geography class method) get_emails() (fusetools.gsuite_tools.GMail class method) get_file_revisions() (fusetools.gsuite_tools.GDrive class method) get_google_sheet() (fusetools.gsuite_tools.GSheets class method) get_google_sheet_metadata() (fusetools.gsuite_tools.GSheets class method) get_google_sheet_tabs() (fusetools.gsuite_tools.GSheets class method) get_last_dow() (in module fusetools.date_tools) get_mailbox_labels() (fusetools.gsuite_tools.GMail class method) get_messages() (fusetools.comm_tools.Twilio class method)

get_oracle_date() (fusetools.db_etl_tools.Oracle class method) get_orcl_date() (fusetools.db_etl_tools.Oracle class method) get_playlist_tracks() (fusetools.music_tools.Spotify class method) get_project_tasks() (fusetools.pm_tools.Asana class method) get_rptg_mon() (in module fusetools.date_tools) get_rptg_qtr() (in module fusetools.date_tools) get_rptg_week() (in module fusetools.date_tools) get_rptg_yr() (in module fusetools.date_tools) get_tableau_server_obj_id() (fusetools.dashboard_tools.Tableau class method) get_task_detail() (fusetools.pm_tools.Asana class method) get_track_audio_features() (fusetools.music_tools.Spotify class method) get_user_playlists() (fusetools.music_tools.Spotify class method) GMail (class in fusetools.gsuite_tools) GoogleAnalytics (class in fusetools.marketing_tools) group_sheet_cols_rows() (fusetools.gsuite_tools.GSheets class method) group_stats() (fusetools.stat_tools.Desc class method) GSheets (class in fusetools.gsuite_tools)

I

IgnoreThreadsFilter (class in fusetools.logging_tools) insert_df_pg() (fusetools.db_etl_tools.Postgres class method) insert_df_rs() (fusetools.db_etl_tools.Redshift class method) insert_exec() (fusetools.db_etl_tools.Oracle class method)

insert_tbl() (fusetools.db_etl_tools.Oracle class method) insert_td() (fusetools.db_etl_tools.Teradata class method) insert_val_pg() (fusetools.db_etl_tools.Postgres class method) insert_val_rs() (fusetools.db_etl_tools.Redshift class method)

L

label_encode_df() (fusetools.ml_tools.Prep class method) log_all() (in module fusetools.logging_tools)

log_all_thread() (in module fusetools.logging_tools) log_setup() (in module fusetools.logging_tools) log_tbl_df() (in module fusetools.logging_tools)

M

make_db_cols() (fusetools.db_etl_tools.Generic class method) make_db_schema() (fusetools.db_etl_tools.Generic class method) make_df_tbl_pg() (fusetools.db_etl_tools.Postgres class method) make_df_tbl_rs() (fusetools.db_etl_tools.Redshift class method) make_google_sheet() (fusetools.gsuite_tools.GSheets class method) make_groupby() (fusetools.db_etl_tools.Generic class method) make_model_feature_df() (fusetools.ml_tools.Prep class method) make_plot_tbl() (fusetools.stat_tools.Viz class method) make_plotting_tbl() (fusetools.stat_tools.Viz class method) make_script_function() (in module fusetools.logging_tools) make_tableau_datasource_schema() (fusetools.dashboard_tools.Tableau class method) make_tableau_hyperfile() (fusetools.dashboard_tools.Tableau class method) make_tbl() (fusetools.db_etl_tools.Oracle class method) (fusetools.stat_tools.Desc class method) make_tbl_complete() (fusetools.db_etl_tools.Oracle class method) make_tbl_complete_force() (fusetools.db_etl_tools.Oracle class method) make_tbl_complete_pg() (fusetools.db_etl_tools.Postgres class method) make_tbl_complete_rs() (fusetools.db_etl_tools.Redshift class method) make_tbl_complete_td() (fusetools.db_etl_tools.Teradata class method) make_tbl_td() (fusetools.db_etl_tools.Teradata class method)

module fusetools fusetools.analytics_tools fusetools.comm_tools fusetools.commerce_tools fusetools.dashboard_tools fusetools.date_tools fusetools.db_conn_tools fusetools.db_etl_tools fusetools.gsuite_tools fusetools.home_tools fusetools.logging_tools fusetools.marketing_tools fusetools.ml_tools fusetools.music_tools fusetools.pm_tools fusetools.research_tools fusetools.stat_tools fusetools.text_tools fusetools.web_tools MySQL (class in fusetools.db_conn_tools)

N

Nest (class in fusetools.home_tools)

O

Oracle (class in fusetools.db_conn_tools) (class in fusetools.db_etl_tools)

orcl_tbl_varchar_convert() (fusetools.db_etl_tools.Oracle class method)

P

Pandas (class in fusetools.analytics_tools) pe() (fusetools.stat_tools.Test class method) period_comp() (fusetools.analytics_tools.Pandas class method) period_start_dt() (fusetools.analytics_tools.Pandas class method) poisson() (fusetools.stat_tools.Test class method) Postgres (class in fusetools.db_conn_tools) (class in fusetools.db_etl_tools)

Prep (class in fusetools.ml_tools) ptd_measure() (fusetools.analytics_tools.Pandas class method) pull_metrics() (fusetools.marketing_tools.AppAnnie class method) pull_tasks_for_project() (fusetools.pm_tools.Asana class method) push_tableau_hyperfile() (fusetools.dashboard_tools.Tableau class method)

R

Redshift (class in fusetools.db_conn_tools) (class in fusetools.db_etl_tools) run_query() (fusetools.db_etl_tools.Generic class method)

run_query_pg() (fusetools.db_etl_tools.Postgres class method) run_query_rs() (fusetools.db_etl_tools.Redshift class method) run_query_td() (fusetools.db_etl_tools.Teradata class method)

S

sample_size1() (fusetools.stat_tools.Test class method) send_email() (fusetools.comm_tools.SendGrid class method) (fusetools.gsuite_tools.GMail class method) send_message() (fusetools.comm_tools.Twilio class method) (fusetools.comm_tools.WhatsApp class method) SendGrid (class in fusetools.comm_tools) sequential_load_pg() (fusetools.db_etl_tools.Postgres class method) sequential_load_pg_wk() (fusetools.db_etl_tools.Postgres class method) sequential_load_rs() (fusetools.db_etl_tools.Redshift class method)

sequential_load_rs_wk() (fusetools.db_etl_tools.Redshift class method) show_clf_perf() (fusetools.ml_tools.Viz class method) show_clf_perf_features() (fusetools.ml_tools.Viz class method) show_model_results() (fusetools.ml_tools.Viz class method) Spotify (class in fusetools.music_tools) SQL (class in fusetools.analytics_tools) sql_rs_wow_comp() (fusetools.analytics_tools.SQL class method) sql_rs_yoy_cum_comp() (fusetools.analytics_tools.SQL class method) survival_result() (fusetools.stat_tools.Test class method)

T

Tableau (class in fusetools.dashboard_tools) TeraData (class in fusetools.db_conn_tools) Teradata (class in fusetools.db_etl_tools) Test (class in fusetools.stat_tools) text_parse() (fusetools.text_tools.Blob class method)

ThreadFilter (class in fusetools.logging_tools) Train (class in fusetools.ml_tools) train_model() (fusetools.ml_tools.Train class method) ttest() (fusetools.stat_tools.Test class method) ttest_result() (fusetools.stat_tools.Test class method) Twilio (class in fusetools.comm_tools)

U

update_cell_background_color() (fusetools.gsuite_tools.GSheets class method) update_google_sheet_df() (fusetools.gsuite_tools.GSheets class method) update_google_sheet_val() (fusetools.gsuite_tools.GSheets class method)

upload_files() (fusetools.gsuite_tools.GDrive class method) upsert_tbl_pg() (fusetools.db_etl_tools.Postgres class method) upsert_tbl_rs() (fusetools.db_etl_tools.Redshift class method) upsert_val_pg() (fusetools.db_etl_tools.Postgres class method)

V

Viz (class in fusetools.ml_tools) (class in fusetools.stat_tools)

W

walk_bike_transit_score() (fusetools.research_tools.Geography class method) wf_login() (fusetools.pm_tools.Workfront class method) wf_pull_issues_custom_field() (fusetools.pm_tools.Workfront class method) wf_pull_projects_custom_field() (fusetools.pm_tools.Workfront class method) wf_pull_projects_status() (fusetools.pm_tools.Workfront class method)

wf_pull_tasks_name() (fusetools.pm_tools.Workfront class method) wf_pull_tasks_status() (fusetools.pm_tools.Workfront class method) wf_upload_file() (fusetools.pm_tools.Workfront class method) WhatsApp (class in fusetools.comm_tools) Workfront (class in fusetools.pm_tools)

Y

yoy_comp() (fusetools.analytics_tools.Pandas class method)