Preprocess Data

NeuroSolutions
NeuroSolutions v2.15
NeuroSolutions for Excel
Custom Solution Wizard
Interactive Book
Source Code License
Priority Support

Preprocess Data
Analyze Data
Tag Data
Create/Open Network
Create Data Files
Train Network
Test Network

The Preprocess Data module allows the user to easily apply various preprocessing techniques to their raw data to prepare it for input into a neural network. The user can also create his/her own custom Preprocess Data batches by calling built in NeuroSolutions functions and/or writing Visual Basic code. These custom batches can then be run from the NeuroSolutions for Excel™ menu from within Microsoft Excel™ .

The following Preprocess Data operations are built into NeuroSolutions for Excel™:

Difference
Computes the difference or percent difference along a column of data.

Randomize Rows
Randomly arranges the rows of data within the active worksheet and writes the result to a new worksheet.

Sample
Creates a new worksheet made up of every Nth row of data within the active worksheet.

Moving Average
Computes the moving average of a column using the chosen window length.

Translate Symbolic Columns
Translates columns that have been tagged as symbol.

Insert Column Labels
Inserts a row of column labels into the first row of the active worksheet.
Clean Data
Cleans the data by replacing blank cells, error codes, and/or user-defined text with an interpolated value, the column average, a random value, or the closest value in a column.