2. Installing select_ai

2.1. Installation requirements

To use select_ai you need:

  • Python 3.9, 3.10, 3.11, 3.12 or 3.13

  • python-oracledb - This package is automatically installed as a dependency requirement

  • pandas - This package is automatically installed as a dependency requirement

2.2. select_ai installation

select_ai can be installed from Python’s package repository PyPI using pip.

  1. Install Python 3 if it is not already available. Use any version from Python 3.9 through 3.13.

  2. Install select_ai:

python3 -m pip install select_ai --upgrade --user

  1. If you are behind a proxy, use the --proxy option. For example:

python3 -m pip install select_ai --upgrade --user --proxy=http://proxy.example.com:80

  1. Create a file select_ai_connection_test.py such as:

import select_ai

user = "<your_db_user>"
password = "<your_db_password>"
dsn = "<your_db_dsn>"
select_ai.connect(user=user, password=password, dsn=dsn)
print("Connected to the Database")

  1. Run select_ai_connection_test.py

python3 select_ai_connection_test.py

Enter the database password when prompted and message will be shown:

Connected to the Database