The data cleansing is a process of correcting the errors lies in the records of a dataset. This error in the records of the dataset may occur due to a deliberate attempt or an inadvertent occurrence including incorrect data entry, inaccurate transfer of data from one system to another, and inappropriate file handling, in structuring the data and deleting the corrupted data. These errors in the records make the data inaccurate and inappropriate for any further use.
The data cleansing process attempts to bring the data back to its original form, or a form where the data can be processed, analyzed and used by managers in decision making processes. The cleansing of data not only includes the rectification of errors but also includes normalization and standardization of the data.