3.1.1 About Preparing Data in the Database

Oracle Machine Learning for R provides functions that enable you to use R to prepare database data for analysis.

Using these functions, you can perform typical data preparation tasks on ore.frame and other OML4R objects. You can perform data preparation operations on large quantities of data in the database and then pull the results to your local R session for analysis using functions in packages available from The Comprehensive R Archive Network (CRAN).

You can do operations on data such as the following.

  • Selecting

  • Binning

  • Sampling

  • Sorting and Ordering

  • Summarizing

  • Transforming

  • Performing data preparation operations on date and time data

Performing these operations is described in the other topics in this chapter.