DataPreparator is a Windows application oriented toward professional data analysts. There are instruments for accessing information from text documents, relational databases and Excel spreadsheets. You are able to apply advanced error correction algorithms to imported datasets as well.

Cleaning

The program is capable of quickly identifying duplicate values and outliers. There is support for complex imputation techniques to further simplify data preparation. Additionally, users can perform advanced operations such as:

Normalization;
Aggregation;
Encoding, etc.

Transformations like pivoting and unpivoting tables are available. Moreover, you may combine information obtained from several sources into a single database to gain valuable insights.

Analysis

Users are able to monitor changes and identify potential patterns by building visual representations of custom datasets. Integrated charting tools are perfect for exploring data relationships during preparation.

There is an option to create and execute automation scripts. This empowers you to streamline repetitive tasks and significantly speed up file processing.

Features

free to download and use;
contains instruments to help you process and analyze various datasets;
it is possible to automatically clean up imported values;
supports complex manipulations like table aggregation;
compatible with all modern versions of Windows.