How to Handle Missing Data in a Database?

Answer Posted / hr@tgksolutions.com

One way to deal with missing data in a database is to:

Ignoring: During analysis, ignoring rows with missing values.
Imputing is the process of substituting a default value, mean, median, or value obtained from additional data for missing variables.
Elimination: Taking out rows or columns that contain a significant number of missing values.
Using Placeholders: Using a particular placeholder to indicate missing values

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by buffer manager?

723


What is a relation schema?

684


Is it possible to declare or create a cursor for update of table? If no tell me why?

663


Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

2710


What is blob database?

646


What are dml and ddl statements?

733


Differentiate between nested loop, hash loop and merge join.

643


How do you create a database?

655


What is rdbms and its features?

709


What is dbms language?

680


1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?

1982


Operators used in select statements are?

663


Explain the scenarios or situations under which progress database creates new index entry for a record?

732


What are different types of data models?

699


What is db driver?

667