Cellworks Associate Scientist Interview Questions and Answers

1 hour aptitude test

Q1. What is one hot encoding
Add your answer

Q1. What is your long term goal
Add your answer

Q1. Cross validation
Add your answer
Q2. How to handle imbalanced dataset
Ans. 
Handling imbalanced datasets involves techniques like resampling, using different algorithms, and adjusting class weights.
• Use resampling techniques like oversampling the minority class or undersampling the majority class.

• Utilize algorithms that are robust to imbalanced datasets, such as Random Forest, XGBoost, or SVM.

• Adjust class weights in the model to give more importance to the minority class.

• Use techniques like SMO...read more
Answered by AI
Add your answer

SQL, Python coding …

Given 6 coding qns related to java and html and also ML.

Q1. Explain abt projects and qns related to ML.
Ans. 
Projects in machine learning involve developing algorithms to analyze and interpret data for various applications.
• Developing a recommendation system for an e-commerce website

• Predicting customer churn for a telecommunications company

• Classifying images in a computer vision project

• Anomaly detection in network traffic for cybersecurity

• Natural language processing for sentiment analysis
Answered by AI
Add your answer

Q1. Basic hr qns why straive?
Add your answer

I was asked to write SQL queries for 3rd highest salary of the employee, some name filtering, group by tasks.
Python code to find the index of the maximum number without using numpy.

Q1. Explain the Project undertaken during the research and follow-up questions
Add your answer

Q1. Write pandas query to separate the names as first and last name from the full name. Drop the duplicate columns and also the missing values. Write output for the Python code. Write SQL query to retrieve t...read more
Ans. 
Answering questions related to data science concepts and techniques.
• Recall is the ratio of correctly predicted positive observations to the total actual positives. Precision is the ratio of correctly predicted positive observations to the total predicted positives.

• To reduce variance in an ensemble model, techniques like bagging, boosting, and stacking can be used. Bagging involves training multiple models on different ...read more
Answered by AI
Add your answer

Simple Aptitude questions, Data interpretation and verbal

Q1. Basic questions on Data Analytics, Projects mentioned
Add your answer
Q2. Code in SQL and python(moderate)
Ans. 
The candidate is asked to code in SQL and Python at a moderate level.
• Use SQL to query data from databases

• Use Python to manipulate and analyze data

• Practice writing SQL queries and Python scripts
Answered by AI
Add your answer
Q3. Machine Learning
Add your answer