Index

A

add_primary_keys() (pyhelpers.dbms.PostgreSQL method)

alter_table_schema() (pyhelpers.dbms.PostgreSQL method)

C

calc_distance_on_unit_sphere() (in module pyhelpers.geom) calc_hypotenuse_distance() (in module pyhelpers.geom) calculate_idf() (in module pyhelpers.text) calculate_tf_idf() (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) 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 static 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.ops) 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.PostgreSQL method) get_column_names() (pyhelpers.dbms.MSSQL method) 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_relative_path() (in module pyhelpers.ops) get_row_count() (pyhelpers.dbms.MSSQL method) get_schema_info() (pyhelpers.dbms.MSSQL method) get_schema_names() (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) GitHubFileDownloader (class in pyhelpers.ops) go_from_altered_cwd() (in module pyhelpers.dirs) gps_to_utc() (in module pyhelpers.ops)

H

has_dtypes() (pyhelpers.dbms.MSSQL method)

hash_password() (in module pyhelpers.ops)

I

import_data() (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_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

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_csr_matrix() (in module pyhelpers.ops) parse_size() (in module pyhelpers.ops) path2linux() (in module pyhelpers.dirs) 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_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_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) save_web_page_as_pdf() (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_geom_point_type() (in module pyhelpers.geom)

U

uniform_pathname() (in module pyhelpers.dirs) unzip() (in module pyhelpers.store)

update_dict() (in module pyhelpers.ops) update_dict_keys() (in module pyhelpers.ops)

V

validate_dir() (in module pyhelpers.dirs)

validate_filename() (in module pyhelpers.dirs) verify_password() (in module pyhelpers.ops)

W

wgs84_to_osgb36() (in module pyhelpers.geom)

X

xlsx_to_csv() (in module pyhelpers.store)