Data CleansingData De-Duping | Data Standardization | Data ParsingThe terms "data cleansing" and "data scrubbing" are interchangeable; both involve detecting and correcting (or removing) corrupt or inaccurate records from a database. Data cleansing services can transform and combine different data, remove inaccuracies, standardize common values, remove redundancy, parse values and cleanse corrupt data to create consistent, reliable information. |
||
Fig 1. A graphical example of data parsing:Full names are separated into Title, First, Middle, Last, and suffix columns using pattern recognition rules. Some complex parsing projects may require many different rules to get a presentable percentage of successful rate. Fig 2. A graphical example of data standardization: |