Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Related Resources
  • Conventions
  • Documentation Accessibility
• 1 Changes in This Release for Oracle Machine Learning for Python
  • 1.1 New Features in 23ai
  • 1.2 Other Changes
• 2 About Oracle Machine Learning for Python
  • 2.1 What Is Oracle Machine Learning for Python?
  • 2.2 Advantages of Oracle Machine Learning for Python
  • 2.3 Manipulate database tables and views using familiar Python functions and syntax
  • 2.4 About the Python Components and Libraries in OML4Py
• 3 Install OML4Py Client for Linux for Use With Autonomous Database Serverless
• 4 Install OML4Py for On-Premises Databases
  • 4.1 OML4Py On Premises System Requirements
  • 4.2 Build and Install Python for Linux for On-Premises Databases
    • 4.2.1 Commands Summary for Building and Installing Python for Linux for On-Premises Databases
  • 4.3 Install the Required Supporting Packages for Linux for On-Premises Databases
    • 4.3.1 Commands Summary for Installing Required Supporting Packages for Linux for On-Premises Databases
  • 4.4 Install OML4Py Server for On-Premises Oracle Database
    • 4.4.1 Install OML4Py Server for Linux for On-Premises Oracle Database 23ai
      • 4.4.1.1 Commands Summary for Installing OML4Py Server for On-Premises Oracle Databases
    • 4.4.2 Verify OML4Py Installation for On-Premises Database
    • 4.4.3 Grant Users the Required Privileges for On-Premises Database
    • 4.4.4 Create New Users for On-Premises Oracle Database
    • 4.4.5 Uninstall the OML4Py Server from an On-Premises Database 23ai
  • 4.5 Install OML4Py Client for On-Premises Oracle Database
    • 4.5.1 Install Oracle Instant Client and the OML4Py Client for Linux
      • 4.5.1.1 Install Oracle Instant Client for Linux for On-Premises Databases
      • 4.5.1.2 Install OML4Py Client for Linux for On-Premises Databases
      • 4.5.1.3 Commands Summary for Installing Oracle Instant Client and OML4Py Client for On-Premises Oracle Database
    • 4.5.2 Verify OML4Py Client Installation for On-Premises Databases
    • 4.5.3 Uninstall the OML4Py Client for On-Premises Databases
    • 4.5.4 Upgrade the OML4Py Client for On-Premises Databases
• 5 Install OML4Py on Exadata
  • 5.1 About Oracle Machine Learning for Python on Exadata
  • 5.2 Configure DCLI to install Python across Exadata compute nodes.
    • 5.2.1 Install Python across Exadata compute nodes using DCLI
    • 5.2.2 Install OML4Py across Exadata compute nodes using DCLI
• 6 Install Third-Party Packages
  • 6.1 Conda Commands
  • 6.2 Administrative Tasks for Creating and Saving a Conda Environment
  • 6.3 OML User Tasks for Downloading an Available Conda Environment
  • 6.4 Using Conda Environments with Embedded Python Execution
• 7 Get Started with Oracle Machine Learning for Python
  • 7.1 Use OML4Py with Oracle Autonomous Database
  • 7.2 Use OML4Py with an On-Premises Oracle Database
    • 7.2.1 About Connecting to an On-Premises Oracle Database
    • 7.2.2 About Oracle Wallets
    • 7.2.3 Connect to an Oracle Database
  • 7.3 Move Data Between the Database and a Python Session
    • 7.3.1 About Moving Data Between the Database and a Python Session
    • 7.3.2 Push Local Python Data to the Database
    • 7.3.3 Pull Data from the Database to a Local Python Session
    • 7.3.4 Create a Python Proxy Object for a Database Object
    • 7.3.5 Create a Persistent Database Table from a Python Data Set
  • 7.4 Save Python Objects in the Database
    • 7.4.1 About OML4Py Datastores
    • 7.4.2 Save Objects to a Datastore
    • 7.4.3 Load Saved Objects From a Datastore
    • 7.4.4 Get Information About Datastores
    • 7.4.5 Get Information About Datastore Objects
    • 7.4.6 Delete Datastore Objects
    • 7.4.7 Manage Access to Stored Objects
• 8 Prepare and Explore Data
  • 8.1 Prepare Data
    • 8.1.1 About Preparing Data in the Database
    • 8.1.2 Select Data
    • 8.1.3 Combine Data
    • 8.1.4 Clean Data
    • 8.1.5 Split Data
  • 8.2 Explore Data
    • 8.2.1 About the Exploratory Data Analysis Methods
    • 8.2.2 Correlate Data
    • 8.2.3 Cross-Tabulate Data
    • 8.2.4 Mutate Data
    • 8.2.5 Sort Data
    • 8.2.6 Summarize Data
    • 8.2.7 Date, Time, and Integer Data
  • 8.3 Render Graphics
