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 |
What are the three types of databases?
Where does the LGWR process writes information?
What is the role of database server in database management system?
What is a hierarchical database?
What is CRUD Operations?
What is an advantage of a database?
What are the steps involved in Database Startup ?
What is compound key?
How do we select distinct values from a table?
What is the difference between shrink database and shrink file?
What is the maximum size of the page ?
What is a clause in terms of sql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)