Elogix Software Jr. Data Scientist Interview Questions and Answers

Data cleaning involves removing or correcting errors in a dataset to improve its quality and reliability.

• Remove duplicate entries

• Fill in missing values

• Correct inaccuracies or inconsistencies

• Standardize data formats

• Remove outliers

• Normalize data

Joins in SQL are used to combine rows from two or more tables based on a related column between them.

• There are four main types of joins in SQL: INNER JOIN, LEFT JOIN (or LEFT OUTER JOIN), RIGHT JOIN (or RIGHT OUTER JOIN), and FULL JOIN (or FULL OUTER JOIN).

• Joins are used to retrieve data from multiple tables based on a related column between them.

• The JOIN keyword is used in SQL to combine rows from two or more tables b...read more