Index

A

ask_directory_path() (in module datasense.munging) ask_open_file_name_path() (in module datasense.munging) ask_save_as_file_name_path() (in module datasense.munging) autofit_column_width() (in module datasense.pyxl) average_chart() (datasense.msa.MSA method) average_in_control() (datasense.msa.MSA method)

average_out_of_control_reason() (datasense.msa.MSA method) ax() (datasense.control_charts.ControlChart method) (datasense.control_charts.mR method) (datasense.control_charts.R method) (datasense.control_charts.X method) (datasense.control_charts.Xbar method)

B

byte_size() (in module datasense.munging)

C

cell_fill_down() (in module datasense.pyxl) cell_style() (in module datasense.pyxl) change_case_worksheet_columns() (in module datasense.pyxl) classification() (datasense.msa.MSA method) ControlChart (class in datasense.control_charts) convert_csv_to_feather() (in module datasense.munging) convert_seconds_to_hh_mm_ss() (in module datasense.munging)

copy_directory() (in module datasense.munging) cp() (in module datasense.process_capability) cpk() (in module datasense.process_capability) cpm() (in module datasense.process_capability) create_dataframe() (in module datasense.munging) create_dataframe_norm() (in module datasense.munging) create_directory() (in module datasense.munging) cubic_spline() (in module datasense.stats)

D

dataframe_info() (in module datasense.munging) datasense.automation module datasense.control_charts module datasense.graphs module datasense.html_ds module datasense.msa module datasense.munging module datasense.process_capability module datasense.pyxl module datasense.rgx module

datasense.sequel module datasense.stats module datasense.taguchi module datetime_data() (in module datasense.stats) dd_to_dms() (in module datasense.graphs) delete_columns() (in module datasense.munging) delete_directory() (in module datasense.munging) delete_empty_columns() (in module datasense.munging) delete_empty_rows() (in module datasense.munging) delete_list_files() (in module datasense.munging) delete_rows() (in module datasense.munging) despine() (in module datasense.graphs) directory_file_print() (in module datasense.munging) dms_to_dd() (in module datasense.graphs) draw_rule() (in module datasense.control_charts) draw_rules() (in module datasense.control_charts)

E

effective_resolution() (datasense.msa.MSA method) empirical_cdf() (in module datasense.graphs)

exit_script() (in module datasense.pyxl) explore_functions() (in module datasense.html_ds)

F

fahrenheit_to_celsius_table() (in module datasense.automation) feature_percent_empty() (in module datasense.munging) file_size() (in module datasense.munging) find_bool_columns() (in module datasense.munging) find_category_columns() (in module datasense.munging) find_datetime_columns() (in module datasense.munging)

find_float_columns() (in module datasense.munging) find_int_float_columns() (in module datasense.munging) find_integer_columns() (in module datasense.munging) find_object_columns() (in module datasense.munging) find_timedelta_columns() (in module datasense.munging) format_dates() (in module datasense.graphs)

G

get_mtime() (in module datasense.munging)

H

html_begin() (in module datasense.html_ds) html_end() (in module datasense.html_ds)

html_figure() (in module datasense.html_ds) html_footer() (in module datasense.html_ds) html_header() (in module datasense.html_ds)

I

interpret() (datasense.msa.MSA method)

interpret_tables() (datasense.msa.MSA method)

L

lcl (datasense.control_charts.ControlChart attribute) (datasense.control_charts.mR attribute) (datasense.control_charts.R attribute) (datasense.control_charts.X attribute) (datasense.control_charts.Xbar attribute) linear_regression() (in module datasense.stats) list_change_case() (in module datasense.munging) list_directories() (in module datasense.munging)

list_duplicate_worksheet_rows() (in module datasense.pyxl) list_empty_and_nan_worksheet_rows() (in module datasense.pyxl) list_empty_except_nan_worksheet_rows() (in module datasense.pyxl) list_files() (in module datasense.munging) list_nan_worksheet_rows() (in module datasense.pyxl) list_one_list_two_ops() (in module datasense.munging) list_rows_with_content() (in module datasense.pyxl) listone_contains_all_listtwo_substrings() (in module datasense.munging)

M

main_effects_chart_anome() (datasense.msa.MSA method) main_effects_in_control() (datasense.msa.MSA method) main_effects_out_of_control_reason() (datasense.msa.MSA method) mask_outliers() (in module datasense.munging) mean (datasense.control_charts.ControlChart attribute) (datasense.control_charts.mR attribute) (datasense.control_charts.R attribute) (datasense.control_charts.X attribute) (datasense.control_charts.Xbar attribute) mean_ranges_chart_anomr() (datasense.msa.MSA method) mean_ranges_in_control() (datasense.msa.MSA method) mean_ranges_out_of_control_reason() (datasense.msa.MSA method) module datasense.automation datasense.control_charts datasense.graphs datasense.html_ds datasense.msa datasense.munging datasense.process_capability datasense.pyxl datasense.rgx datasense.sequel datasense.stats datasense.taguchi

mR (class in datasense.control_charts) MSA (class in datasense.msa) msa_gauge_rr_results() (datasense.msa.MSA method) msa_results() (datasense.msa.MSA method)

N

