Datamate™ Numeric Processor for Mac OS X
Datamate™ Numeric Processor is a versatile and robust data processor for all you number crunching needs!
Normalize, standardize, scale, and manage missing data and data outliers quickly and accurately. Complete with descriptive statistics, robust reporting, and intricately configurable data output formatting.
*Quick and helpful online support available 7 days a week!
BUY Mac OS X • FREE Mac OS X
We built Datamate™ Numeric Processor to be versatile and intuitive to use. To this end we we've included Next and Back buttons to guide you through the steps of processing your data, while at the same time allowing you to navigate through the application freely as other than Importing Data and Selecting Columns, you can apply the data processing rules in any order you want or not bother at all to configure rules you don't need as the preset default values will allow you to bypass any section of rules without configuring them or applying them.
You can simply import data that you want to run descriptive statics on and do no more or additionally just output the data into another format. But the real power of Datamate™ Numeric Processor comes from configuring and applying the data processing rules. Plus you can import mixed data, in other words data with numeric and non-numeric/textual values, and process just the numeric values then remerge the non-numeric/unprocessed data with the processed data during the output phase. You can also append prefixes and suffixes to your processed data with just the click of a few butons.
1- Click on the Start Button or select the Import Tab and click on the Open Button and choose the data file you want to process. Choose the Data Delimiter for your data file. Click on the Data or Header option depending upon whether or not the first line of your input data file is actual data for processing or textual column headers. Click the Import Button. An import report will be generated indicating how the import process went and display warnings, notices, and errors it encountered if any.
2- Click the Next Button or Select the Columns Tab. Click on Auto to have Datamate™ automatically choose all numeric columns of data it finds for processing or you can manually add and remove columns.
3- Click on the Next Button or Any Tab and configure and apply the rules for processing your data or just run statistics on it or output the data in a variety of formats and styles with added column headers, data value prefixes and suffixes as you like.
Also, there are helpful information buttons on each tab for quick reference and a processing report is generated which you can copy or save.
You can save the processed output, processing rules, and processing reports to any file location, but Datamate™ creates default directories for your convenience although you are not required to use them. The one hard and fast rule is the filename extension for the data processing rules file must adhere to our pre-defined extension, which is .dnpr as the application will not be able to load data processing rules with any other filename extension.
You can save the rules you configured for processing your data and load them at a later time to use them for processing data that is of the same format/structure. By that we mean the column count and column alignment, etc. is the same for the files in question. If you choose to load rules you've previously saved you will only need to open and import the new data file then select the columns of data for processing. Note, if you have already loaded the rules before you've imported the data, then uncheck the reset rules box. Or you can import the new data file first, then load the rules. You won't see the application's controls reflect the loaded data processing rules settings, but they are at work behind the scenes, so no need to go through the rules views applying them. Just load your new data file, select the columns, and run your output. But if you wanted to modify the loaded rules, that's perfectly Ok to do, you can re-save them too.
Input Data Filename: The name of the file containing the data to be processed. Choose the file by clicking on the OPEN button.
Auto Select: Datamate™ automatically selects all of the numeric columns of data it finds. You can use auto-select and then manually add or remove additional numeric data columns for processing.
Missing And Non-Numeric Data Rule: The rule for which you want to apply to any missing or non-numeric data Datamate™ comes across prior to processing the data. Select the rule you want to apply and input a numeric value if you choose the custom value replacement method.
Replace Outliers With: The value in which Datamate™ will replace any outliers it encounters during processing. For custom replacement values entet one to use in replacing outliers found below the mean of the column of data and one to use in replacing outliers found above the mean of the column of data.
Use Data Transformation Type: The type of data transformation you want Datamate™ to apply to your data.
Descriptive Statistics: Full set of descriptive statistics is produced including skewness and kurtosis with the selected rule sets applied according to the checkboxes for the columns chosen from the popup menu.
Output Data Column: Checked will include the column of data in the output file, unchecked will not.