7.1 Prepare Data

Using methods of OML4Py data type classes, you can prepare data for analysis in the database, as described in the following topics.

• About Preparing Data in the Database
  OML4Py data type classes have methods that enable you to use Python to prepare database data for analysis.
• Select Data
  A typical step in preparing data for analysis is selecting or filtering values of interest from a larger data set.
• Combine Data
  You can join data from oml.DataFrame objects that represent database tables by using the append, concat, and merge methods.
• Clean Data
  In preparing data for analysis, a typical step is to transform data by dropping some values.
• Split Data
  Sample and randomly partition data with the split and KFold methods.