4.10 Use the R Interpreter in a Notebook Paragraph

An Oracle Machine Learning notebook supports multiple languages. Each paragraph is associated with a specific interpreter. To run R functions in an Oracle Machine Learning notebook, you must first connect to the R interpreter.

In an Oracle Machine Learning notebook, you can add multiple paragraphs, and each paragraph can be connected to different interpreters such as R or SQL or Python. You identify which interpreter to use by specifying % followed by the interpreter to use: sql, script, r, python, conda, markdown.

This example shows how to:
  • Connect to the R interpreter to run R commands in a notebook.
  • Verify the connection to Oracle Autonomous AI Database, and
  • Load the ORE libraries
  1. To connect to the R interpreter, type the following directive at the beginning of the notebook paragraph, and press Enter:
    %r
  2. To verify the database connection, type the following command and press Enter:
    ore.is.connected()
    Once your notebook is connected, the command returns TRUE, as shown in the screenshot here. The notebook is now connected to the R interpreter, and you are ready to run R commands in your notebook.

    Figure 4-39 Command to Test Database Connection


    Description of Figure 4-39 follows
    Description of "Figure 4-39 Command to Test Database Connection"

  3. To import R Libraries, run the following commands: 
    library(ORE)
library(OREdplyr)
    Once the packages are loaded successfully, the list of ORE packages are displayed as shown in the screenshot here. Scroll down to view the entire list.

    Figure 4-40 Command to Import R packages


    Description of Figure 4-40 follows
    Description of "Figure 4-40 Command to Import R packages"

  • About Oracle Machine Learning for R
    Oracle Machine Learning for R (OML4R) is a component of the Oracle Machine Learning family of products, which integrates R with Oracle Autonomous AI Database.

Parent topic: OML Notebooks