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 |
How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?
What is the example of rdbms?
What do you understand by the view and mention the steps to create, update and drop a view?
Where is the database stored?
What is the meaning of flat file database?
How do I create a database in open office?
What do you understand by correlated subqueries in dbms?
What is the purpose of a model?
What is the difference between oracle CPU and PSU?
What is openedge abl in terms of taking the perspective of the developer?
What do you understand by index hunting?
What is netlib for clipper?
Oracle (3259)
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)