3.1.1 About Preparing Data in the Database

Oracle R Enterprise 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 Oracle R Enterprise 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.