How to Handle Missing Data in a Database?
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 |
Define truncate and delete commands?
What is an advantage of a database?
What is dbms pdf?
What is 1nf 2nf 3nf in dbms?
What is end users in dbms?
Explain snapshot replication.
What is inner join in database?
What is primary key in database?
How to extract metadata for the entire database?
What is sql in database management system?
What are different type of normalization?
What is database write application of database?