How to properly perform data cleaning

Asked By 40 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by john sena
Best Answer
Best Answer
Answered By 40 points N/A #128260

How to properly perform data cleaning

qa-featured

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.


 

Answered By 0 points N/A #128262

How to properly perform data cleaning

qa-featured
  • 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.

Login/Register to Answer

Related Questions