natural_cubic_spline() (in module datasense.stats) nonparametric_summary() (in module datasense.stats)

number_empty_cells_in_columns() (in module datasense.munging) number_non_empty_rows() (in module datasense.pyxl)

O

one_sample_t() (in module datasense.stats) optimize_columns() (in module datasense.munging) optimize_datetime_columns() (in module datasense.munging)

optimize_float_columns() (in module datasense.munging) optimize_integer_columns() (in module datasense.munging) optimize_object_columns() (in module datasense.munging)

P

page_break() (in module datasense.html_ds) paired_t() (in module datasense.stats) parallelism_chart() (datasense.msa.MSA method) parameters_dict_replacement() (in module datasense.munging) parameters_text_replacement() (in module datasense.munging) parametric_summary() (in module datasense.stats) plot_barleft_lineright_x_y1_y2() (in module datasense.graphs) plot_boxcox() (in module datasense.graphs) plot_boxplot() (in module datasense.graphs) plot_histogram() (in module datasense.graphs) plot_horizontal_bars() (in module datasense.graphs) plot_line_line_line_x_y1_y2_y3() (in module datasense.graphs) plot_line_line_x_y1_y2() (in module datasense.graphs) plot_line_line_y1_y2() (in module datasense.graphs) plot_line_x_y() (in module datasense.graphs) plot_line_y() (in module datasense.graphs) plot_lineleft_lineright_x_y1_y2() (in module datasense.graphs) plot_pareto() (in module datasense.graphs) plot_pie() (in module datasense.graphs)

plot_scatter_line_x_y1_y2() (in module datasense.graphs) plot_scatter_scatter_x1_x2_y1_y2() (in module datasense.graphs) plot_scatter_scatter_x_y1_y2() (in module datasense.graphs) plot_scatter_x_y() (in module datasense.graphs) plot_scatter_y() (in module datasense.graphs) plot_scatterleft_scatterright_x_y1_y2() (in module datasense.graphs) plot_stacked_bars() (in module datasense.graphs) plot_vertical_bars() (in module datasense.graphs) points_four() (in module datasense.control_charts) points_one() (in module datasense.control_charts) points_three() (in module datasense.control_charts) points_two() (in module datasense.control_charts) pp() (in module datasense.process_capability) ppk() (in module datasense.process_capability) print_dictionary_by_key() (in module datasense.munging) print_list_by_item() (in module datasense.munging) probability_plot() (in module datasense.graphs) process_columns() (in module datasense.munging) process_rows() (in module datasense.munging) psycopg2_connection() (in module datasense.sequel)

Q

qr_code() (in module datasense.graphs)

quit_sap_excel() (in module datasense.munging)

R

R (class in datasense.control_charts) random_data() (in module datasense.stats) range_chart() (datasense.msa.MSA method) range_in_control() (datasense.msa.MSA method) range_out_of_control_reason() (datasense.msa.MSA method) read_file() (in module datasense.munging) read_workbook() (in module datasense.pyxl) remove_empty_worksheet_rows() (in module datasense.pyxl) remove_punctuation() (in module datasense.munging) remove_worksheet_columns() (in module datasense.pyxl)

remove_worksheet_rows() (in module datasense.pyxl) rename_all_columns() (in module datasense.munging) rename_directory() (in module datasense.munging) rename_some_columns() (in module datasense.munging) replace_column_values() (in module datasense.munging) replace_text() (in module datasense.pyxl) replace_text_numbers() (in module datasense.munging) report() (datasense.msa.MSA method) report_summary() (in module datasense.html_ds) rgx_email_address() (in module datasense.rgx) rgx_url() (in module datasense.rgx)

S

save_file() (in module datasense.munging) script_summary() (in module datasense.html_ds) series_memory_usage() (in module datasense.munging) series_replace_string() (in module datasense.munging) sigma (datasense.control_charts.ControlChart attribute) (datasense.control_charts.mR attribute) (datasense.control_charts.R attribute) (datasense.control_charts.X attribute) (datasense.control_charts.Xbar attribute)

sigmas (datasense.control_charts.ControlChart attribute) sort_rows() (in module datasense.munging) style_graph() (in module datasense.graphs) sync_directories() (in module datasense.html_ds)

T

taguchi_loss_function() (in module datasense.taguchi)

timedelta_data() (in module datasense.stats) two_sample_t() (in module datasense.stats)

U

ucl (datasense.control_charts.ControlChart attribute) (datasense.control_charts.mR attribute) (datasense.control_charts.R attribute) (datasense.control_charts.X attribute) (datasense.control_charts.Xbar attribute)

unique_list_items() (in module datasense.pyxl)

V

validate_column_labels() (in module datasense.pyxl)

validate_sheet_names() (in module datasense.pyxl) variance_components() (datasense.msa.MSA method)

W

water_coffee_tea_milk() (in module datasense.automation)

waterfall() (in module datasense.graphs) write_dataframe_to_worksheet() (in module datasense.pyxl)

X

X (class in datasense.control_charts)

Xbar (class in datasense.control_charts)

Y

y (datasense.control_charts.ControlChart attribute) (datasense.control_charts.mR attribute) (datasense.control_charts.R attribute) (datasense.control_charts.X attribute) (datasense.control_charts.Xbar attribute)