Swiggy Data Scientist 2 Interview Questions and Answers

Q1. Questions on Past Project
Add your answer
Q2. SQL Dense Rank - also having the option to do in Pandas
Add your answer
Q3. Pandas groupby on a dataset given - required to calculate group wise yoy rate of a column
Add your answer

Q1. Past project ( which he chose , he chose my very first project , which I had forgotten) so ended up screwing it
Add your answer
Q2. SQL / Pyspark question - difficult question
Add your answer

SQL and Python coding test

Q1. Bagging vs Boosting
Add your answer
Q2. Overfitting and Underfitting in GBDT
Add your answer

Q1. Questions on Recent project
Add your answer
Q2. Deep Learning vs classical ML
Add your answer

Q1. Tell me about your projects?
Add your answer
Q2. How do you approach the project if you are using logistic regression model?
Ans. 
Approach involves data preprocessing, model training, evaluation, and interpretation.
• Perform data preprocessing such as handling missing values, encoding categorical variables, and scaling features.

• Split the data into training and testing sets.

• Train the logistic regression model on the training data.

• Evaluate the model using metrics like accuracy, precision, recall, and F1 score.

• Interpret the model coefficients to under...read more
Answered by AI
Add your answer

Q1. What are you future goals?
Add your answer
Q2. What would you do if your interested field doesnt have any work in the company?
Ans. 
I would seek opportunities to apply my skills in related fields within the company.
• Explore other departments or teams within the company that may have projects related to my field of interest

• Offer to collaborate with colleagues in different departments to bring a new perspective to their projects

• Seek out professional development opportunities to expand my skills and knowledge in related areas
Answered by AI
Add your answer

Q1. Explain all of decision tree and random forest?
Ans. 
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
Answered by AI
Add your answer
Q2. Some basic probability questions
Add your answer

Q1. SQL Window function- hard
Add your answer
Q2. Case study questions answers
Add your answer

Q1. Explain the project
Add your answer

Q1. Explain the project
Add your answer

SQL - shared question on the screen and asked to code in SQL

Q1. Nth highes salary
Add your answer