• 9 OML4Py Classes That Provide Access to In-Database Machine Learning Algorithms
  • 9.1 About Machine Learning Classes and Algorithms
  • 9.2 About Model Settings
  • 9.3 Shared Settings
  • 9.4 Export Oracle Machine Learning for Python Models
  • 9.5 Automatic Data Preparation
  • 9.6 Model Explainability
  • 9.7 Attribute Importance
  • 9.8 Association Rules
  • 9.9 Decision Tree
  • 9.10 Expectation Maximization
  • 9.11 Explicit Semantic Analysis
  • 9.12 Generalized Linear Model
  • 9.13 k-Means
  • 9.14 Naive Bayes
  • 9.15 Neural Network
  • 9.16 Random Forest
  • 9.17 Singular Value Decomposition
  • 9.18 Support Vector Machine
  • 9.19 Non-Negative Matrix Factorization
  • 9.20 Exponential Smoothing Method
  • 9.21 XGBoost
• 10 Automated Machine Learning
  • 10.1 About Automated Machine Learning
  • 10.2 Algorithm Selection
  • 10.3 Feature Selection
  • 10.4 Model Tuning
  • 10.5 Model Selection
• 11 Convert Pretrained Models to ONNX Format
  • 11.1 Load Custom Models from The Local Filesystem
  • 11.2 Convert Pretrained Models to ONNX Model: End-to-End Instructions
  • 11.3 Python Classes to Convert Pretrained Models to ONNX Models
• 12 Embedded Python Execution
  • 12.1 About Embedded Python Execution
    • 12.1.1 Comparison of the Embedded Python Execution APIs
  • 12.2 Parallelism with OML4Py Embedded Python Execution
  • 12.3 Datastores Supporting Embedded Python Execution
    • 12.3.1 ALL_PYQ_DATASTORE_CONTENTS View
    • 12.3.2 ALL_PYQ_DATASTORES View
    • 12.3.3 USER_PYQ_DATASTORES View
  • 12.4 Script repository for user-defined Python functions supporting EPE
    • 12.4.1 ALL_PYQ_SCRIPTS View
    • 12.4.2 USER_PYQ_SCRIPTS View
  • 12.5 Python API for Embedded Python Execution
    • 12.5.1 About Python API for Embedded Python Execution
    • 12.5.2 Run a User-Defined Python Function
    • 12.5.3 Run a User-Defined Python Function on the Specified Data
    • 12.5.4 Run a Python Function on Data Grouped By Column Values
    • 12.5.5 Run a User-Defined Python Function on Sets of Rows
    • 12.5.6 Run a User-Defined Python Function Multiple Times
    • 12.5.7 Save and Manage User-Defined Python Functions in the Script Repository
      • 12.5.7.1 About the Script Repository
      • 12.5.7.2 Create and Store a User-Defined Python Function
      • 12.5.7.3 List Available User-Defined Python Functions
      • 12.5.7.4 Load a User-Defined Python Function
      • 12.5.7.5 Drop a User-Defined Python Function from the Repository
  • 12.6 SQL API for Embedded Python Execution with On-premises Database
    • 12.6.1 About the SQL API for Embedded Python Execution with On-Premises Database
    • 12.6.2 pyqEval Function (On-Premises Database)
    • 12.6.3 pyqTableEval Function (On-Premises Database)
    • 12.6.4 pyqRowEval Function (On-Premises Database)
    • 12.6.5 pyqGroupEval Function (On-Premises Database)
    • 12.6.6 pyqGrant Function (On-Premises Database)
    • 12.6.7 pyqRevoke Function (On-Premises Database)
    • 12.6.8 pyqScriptCreate Procedure (On-Premises Database)
    • 12.6.9 pyqScriptDrop Procedure (On-Premises Database)
  • 12.7 SQL API for Embedded Python Execution with Autonomous Database
    • 12.7.1 Access and Authorization Procedures and Functions
      • 12.7.1.1 pyqAppendHostACE Procedure
      • 12.7.1.2 pyqGetHostACE Function
      • 12.7.1.3 pyqRemoveHostACE Procedure
      • 12.7.1.4 pyqSetAuthToken Procedure
      • 12.7.1.5 pyqIsTokenSet Function
    • 12.7.2 Embedded Python Execution Functions (Autonomous Database)
      • 12.7.2.1 pyqListEnvs Function (Autonomous Database)
      • 12.7.2.2 pyqEval Function (Autonomous Database)
      • 12.7.2.3 pyqTableEval Function (Autonomous Database)
      • 12.7.2.4 pyqRowEval Function (Autonomous Database)
      • 12.7.2.5 pyqGroupEval Function (Autonomous Database)
      • 12.7.2.6 pyqIndexEval Function (Autonomous Database)
      • 12.7.2.7 pyqGrant Function (Autonomous Database)
      • 12.7.2.8 pyqRevoke Function (Autonomous Database)
      • 12.7.2.9 pyqScriptCreate Procedure (Autonomous Database)
      • 12.7.2.10 pyqScriptDrop Procedure (Autonomous Database)
    • 12.7.3 Asynchronous Jobs (Autonomous Database)
      • 12.7.3.1 oml_async_flag Argument
      • 12.7.3.2 pyqJobStatus Function
      • 12.7.3.3 pyqJobResult Function
      • 12.7.3.4 Asynchronous Job Example
    • 12.7.4 Special Control Arguments (Autonomous Database)
    • 12.7.5 Output Formats (Autonomous Database)
• 13 Administrative Tasks for Oracle Machine Learning for Python
• Index