Question

Discuss various method for data cleaning

Answer 1

1.Data Auditing: 

The first step towards data cleansing, is the complete auditing of all customer databases.
2.Use Multiple Methods:

The process of auditing of a database should not be limited to analysis through statistical or database methods and additional steps like buying external data and comparing it against internal data can be used.  
3.Consolidate Data: 

The process of cleansing the database should not be limited to just the identification and removal of dirty (inaccurate) data from customer database.

hope it helps!!

Answer 2

$\huge\underline{\overline{\mid{\sf{\pink{AnsWer}}\mid}}}$

• Remove Irrelevant Values. The first and foremost thing you should do is remove useless pieces of data from your system.
• Get Rid of Duplicate Values. Duplicates are similar to useless values – You don't need them.
• Avoid Typos (and similar errors).
• Convert Data Types.
• Take Care of Missing Values.