Index _ | A | B | C | D | E | F | G | H | I | L | M | N | O | P | R | S | T | U | V | W | X _ _autofit_column_width() (in module pyhelpers.store) _check_loading_path() (in module pyhelpers.store) _check_saving_path() (in module pyhelpers.store) _set_index() (in module pyhelpers.store) A add_primary_key() (pyhelpers.dbms.MSSQL method) add_primary_keys() (pyhelpers.dbms.PostgreSQL method) add_sql_query_condition() (in module pyhelpers.dbms.utils) alter_table_schema() (pyhelpers.dbms.PostgreSQL method) B BUILTIN_SCHEMAS (pyhelpers.dbms.MSSQL attribute) (pyhelpers.dbms.PostgreSQL attribute) C calc_distance_on_unit_sphere() (in module pyhelpers.geom) calc_hypotenuse_distance() (in module pyhelpers.geom) calculate_idf() (in module pyhelpers.text) calculate_tfidf() (in module pyhelpers.text) cd() (in module pyhelpers.dirs) cd_data() (in module pyhelpers.dirs) cdd() (in module pyhelpers.dirs) check_files_exist() (in module pyhelpers.dirs) check_url() (pyhelpers.ops.GitHubFileDownloader class method) cmap_discretisation() (in module pyhelpers.ops) colour_bar_index() (in module pyhelpers.ops) compare_dicts() (in module pyhelpers.ops) confirmed() (in module pyhelpers.ops) connect_database() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) cosine_similarity_between_texts() (in module pyhelpers.text) count_words() (in module pyhelpers.text) create_connection() (pyhelpers.dbms.MSSQL method) create_cursor() (pyhelpers.dbms.MSSQL method) create_database() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) create_engine() (pyhelpers.dbms.MSSQL method) create_rotation_matrix() (in module pyhelpers.ops) create_schema() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) create_table() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) create_url() (pyhelpers.ops.GitHubFileDownloader class method) D database_exists() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) DEFAULT_DATABASE (pyhelpers.dbms.MSSQL attribute) (pyhelpers.dbms.PostgreSQL attribute) DEFAULT_DIALECT (pyhelpers.dbms.MSSQL attribute) (pyhelpers.dbms.PostgreSQL attribute) DEFAULT_DRIVER (pyhelpers.dbms.MSSQL attribute) (pyhelpers.dbms.PostgreSQL attribute) DEFAULT_HOST (pyhelpers.dbms.MSSQL attribute) (pyhelpers.dbms.PostgreSQL attribute) DEFAULT_ODBC_DRIVER (pyhelpers.dbms.MSSQL attribute) DEFAULT_PORT (pyhelpers.dbms.MSSQL attribute) (pyhelpers.dbms.PostgreSQL attribute) DEFAULT_SCHEMA (pyhelpers.dbms.MSSQL attribute) (pyhelpers.dbms.PostgreSQL attribute) DEFAULT_USERNAME (pyhelpers.dbms.MSSQL attribute) (pyhelpers.dbms.PostgreSQL attribute) delete_dir() (in module pyhelpers.dirs) detect_nan_for_str_column() (in module pyhelpers.ops) dict_to_dataframe() (in module pyhelpers.ops) disconnect_all_others() (pyhelpers.dbms.PostgreSQL method) disconnect_database() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) download() (pyhelpers.ops.GitHubFileDownloader method) download_file_from_url() (in module pyhelpers.ops) download_single_file() (pyhelpers.ops.GitHubFileDownloader method) drop_axis() (in module pyhelpers.geom) drop_database() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) drop_schema() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) drop_table() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) E euclidean_distance_between_texts() (in module pyhelpers.text) eval_dtype() (in module pyhelpers.ops) extract_words1upper() (in module pyhelpers.text) F fake_requests_headers() (in module pyhelpers.ops) find_closest_date() (in module pyhelpers.ops) find_closest_point() (in module pyhelpers.geom) find_closest_points() (in module pyhelpers.geom) find_executable() (in module pyhelpers.dirs) find_matched_str() (in module pyhelpers.text) find_shortest_path() (in module pyhelpers.geom) find_similar_str() (in module pyhelpers.text) func_running_time() (in module pyhelpers.ops) G gdal_configurations() (in module pyhelpers.settings) get_acronym() (in module pyhelpers.text) get_column_dtype() (pyhelpers.dbms.PostgreSQL method) get_column_info() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) get_column_names() (pyhelpers.dbms.MSSQL method) get_coordinates_as_array() (in module pyhelpers.geom) get_database_names() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) get_database_size() (pyhelpers.dbms.PostgreSQL method) get_default_database_address() (in module pyhelpers.dbms.utils) get_dict_values() (in module pyhelpers.ops) get_extreme_outlier_bounds() (in module pyhelpers.ops) get_file_pathnames() (in module pyhelpers.dirs) get_file_tables() (pyhelpers.dbms.MSSQL method) get_geometric_midpoint() (in module pyhelpers.geom) get_geometric_midpoint_calc() (in module pyhelpers.geom) get_midpoint() (in module pyhelpers.geom) get_number_of_chunks() (in module pyhelpers.ops) get_obj_attr() (in module pyhelpers.ops) get_primary_keys() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) get_rectangle_centroid() (in module pyhelpers.geom) get_row_count() (pyhelpers.dbms.MSSQL method) get_schema_info() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) get_square_vertices() (in module pyhelpers.geom) get_square_vertices_calc() (in module pyhelpers.geom) get_table_names() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) get_user_agent_string() (in module pyhelpers.ops) get_utc_tai_offset() (in module pyhelpers.ops) GitHubFileDownloader (class in pyhelpers.ops) gps_time_to_utc() (in module pyhelpers.ops) H has_dtypes() (pyhelpers.dbms.MSSQL method) hash_password() (in module pyhelpers.ops) I import_data() (in module pyhelpers.dbms.utils) (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) init_requests_session() (in module pyhelpers.ops) interquartile_range() (in module pyhelpers.ops) is_dir() (in module pyhelpers.dirs) is_downloadable() (in module pyhelpers.ops) is_network_connected() (in module pyhelpers.ops) is_url() (in module pyhelpers.ops) is_url_connectable() (in module pyhelpers.ops) L load_csr_matrix() (in module pyhelpers.store) load_csv() (in module pyhelpers.store) load_data() (in module pyhelpers.store) load_feather() (in module pyhelpers.store) load_joblib() (in module pyhelpers.store) load_json() (in module pyhelpers.store) load_pickle() (in module pyhelpers.store) load_spreadsheets() (in module pyhelpers.store) load_user_agent_strings() (in module pyhelpers.ops) loop_in_pairs() (in module pyhelpers.ops) M make_database_address() (in module pyhelpers.dbms.utils) markdown_to_rst() (in module pyhelpers.store) merge_dicts() (in module pyhelpers.ops) module pyhelpers pyhelpers.dbms pyhelpers.dbms.utils pyhelpers.dirs pyhelpers.geom pyhelpers.ops pyhelpers.settings pyhelpers.store pyhelpers.text mpl_preferences() (in module pyhelpers.settings) MSSQL (class in pyhelpers.dbms) mssql_to_postgresql() (in module pyhelpers.dbms.utils) N normalize_pathname() (in module pyhelpers.dirs) np_preferences() (in module pyhelpers.settings) np_shift() (in module pyhelpers.ops) null_text_to_empty_string() (pyhelpers.dbms.PostgreSQL method) numeral_english_to_arabic() (in module pyhelpers.text) O osgb36_to_wgs84() (in module pyhelpers.geom) P parse_size() (in module pyhelpers.ops) pd_preferences() (in module pyhelpers.settings) PostgreSQL (class in pyhelpers.dbms) project_point_to_line() (in module pyhelpers.geom) psql_insert_copy() (pyhelpers.dbms.PostgreSQL static method) pyhelpers module pyhelpers.dbms module pyhelpers.dbms.utils module pyhelpers.dirs module pyhelpers.geom module pyhelpers.ops module pyhelpers.settings module pyhelpers.store module pyhelpers.text module R read_columns() (pyhelpers.dbms.MSSQL method) read_data() (in module pyhelpers.dbms.utils) read_sql_query() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) read_table() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) remove_dict_keys() (in module pyhelpers.ops) remove_punctuation() (in module pyhelpers.text) S save_data() (in module pyhelpers.store) save_feather() (in module pyhelpers.store) save_fig() (in module pyhelpers.store) save_figure() (in module pyhelpers.store) save_html_as_pdf() (in module pyhelpers.store) save_joblib() (in module pyhelpers.store) save_json() (in module pyhelpers.store) save_pickle() (in module pyhelpers.store) save_spreadsheet() (in module pyhelpers.store) save_spreadsheets() (in module pyhelpers.store) save_svg_as_emf() (in module pyhelpers.store) schema_exists() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) seven_zip() (in module pyhelpers.store) sketch_square() (in module pyhelpers.geom) specify_conn_str() (pyhelpers.dbms.MSSQL method) split_iterable() (in module pyhelpers.ops) split_list() (in module pyhelpers.ops) split_list_by_size() (in module pyhelpers.ops) swap_cols() (in module pyhelpers.ops) swap_rows() (in module pyhelpers.ops) T table_exists() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) transform_point_type() (in module pyhelpers.geom) U unzip() (in module pyhelpers.store) update_dict() (in module pyhelpers.ops) update_dict_keys() (in module pyhelpers.ops) V validate_column_names() (pyhelpers.dbms.MSSQL method) (pyhelpers.dbms.PostgreSQL method) validate_dir() (in module pyhelpers.dirs) validate_filename() (in module pyhelpers.dirs) varchar_to_geometry_dtype() (pyhelpers.dbms.MSSQL method) verify_password() (in module pyhelpers.ops) W wgs84_to_osgb36() (in module pyhelpers.geom) X xlsx_to_csv() (in module pyhelpers.store)