Simplicontract Data Scientist Interview Questions and Answers

Build a simple cat and dog image classifier

Q1. ML related questions
Add your answer

Q1. Behavioural questions, basically to check if you will be fit in a team
Add your answer

Q1. ML System design
Add your answer
Q2. CNN networks why are they better then NN
Add your answer

Q1. A SQL question that involves window functions
Ans. 
SQL window functions allow for advanced data analysis by performing calculations across a set of table rows related to the current row.
• Window functions operate on a set of rows defined by an OVER() clause.

• Common window functions include ROW_NUMBER(), RANK(), and SUM().

• Example: SELECT employee_id, salary, RANK() OVER (ORDER BY salary DESC) AS salary_rank FROM employees;

• Window functions can be used for running totals, mo...read more
Answered by AI
Add your answer
Q2. Python coding round that involved string manipulation
Add your answer

Q1. Basic Recommendation System Questions
Add your answer
Q2. A B Testing Questions
Add your answer

Simple mediam DSA style questions around ML

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
Ans. 
Calculate year-over-year (YoY) rates using Pandas groupby for a specific column in a dataset.
• Use the Pandas 'groupby' method to group data by the desired category (e.g., 'year').

• Apply the 'pct_change()' function to calculate the percentage change between years.

• Example: df.groupby('year')['sales'].sum().pct_change() to get YoY sales growth.

• Ensure the data is sorted by year before applying the calculation for accurate re...read more
Answered by AI
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

Case study design oka6y

Q1. Case study explain
Ans. 
A case study involves analyzing a specific situation to derive insights and solutions using data science techniques.
• Define the problem clearly: Identify the key issues to address.

• Collect relevant data: Gather data from various sources, ensuring quality and relevance.

• Analyze the data: Use statistical methods and machine learning to uncover patterns.

• Draw insights: Interpret the results to provide actionable recommendatio...read more
Answered by AI
Add your answer
Q2. Ml concept advance
Add your answer

Q1. Lot of questions on classification and regression models, medium python and pandas, no need of DSA
Add your answer
Q2. Questions from assignment (first step will be to submit assignment given by them)
Add your answer