In data analysis, the fundamental part is the data itself. Related with data collection, there are chances for arrangement, format, spelling errors, duplication, and extra spaces. With the help of data cleansing methods, data analytics is done in the correct format with minimal mistakes. This is done by software still it requires manual monitoring and reviewing.