DataPreparator 1.7

Helps you with data preparation/processing for data mining
DataPreparator is a unique and easy to use application designed to assist with common tasks of data preparation (or data pre-processing) 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.

Main features:

  • 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

last updated on:
July 15th, 2014, 1:56 GMT
file size:
17.2 MB
price:
FREE!
developed by:
DataPreparator Software
license type:
Freeware
operating system(s):
Mac OS X
binary format:
Universal Binary
category:
Home \ Utilities

FREE!

In a hurry? Add it to your Download Basket!

user rating

UNRATED
0.0/5
 

0/5

Rate it!
4 Screenshots
DataPreparator - In this window you can arrange test data.DataPreparator - From this menu you can create data sets, samples, split/combine or shuffle files.DataPreparator - Here you can visualize file name and attributes.DataPreparator
What's New in This Release:
  • Various amendments and bug fixes.
read full changelog

Add your review!

SUBMIT