How to Handle Missing Data in a Database?
- 1 Answers
- 404 Views
- I also Faced
- E-Mail Answers
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 procedures in dbms?
Do we consider null values the same as that of blank space or zero?
What is rdbms and its features?
What is ordbms with example?
What is the best database to use?
What are fact tables and dimension tables ? What is dimensional modeling and star schema design
What is a foreign key constraint?
What is a clause in terms of sql?
Explain bcnf (boyce-codd normal form)?
Explain the term generalization.
All questions related to Control m monitoring tool
What are the advantages of using Query Strings?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
