Data Preparation & Organization

AddMaple automates data structuring and cleansing because it:

• handles empty cells grouping them off, bypassing the need for placeholder values
• identifies and summarizes diverse data types: numbers, currencies, dates, text, survey questions, duration, multiple choice, multi-select, matrix, opinions, grid questions and more
• recognizes data patterns: multi-select tags, word and phrase clusters within text responses, numeric data distribution and more
• buckets numeric data into appropriate bins based on their range and distribution, while identifying and restricting the impact of outliers
• summarizes double header or matrix columns for comprehensive analysis automatically
• sorts numeric data containing text descriptions, e.g. age categories containing words such as between, younger than, less than, older than etc.
• supports CSV, Excel & SAV (SAV labels and meta data pulled in automatically)