Flipkart Data Scientist Interview Questions and Answers

Decision tree is a tree-like model of decisions and their possible consequences, while random forest is an ensemble learning method that builds multiple decision trees and merges them together.

• Decision tree is a flowchart-like structure where each internal node represents a decision based on an attribute, each branch represents the outcome of the decision, and each leaf node represents a class label.

• Random forest is a ...read more

Resume points are concise descriptions of your work experience, skills, and achievements listed on your resume.

• Resume points should be clear, specific, and quantifiable.

• Use action verbs to start each point, such as 'developed', 'implemented', 'analyzed'.

• Include relevant metrics or results to demonstrate impact, such as 'increased sales by 20%' or 'reduced processing time by 30%'.

SQL query to find duplicate emails in a table named person

• Use GROUP BY and HAVING clause to group emails and count their occurrences

• Select only those emails which have count greater than 1

• Example: SELECT email, COUNT(*) FROM person GROUP BY email HAVING COUNT(*) > 1;

SQL query to find date ids with higher temperature compared to previous dates in weather table

• Use self join to compare temperature of current date with previous dates

• Order the table by date to ensure correct comparison

• Select date ids where temperature is higher than previous dates