How to properly perform data cleaning

Asked By m.smith 40 points N/A Posted on - 06/28/2011

Hi guys M.Smith is here I am preparing my MCS notes and during studies I am facing few problem and I want to share then with all of you may be anyone can help me in this case What is data cleaning? How can we do that? My friend Send me its answer but I am not satisfy from his answer that’s why I share my problem all of you. So please solve my problem as soon as possible. Thanks in advance.

• Status: Open
• Question Views: 924
• Answer Count: 2
• Vote Up 2 Vote Down

• Answer Accepted: Yes
• Question Category: Windows XP

Best Answer by john sena

Go To Solution

Best Answer

Best Answer

Answered By john sena 40 points N/A #128260

How to properly perform data cleaning

Hi my name is John Sena.

Data cleaning is also known as data scrubbing. Data cleaning is a process which ensures the set of data is correct and accurate. Data accuracy and consistency, data integration is checked during data cleaning. Data cleaning can be applied for a set of records or multiple sets of data which need to be merged. Data cleaning is performed by reading all records in a set and verifying their accuracy. Typing and spelling errors are rectified. Mislabeled data if available is labeled and filed. Incomplete or missing entries are completed. Unrecoverable records are purged, for not to take space and inefficient operations. Methods:- Parsing – Used to detect syntax errors. Data Transformation – Confirms that the input data matches in format with expected data. Duplicate elimination – This process gets rid of duplicate entries. Statistical Methods- values of mean, standard deviation, range, or clustering algorithms etc are used to find erroneous data.

 

About john sena

Questions
17

Answers
18

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 06/28/2011
• Question Category: Windows XP

Answered By robort paul 0 points N/A #128262

How to properly perform data cleaning

• Data cleaning is to remove the data form you PC that is being corrupt during a process. This data is then removed from the computer memory using the data cleaning technique.
• It is mostly used in Data bases when some bad records are in data entry once some bad data is found then this data is removed from computer and this process is called data cleaning.
• If data in the hard disk require cleaning then there are different tools also available in windows which are used for the process of data cleaning these tools remove bad sectors form PC and make its memory efficient so that it can be used easily. One such tool is Disk defragmenter.

About robort paul

Questions
0

Answers
16

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/04/2011
• Question Category: Windows XP