DataPreparator 1.4

DataPreparator is a free, unique, easy to use application designed to assist with common tasks of  data preparation (or data preprocessing) in data analysis and data mining.

DataPreparator can assist you with exploring and preparing data in various ways prior to data analysis or data mining.

DataPreparator includes operators for cleaning, discretization, numeration, scaling, attribute selection, missing values, outliers, statistics, visualization, balancing, sampling, row selection, and several other tasks.

Here are some key features of "DataPreparator":

General:
· Data access from text files, relational databases, and Excel workbooks
· Handling of large volumes of data (since data sets are not stored in the computer memory, with the exception of Excel workbooks and result sets of some databases where database drivers do not support data streaming)
· Stand alone tool, independent of any other tools
· User friendly graphical user interface
· Operator chaining to create sequences of preprocessing transformations (operator tree)
· Creating of model tree for test/execution data

Data cleaning:
· Character removal
· Text replacement
· Date conversion

Attribute operators on columns in the data set:
· Delete/Move attributes
· Remove selected attributes
· Move selected attributes 
· Discretize numeric attributes
· Equal width
· Equal frequency
· Equal frequency from grouped data
· Handle missing values
· Delete records containing missing values
· Remove attributes containing missing values
· Impute missing values
· Predict missing valuues from model (dependence tree, Naive Bayes model)
· Include missing value patterns
· Handle outliers
· Z-score method
· Box-plot method
· Numerate nominal attributes
· Create binary attributes
· Replace nominal values by indices
· Reduce number of labels
· Keep a specified number of most frequent labels and create a new label from the remaining labels.
· Scale numeric attributes
· Decimal
· Linear
· Hyperbolic tangent
· Soft-max
· Z-score
· Other transformations (log(x), 1/x, x2, x3)
· Select attributes
· Manual selection
· Mutual information selection
· Robust mutual information selection

Record operators on rows in the data set:
· Sampling (random, every k-th item, first-k)
· Select records by key

File Utilities that create new files:
· Create data sets
· Create missing values
· Append
· Balance
· Change names
· Merge
· Sort

Output:
· Statistics
· Table
· File
· Database
· Visualize
Visualize Numeric attributes:
· Bar chart, cumulative frequency chart
· Box plot (single, conditional)
· Histogtram (single, conditional, normalized, overlaid, histogram matrix)
· Lag plot
· Linear regression plot
· Normal-quantile plot
· Quantile plot
· Quantile-quantile plot
· Run sequence plot
· Scatter plot
Visualize Nominal (categorical) attributes:
· Bar chart, pie chart
· Pareto chart
· Stacked chart
Numeric and nominal attributes:
· Dependence tree

Tools:
· Create data sets from raw data
· Create samples from raw data
· Shuffle raw data
· Configure database drivers

Requirements:

· Java 1.6 or later
· Memory: 1Gb RAM
· Disk Space: 20 Mb