PyHelpers
latest
Documentation
Installation
Modules
settings
Configurations
Preferences
dirs
Directory navigation
Directory validation
Directory/file control
ops
General use
Basic data manipulation
Basic computation
Graph plotting
Web data extraction
store
Data saving
Data loading
File decompression
File conversion
geom
Geometric data transformation
Geometric data computation
Geometric data sketching
text
Textual data preprocessing
Textual data computation
Textual data comparison
dbms
Databases
Database tools/utilities
Contributors
License
Tutorial
Quick start
Preparation - Create a data set
Alter settings for display of data
Specify a directory or a file path
Save data to / load data from a Pickle file
Convert coordinates between OSGB36 and WGS84
Find similar texts
Download an image file
Work with a PostgreSQL server
Connect to a database
Import data into a database
Fetch data from a database
Delete data
PyHelpers
Index
Index
A
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
L
|
M
|
N
|
O
|
P
|
R
|
S
|
T
|
U
|
V
|
W
|
X
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)
Read the Docs
v: latest
Versions
latest
stable
1.5.2
1.5.1
1.5.0
1.4.6
1.4.5
1.4.4
1.4.3
1.4.2
1.4.1
1.4.0
1.3.4
1.3.3
1.3.2
1.3.1
Downloads
pdf
On Read the Docs
Project Home
Builds