Contents Menu Expand Light mode Dark mode Auto light/dark, in light mode Auto light/dark, in dark mode Skip to content
PyHelpers
PyHelpers

Getting Started

  • Installation
  • Quick Start

Usage & Reference

  • Modules
    • settings
      • gdal_configurations
      • mpl_preferences
      • np_preferences
      • pd_preferences
    • dirs
      • cd
      • cdd
      • cd_data
      • find_executable
      • normalize_pathname
      • is_dir
      • validate_dir
      • validate_filename
      • get_file_pathnames
      • check_files_exist
      • check_relative_pathname
      • add_slashes
      • delete_dir
    • ops
      • get_utc_tai_offset
      • gps_time_to_utc
      • find_closest_date
      • parse_size
      • get_number_of_chunks
      • interquartile_range
      • get_extreme_outlier_bounds
      • loop_in_pairs
      • split_list_by_size
      • split_list
      • split_iterable
      • update_dict
      • update_dict_keys
      • get_dict_values
      • remove_dict_keys
      • compare_dicts
      • merge_dicts
      • detect_nan_for_str_column
      • create_rotation_matrix
      • dict_to_dataframe
      • swap_cols
      • swap_rows
      • np_shift
      • cmap_discretisation
      • colour_bar_index
      • is_network_connected
      • is_url
      • is_url_connectable
      • init_requests_session
      • load_user_agent_strings
      • get_user_agent_string
      • fake_requests_headers
      • is_downloadable
      • download_file_from_url
      • GitHubFileDownloader
        • GitHubFileDownloader.check_url
        • GitHubFileDownloader.create_url
        • GitHubFileDownloader.download
        • GitHubFileDownloader.download_single_file
      • CrossRefOrcid
        • CrossRefOrcid.CITATION_STYLES
        • CrossRefOrcid.CROSSREF_REST_API_ENDPOINT
        • CrossRefOrcid.ORCID_PUBLIC_API_ENDPOINT
        • CrossRefOrcid.ZENODO_REST_API_ENDPOINT
        • CrossRefOrcid.fetch_orcid_works
        • CrossRefOrcid.fetch_references
        • CrossRefOrcid.format_references
        • CrossRefOrcid.get_list_of_works
        • CrossRefOrcid.get_metadata_from_doi
        • CrossRefOrcid.get_orcid_profile
        • CrossRefOrcid.update_references
      • confirmed
      • get_obj_attr
      • eval_dtype
      • hash_password
      • verify_password
      • func_running_time
      • get_git_branch
      • get_ansi_colour_code
    • store
      • _check_saving_path
      • _autofit_column_width
      • _check_loading_path
      • _set_index
      • save_pickle
      • save_spreadsheet
      • save_spreadsheets
      • save_json
      • save_joblib
      • save_feather
      • save_svg_as_emf
      • save_fig
      • save_figure
      • save_html_as_pdf
      • save_data
      • load_pickle
      • load_csv
      • load_spreadsheets
      • load_json
      • load_joblib
      • load_feather
      • load_csr_matrix
      • load_data
      • unzip
      • seven_zip
      • markdown_to_rst
      • xlsx_to_csv
    • geom
      • calc_distance_on_unit_sphere
      • calc_hypotenuse_distance
      • find_closest_point
      • find_closest_points
      • find_shortest_path
      • get_midpoint
      • get_geometric_midpoint
      • get_geometric_midpoint_calc
      • get_rectangle_centroid
      • get_square_vertices
      • get_square_vertices_calc
      • sketch_square
      • transform_point_type
      • get_coordinates_as_array
      • wgs84_to_osgb36
      • osgb36_to_wgs84
      • drop_axis
      • project_point_to_line
    • text
      • remove_punctuation
      • get_acronym
      • split_on_uppercase
      • numeral_english_to_arabic
      • count_words
      • calculate_idf
      • calculate_tfidf
      • euclidean_distance_between_texts
      • cosine_similarity_between_texts
      • find_matched_str
      • find_similar_str
    • dbms
      • PostgreSQL
        • PostgreSQL.BUILTIN_SCHEMAS
        • PostgreSQL.DEFAULT_DATABASE
        • PostgreSQL.DEFAULT_DIALECT
        • PostgreSQL.DEFAULT_DRIVER
        • PostgreSQL.DEFAULT_HOST
        • PostgreSQL.DEFAULT_PORT
        • PostgreSQL.DEFAULT_SCHEMA
        • PostgreSQL.DEFAULT_USERNAME
        • PostgreSQL.add_primary_keys
        • PostgreSQL.alter_table_schema
        • PostgreSQL.connect_database
        • PostgreSQL.create_database
        • PostgreSQL.create_schema
        • PostgreSQL.create_table
        • PostgreSQL.database_exists
        • PostgreSQL.disconnect_all_others
        • PostgreSQL.disconnect_database
        • PostgreSQL.drop_database
        • PostgreSQL.drop_schema
        • PostgreSQL.drop_table
        • PostgreSQL.get_column_dtype
        • PostgreSQL.get_column_info
        • PostgreSQL.get_database_names
        • PostgreSQL.get_database_size
        • PostgreSQL.get_primary_keys
        • PostgreSQL.get_schema_info
        • PostgreSQL.get_table_names
        • PostgreSQL.import_data
        • PostgreSQL.null_text_to_empty_string
        • PostgreSQL.psql_insert_copy
        • PostgreSQL.read_sql_query
        • PostgreSQL.read_table
        • PostgreSQL.schema_exists
        • PostgreSQL.table_exists
        • PostgreSQL.validate_column_names
      • MSSQL
        • MSSQL.BUILTIN_SCHEMAS
        • MSSQL.DEFAULT_DATABASE
        • MSSQL.DEFAULT_DIALECT
        • MSSQL.DEFAULT_DRIVER
        • MSSQL.DEFAULT_HOST
        • MSSQL.DEFAULT_ODBC_DRIVER
        • MSSQL.DEFAULT_PORT
        • MSSQL.DEFAULT_SCHEMA
        • MSSQL.DEFAULT_USERNAME
        • MSSQL.add_primary_key
        • MSSQL.connect_database
        • MSSQL.create_connection
        • MSSQL.create_cursor
        • MSSQL.create_database
        • MSSQL.create_engine
        • MSSQL.create_schema
        • MSSQL.create_table
        • MSSQL.database_exists
        • MSSQL.disconnect_database
        • MSSQL.drop_database
        • MSSQL.drop_schema
        • MSSQL.drop_table
        • MSSQL.get_column_info
        • MSSQL.get_column_names
        • MSSQL.get_database_names
        • MSSQL.get_file_tables
        • MSSQL.get_primary_keys
        • MSSQL.get_row_count
        • MSSQL.get_schema_info
        • MSSQL.get_table_names
        • MSSQL.has_dtypes
        • MSSQL.import_data
        • MSSQL.read_columns
        • MSSQL.read_sql_query
        • MSSQL.read_table
        • MSSQL.schema_exists
        • MSSQL.specify_conn_str
        • MSSQL.table_exists
        • MSSQL.validate_column_names
        • MSSQL.varchar_to_geometry_dtype
      • make_database_address
      • get_default_database_address
      • add_sql_query_condition
      • import_data
      • read_data
      • mssql_to_postgresql

Additional Info

  • License
  • Contributors
Back to top

Python Module Index

p
 
p
- pyhelpers
    pyhelpers.dbms
    pyhelpers.dbms.utils
    pyhelpers.dirs
    pyhelpers.geom
    pyhelpers.ops
    pyhelpers.settings
    pyhelpers.store
    pyhelpers.text
Copyright © 2019-2025, Qian Fu
Made with Sphinx and @pradyunsg's Furo