all_company_interview.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "Company: Google\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "Why do you use feature selection?\n",
    "What is the effect on the coefficients of logistic regression if two 3. predictors are highly correlated?\n",
    "What are the confidence intervals of the coefficients?\n",
    "What’s the difference between Gaussian Mixture Model and K-Means?\n",
    "How do you pick k for K-Means?\n",
    "How do you know when Gaussian Mixture Model is applicable?\n",
    "Assuming a clustering model’s labels are known, how do you evaluate the performance of the model?\n",
    "\n",
    "\n",
    "\n",
    "Company: Uber\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "Pick any product or app that you really like and describe how you would improve it.\n",
    "How would you find an anomaly in a distribution ?\n",
    "How would you go about investigating if a certain trend in a distribution is due to an anomaly?\n",
    "How would you estimate the impact Uber has on traffic and driving conditions?\n",
    "What metrics would you consider using to track if Uber’s paid advertising strategy to acquire new customers actually works? How would you then approach figuring out an ideal customer acquisition cost?\n",
    " \n",
    "\n",
    "Company: TCS\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "Explain about Time series models you have used?\n",
    "SQL Questions - Group by Top 2 Salaries for Employees - use Row num and Partition\n",
    "Pandas find Numeric and Categorical Columns. For Numeric columns in Data frame, find the mean of the entire column and add that mean value to each row of those numeric columns.\n",
    "What is Gradient Descent? What is Learning Rate and Why we need to reduce or increase? Why Global minimum is reached and Why it doesn’t improve when increasing the LR after that point?\n",
    "What is Log-Loss and ROC-AUC?\n",
    "What is Multi-collinearity? How will you choose one features if there are 2 highly correlated features? Give Examples with the techniques used.\n",
    "VIF – Variance Inflation Factor – Explain.\n",
    "Do you know to use Amazon SageMaker for MLOPS?\n",
    "Explain your Projects end to end (15-20mins).\n",
    " \n",
    "\n",
    "Company: Capital One\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "How would you build a model to predict credit card fraud?\n",
    "How do you handle missing or bad data?\n",
    "How would you derive new features from features that already exist?\n",
    "If you’re attempting to predict a customer’s gender, and you only have 100 data points, what problems could arise?\n",
    "Suppose you were given two years of transaction history. What features would you use to predict credit risk?\n",
    "Design an AI program for Tic-tac-toe\n",
    "Explain overfitting and what steps you can take to prevent it.\n",
    "Why does SVM need to maximize the margin between support vectors? \n",
    "\n",
    "\n",
    "\n",
    "Company: Latentview Analytics\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    "Experience: 2 years\n",
    "\n",
    " \n",
    "\n",
    "What is mean and median\n",
    "Difference between normal and gaussian\n",
    "distribution\n",
    "\n",
    "What is central limit theorem\n",
    "What is null hypothesis\n",
    "What is confidence interval\n",
    "What is covariance and correlation and how will u\n",
    "interpret it.\n",
    "\n",
    "How will you find out the outliers in the dataset\n",
    "and is it always to remove outliers\n",
    "\n",
    "Explain about Machine Learning\n",
    "Explain the algorithm of your choice\n",
    "Different methods of missing values imputation\n",
    "Explain me your ml project\n",
    "How did you handle imbalance dataset\n",
    "What is stratified samplings\n",
    "Difference between standard scalar and normal\n",
    "scalar\n",
    "\n",
    "Company: Verizon\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "    How many cars are there in Chennai? How do u structurally approach coming up with that number?\n",
    "    Multiple Linear Regression?\n",
    "    OLS vs MLE?\n",
    "    R2 vs Adjusted R2? During Model Development which one do we consider?\n",
    "    Lift chart, drift chart\n",
    "    Sigmoid Function in Logistic regression\n",
    "    ROC what is it? AUC and Differentiation?\n",
    "    Linear Regression from Multiple Linear Regression\n",
    "    P-Value what is it and its significance? What does P in P-Value stand for? What is Hypothesis Testing? Null hypothesis vs Alternate Hypothesis?\n",
    "Bias Variance Trade off?\n",
    "Over fitting vs Underfitting in Machine learning?\n",
    "Estimation of Multiple Linear Regression\n",
    "Forecasting vs Prediction difference? Regression vs Time Series?\n",
    "p,d,q values in ARIMA models\n",
    "\n",
    "\n",
    "\n",
    "Company: Fractal\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "1.Difference between array and list\n",
    "\n",
    "2.Map function\n",
    "\n",
    "Scenario,\n",
    "if coupon distributed randomly to customers of swiggy, how to check there buying behavior.\n",
    "\n",
    "Use segmenting customers\n",
    "\n",
    "Compare customers who got coupon and who did not\n",
    "\n",
    "Which is faster dictionary or list for look up\n",
    "How to merge two arrays\n",
    "How much time svm takes to complete if 1 iteration takes 10sec for 1st class.\n",
    "And there are 4 classes.\n",
    "\n",
    "Kernals in svm, there difference\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company name: Infosys\n",
    "\n",
    "Role: Data scientist\n",
    "\n",
    " \n",
    "\n",
    "1) curse of dimensionality? How would you handle it?\n",
    "\n",
    "2) How to find the multi collinearity in the data set\n",
    "\n",
    "3)Explain the difference ways to treat multi collinearity!\n",
    "\n",
    "4) How you decide which feature to keep and which feature to eliminate after performing multi collinearity test?\n",
    "\n",
    "5)Explain logistic regression\n",
    "\n",
    "6)we have sigmoid function which gives us the probabilty between 0-1 then what is the need of logloss in logistic regression?\n",
    "\n",
    "7) P value and its significance in statistical testing?\n",
    "\n",
    "8) How do you split the time series data and evaluation metrics for time series data\n",
    "\n",
    "9) How did you deploy your model in production? How often do you retrain it?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Wipro\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "Difference between WHERE and HAVING in SQL\n",
    "Basics of Logistics Regression\n",
    "How do you treat outliers ?\n",
    "Explain confusion matrix ?\n",
    "Explain PCA (Wanted me to explain the co-variance matrix and eigen vectors and values and the mathematical expression and mathematical derivation for co-variance matrix)\n",
    "How do you cut a cake into 8 equal parts using only 3 straight cuts ?\n",
    "Explain kmeans clustering\n",
    "How is KNN different from k-means clustering?\n",
    "What would be your strategy to handle a situation indicating an imbalanced dataset?\n",
    "Stock market prediction: You would like to predict whether or not a certain company will declare bankruptcy within the next 7 days (by training on data of similar companies that had previously been at risk of bankruptcy). Would you treat this as a classification or a regression problem?\n",
    "\n",
    "\n",
    "\n",
    "Company: Accenture\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "What is difference between K-NN and K-Means clustering?\n",
    "How to handle missing data? What imputation techniques can be used?\n",
    "Explain topic modelling in NLP and various methods in performing topic modeling.\n",
    "Explain how you would find and tackle an outlier in the dataset.\n",
    "Follow up: What about inlier?\n",
    "Explain back propagation in few words and its variants?\n",
    "Is interpretability important for machine learning model? If so, ways to achieve interpretability for a machine learning models?\n",
    "Is interpretability important for machine learning model? If so, ways to achieve interpretability for a machine learning models?\n",
    "How would you design a data science pipeline?\n",
    "Explain bias - variance trade off. How does this affect the model?\n",
    "What does a statistical test do?\n",
    "How to determine if a coin is biased? Hint: Hypothesis testing \n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Tiger Analytics\n",
    "\n",
    "Role: Senior Analyst\n",
    "\n",
    " \n",
    "\n",
    "What is deep learning, and how does it contrast with other machine learning algorithms?\n",
    "2.When should you use classification over regression?\n",
    "\n",
    "3.Using Python how do you find Rank, linear and tensor equations for an given array of elements? Explain your approach.\n",
    "\n",
    "4.What exactly do you know about Bias-Variance decomposition? 5.What is the best recommendation technique you have learnt and what type of recommendation technique helps to predict ratings? 6.How can you assess a good logistic model?\n",
    "\n",
    "7.How to you read the text from an image? Explain?\n",
    "\n",
    "8.What are all the options to convert speech to text? Explain and name few available tools to implement the same?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "My checklist before going for an SQL round of interview:\n",
    "\n",
    " \n",
    "\n",
    "WHERE , AND, OR, NOT, IN\n",
    "ORDER BY, ASC, DESC\n",
    "IS NULL\n",
    "LIMIT\n",
    "MIN, MAX, COUNT, AVG, SUM\n",
    "LIKE, WILDCARDS\n",
    "IN BETWEEN\n",
    "INNER JOIN\n",
    "LEFT JOIN\n",
    "Subqueries(most important)\n",
    "UNION\n",
    "GROUP BY\n",
    "HAVING\n",
    "LEFT, RIGHT, MID, CONCAT\n",
    "PARTITION BY, OVER\n",
    "LEAD,LAG\n",
    "RANK, DENSE_RANK, PERCENT_RANK\n",
    "ROW_NUMBER, CUME_DIST\n",
    "FIRST_VALUE, LAST_VALUE\n",
    "AS\n",
    "\n",
    "\n",
    "\n",
    "Company Name : Tata IQ\n",
    "\n",
    "Role: Data Analyst\n",
    "\n",
    " \n",
    "\n",
    "Why data science as a career?\n",
    "\n",
    "Stats:\n",
    "\n",
    "What is p value?\n",
    "\n",
    "What is histograms?\n",
    "\n",
    "What is confidence interval?\n",
    "\n",
    "You are a Sr data analyst at a new Online Cab booking Startups\n",
    "\n",
    "How you will do data collection and how you will leverage the data to give useful insights to the Company?\n",
    "\n",
    "Guestimate: No Of cabs booking per day in Ranchi\n",
    "\n",
    "You are product head manager(not remember exactly) at a NBFC which gives a Secured loans what factors will you consider giving loan to ?\n",
    "\n",
    "Inventory Database based on that have to do basic pandas/sql query? Joins / merge to get avg sales, its chart?\n",
    "\n",
    "You have a list of 3 numbers return the min diff. Can use any python/sql\n",
    "\n",
    "What is Big Data?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Role: Junior Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "1) Explain the architecture of CNN\n",
    "\n",
    "2)If we put a 3×3 filter over 6×6 image what will be the size of the output image\n",
    "\n",
    "3) What will you do to reduce overfitting In deep learning models\n",
    "\n",
    "3) Can you write a program for inverted star program in python\n",
    "\n",
    "4)Write a program to create a dataframe and remove elements from it\n",
    "\n",
    "5) I have 2 guns with 6 holes in each, and I load a single bullet In each gun, what is the probability that if I fire the guns simultaneously atleast 1 gun will fire (atleast means one or more than one)\n",
    "\n",
    "5) There are 2 groups g1 and g2, g1 will ask g2 members to give them 1 member so thay they both will be equal in number, g2 will ask g1 members to give them 1 member so thay they will be double of g1, how many members are there in the groups (I'm not sure of this question as I tried to solve but didnt get correct answer)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Some Data Science Companies(not ranked) for Job Hunting:\n",
    "\n",
    " \n",
    "\n",
    "Genpact\n",
    "Tredence Analytics\n",
    "Fractal Analytics\n",
    "Tiger Analytics\n",
    "Bridgei2i\n",
    "Ugam\n",
    "Latent View\n",
    "Brillio\n",
    "Abzooba\n",
    "AbsolutData\n",
    "Gramemer\n",
    "BluePi\n",
    "Knowledge Foundry\n",
    "Wipro\n",
    "TCS\n",
    "Accenture\n",
    "Purplle\n",
    "AbsoluteData\n",
    "Hansa CEquity\n",
    "Lymbyc\n",
    "IBM\n",
    "PwC\n",
    "EY\n",
    "KPMG\n",
    "Sibia\n",
    "ZS\n",
    "ZF\n",
    "TechVantage\n",
    "L&T Infotech\n",
    "Cognizant\n",
    "Amazon\n",
    "Microsoft\n",
    "Walmart\n",
    "Philips\n",
    "Ford\n",
    "JP Morgan\n",
    "Deloitte\n",
    "Shell\n",
    "Mu Sigma\n",
    "Postman\n",
    "Altrix\n",
    "HP\n",
    "HCL\n",
    "Dell\n",
    "Paypal\n",
    "Fidelity Investments\n",
    "Rakuten\n",
    "Infosys\n",
    "Flipkart\n",
    "Myntra\n",
    "\n",
    "\n",
    "\n",
    "Company: Mindtree\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "What is central tendency\n",
    "Which central tendency method is used If there exists any outliers\n",
    "Central limit theorem\n",
    "Chi-Square test\n",
    "A/B testing\n",
    "Difference between Z and t distribution (Linked to A/B testing)\n",
    "Outlier treatment method\n",
    "ANOVA test\n",
    "Cross validation\n",
    "How will you work in a machine learning project if there is a huge imbalance in the data\n",
    "Formula of sigmoid function\n",
    "Can we use sigmoid function in case of multiple classification\n",
    "What is Area under the curve\n",
    "Which metric is used to split a node in Decision Tree\n",
    "What is ensemble learning\n",
    "3 situation based questions\n",
    "\n",
    "\n",
    "\n",
    "Company: Genpact\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "Why do we select validation data other than test data?\n",
    "Difference between linear logistic regression?\n",
    "Why do we take such a complex cost function for logistic?\n",
    "Difference between random forest and decision tree?\n",
    "How would you decide when to stop splitting the tree?\n",
    "Measures of central tendency\n",
    "What is the requirement of k means algorithm\n",
    "Which clustering technique uses combining of clusters\n",
    "Which is the oldest probability distribution\n",
    "What all values does a random variable can take\n",
    "Types of random variables\n",
    "Normality of residuals\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Ford\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "How would you check if the model is suffering from multi Collinearity?\n",
    "What is transfer learning? Steps you would take to perform transfer learning.\n",
    "Why is CNN architecture suitable for image classification? Not an RNN?\n",
    "What are the approaches for solving class imbalance problem?\n",
    "When sampling what types of biases can be inflected? How to control the biases?\n",
    "Explain concepts of epoch, batch, iteration in machine learning.\n",
    "What type of performance metrics would you choose to evaluate the different classification models and why?\n",
    "What are some of the types of activation functions and specifically when to use them? \n",
    "What are the conditions that should be satisfied for a time series to be stationary?\n",
    "What is the difference between Batch and Stochastic Gradient Descent?\n",
    "What is difference between K-NN and K-Means clustering?\n",
    "\n",
    "\n",
    "\n",
    "Company: Quantiphi\n",
    "\n",
    "Role: Machine Learning Engineer\n",
    "\n",
    " \n",
    "\n",
    "What happens when neural nets are too small? What happens when they are large enough?\n",
    "Why do we need pooling layer in CNN? Common pooling methods?\n",
    "Are ensemble models better than individual models? Why/why - not?\n",
    "Use Case - Consider you are working for pen manufacturing company. How would you help sales team with leads using Data analysis?\n",
    "Assume you were given access to a website google analytics data.\n",
    "In order to increase conversions, how do you perform A/B testing to identify best page design.\n",
    "How is random forest different from Gradient boosting algorithm, given both are tree-based algorithm?\n",
    "Describe steps involved in creating a neural network?\n",
    "In brief, how would you perform the task of sentiment analysis? \n",
    "\n",
    "\n",
    "\n",
    "Company: TheMathCompany\n",
    "\n",
    "Role: Analyst (Data Science)\n",
    "\n",
    " \n",
    "\n",
    "Central limit theorem\n",
    "Hypotheses testing\n",
    "P value\n",
    "T-test\n",
    "Assumptions of linear regression.\n",
    "Correlation and covariance.\n",
    "How to identify & treat outliers and missing values.\n",
    "Explain Box and whisker plot.\n",
    "Explain any unsupervised learning algorithm.\n",
    "Explain Random forest.\n",
    "Business and technical questions related to your project.\n",
    "Explain any scope of improvement in your project.\n",
    "Questions based on case studies.\n",
    "Write SQL query to find employee with highest salary in each department.\n",
    "Write SQL query to find unique email domain name & their respective count\n",
    "Solve question (17) using Python.\n",
    " \n",
    "\n",
    "Rounds:\n",
    "\n",
    "Technical Test (Python, SQL, Statistics) (Coding+MCQ) (90 min).\n",
    "Telephonic interview (10 min).\n",
    "Technical interview (45 min).\n",
    "Fitment interview (25 min).\n",
    "HR interview (30 min).\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Cognizant\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "SQL question on inner join and cross join\n",
    "SQL question on group-by\n",
    "Case study question on customer optimization of records for different marketing promotional offers\n",
    "Tuple and list\n",
    "Linear regression\n",
    "Logistic regression steps and process\n",
    "Tell me about your passion for data science? Or What brought you to this field?\n",
    "What is the most common problems you face whilst working on data science projects?\n",
    "Describe the steps to take to forecast quarterly sales trends. What specific models are most appropriate in this case?\n",
    "What is the difference between gradient and slope, differentiation and integration?\n",
    "When to use deep learning instead of machine learning. Advantages, Disadvantages of using deep learning?\n",
    "What are vanishing and exploding gradients in neural networks?\n",
    "\n",
    "\n",
    "\n",
    "Company: Husqvarna Group\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "Telecom Customer Churn Prediction. Explain the project end to end?\n",
    "Data Pre-Processing Steps used.\n",
    "Sales forecasting how is it done using Statistical vs DL models - Efficiency.\n",
    "Logistic Regression - How much percent of Customer has churned and how much have not churned? \n",
    "What are the Evaluation Metric parameters for testing Logistic Regression? \n",
    "What packages in Python can be used for ML? Why do we prefer one over another?\n",
    "Numpy vs Pandas basic difference.\n",
    "Feature on which this Imputation was done, and which method did we use there?\n",
    "Tuple vs Dictionary. Where do we use them?\n",
    "What is NER - Named Entity Recognition?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Deloitte\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "Conditional Probability\n",
    "Can Linear Regression be used for Classification? If Yes, why if No why?\n",
    "Hypothesis Testing. Null and Alternate hypothesis\n",
    "Derivation of Formula for Linear and logistic Regression\n",
    "Why use Decision Trees?\n",
    "PCA Advantages and Disadvantages?\n",
    "What is Naive Bayes Theorem? Multinomial, Bernoulli, Gaussian Naive Bayes.\n",
    "Central Limit Theorem? \n",
    "Scenario based question on when to use which ML model?\n",
    "Over Sampling and Under Sampling\n",
    "Over Fitting and Under Fitting\n",
    "Core Concepts behind Each ML model mentioned in my Resume.\n",
    "Genie Index Vs Entropy\n",
    "how to deal with imbalance data in classification modelling?\n",
    "\n",
    "\n",
    "\n",
    "Company: Wipro\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "What is a Python Package, and Have you created your own Python Package?\n",
    "Explain about Time series models you have used?\n",
    "SQL Questions - Group by Top 2 Salaries for Employees - use Row num and Partition\n",
    "Pandas find Numeric and Categorical Columns. For Numeric columns in Data frame, find the mean of the entire column and add that mean value to each row of those numeric columns.\n",
    "What is Gradient Descent? What is Learning Rate and Why we need to reduce or increase? Why Global minimum is reached and Why it doesn’t improve when increasing the LR after that point?\n",
    "Two Logistic Regression Models - Which one will you choose - One is trained on 70% and other on 80% data. Accuracy is almost same.\n",
    "What is Log-Loss and ROC-AUC?\n",
    "Do you know to use Amazon SageMaker for MLOPS?\n",
    "Explain your Projects end to end (15-20mins).\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Infosys\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "1) Measures of central tendency\n",
    "\n",
    "2) What is the requirement of k means algorithm\n",
    "\n",
    "3) Which clustering technique uses combining of clusters\n",
    "\n",
    "4) Which is the oldest probability distribution\n",
    "\n",
    "5) What all values does a random variable can take\n",
    "\n",
    "6) Types of random variables\n",
    "\n",
    "7) Normality of residuals\n",
    "\n",
    "8) Probability questions\n",
    "\n",
    "9) Sensitivity and specificity etc.\n",
    "\n",
    "10) Explain bias - variance trade off. How does this affect the model? \n",
    "\n",
    "11) What is multi collinearity? How to identify and remove it.\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Tiger Analytics\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "What are the projects done by you.\n",
    "Suppose there is a client who wants to know if giving discounts is beneficial or not. How would you approach this problem?\n",
    "The same client want to know how much discount he should give in the next month for maximum profits.\n",
    "Can you have a modeling approach to say in last year what mistakes client did in giving discounts. Meaning if they should have have a different discount and increased sales.\n",
    "What feature engineering techniques you used in past projects.\n",
    "What models you used and selected the final model.\n",
    "\n",
    "\n",
    "\n",
    "Company: Genpact\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "What makes you feel that you would be suitable for this role, since you come from a different background?\n",
    "What is an imbalanced data set??\n",
    "What are the factors you will consider in order to predict the population of a city in the future?\n",
    "Basic statistics questions?\n",
    "What are the approaches for treating the missing values?\n",
    "Evaluation metrics for Classification?\n",
    "Bagging vs Boosting with examples\n",
    "Handling of imbalanced datasets\n",
    "What are your career aspirations?\n",
    "10.What's the graph of y = |x|-2\n",
    "\n",
    "esstimate on no. Of petrol cars in Delhi\n",
    "12.Case study on opening a retail store\n",
    "\n",
    "13.Order of execution of SQL\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Ericsson\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "Round No: 1st Round\n",
    "\n",
    " \n",
    "\n",
    "How to reverse a linked list\n",
    "\n",
    " \n",
    "\n",
    "Give a logistic regression model in production, how would you find out the coefficients of different input features.\n",
    "\n",
    " \n",
    "\n",
    "What is the p- value in OLS regression\n",
    "\n",
    " \n",
    "\n",
    "What's the reason for high bias or variance\n",
    "\n",
    " \n",
    "\n",
    "Which models are generally high biased or high variance\n",
    "\n",
    " \n",
    "\n",
    "Write code to find the 8 highest value in the DataFrame\n",
    "\n",
    " \n",
    "\n",
    "What's difference between array and list\n",
    "\n",
    " \n",
    "\n",
    "Whats the difference between Gradient boosting and Xgboost\n",
    "\n",
    " \n",
    "\n",
    "Is XOR data linearly separable\n",
    "\n",
    " \n",
    "\n",
    "How do we classify XOR data using logistic regression\n",
    "\n",
    " \n",
    "\n",
    "Some questions from my previous projects\n",
    "\n",
    " \n",
    "\n",
    "Given a sand timer of 4 and 7 mins how would you calculate 10 mins duration.\n",
    "\n",
    " \n",
    "\n",
    "What's the angle between hour and minute hand in clock as 3:15\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: FISERVE\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "How would you check if the model is suffering from multi Collinearity?\n",
    "What is transfer learning? Steps you would take to perform transfer learning.\n",
    "Why is CNN architecture suitable for image classification? Not an RNN?\n",
    "What are the approaches for solving class imbalance problem?\n",
    "When sampling what types of biases can be inflected? How to control the biases?\n",
    "Explain concepts of epoch, batch, iteration in machine learning.\n",
    "What type of performance metrics would you choose to evaluate the different classification models and why?\n",
    "What are some of the types of activation functions and specifically when to use them? \n",
    "What is the difference between Batch and Stochastic Gradient Descent?\n",
    "What is difference between K-NN and K-Means clustering?\n",
    "How to handle missing data? What imputation techniques can be used?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Landmark group\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "Use Case - Consider you are working for pen manufacturing company. How would you help sales team with leads using Data analysis?\n",
    "Interviewers ask about scenarios or use-case based questions to know interviewee thought process and problem-solving skills.\n",
    "Assume you were given access to a website google analytics data.\n",
    "In order to increase conversions, how do you perform A/B testing to identify best page design.\n",
    "How is random forest different from Gradient boosting algorithm, given both are tree-based algorithm?\n",
    "Describe steps involved in creating a neural network?\n",
    "LSTM solves the vanishing gradient problem, that RNN primarily have. How?\n",
    "In brief, how would you perform the task of sentiment analysis?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Axtria\n",
    "\n",
    "------------\n",
    "\n",
    "1.RNN, NN and CNN difference.\n",
    "\n",
    "Supervised, unsupervised and reinforcement learning with there algo example.\n",
    "Difference between ai, ml and dl\n",
    "How u do dimentionality reduction.\n",
    "What is Multicollinearity\n",
    "Parameters of random forest\n",
    "7 . Parameters of deep learning algos\n",
    "\n",
    "Different feature selection methods\n",
    "Confusion matrix\n",
    "\n",
    "\n",
    "\n",
    "Company: Latentview Analytics\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    "Experience: 2 years\n",
    "\n",
    " \n",
    "\n",
    "What is mean and median\n",
    "Difference between normal and gaussian\n",
    "distribution\n",
    "\n",
    "What is central limit theorem\n",
    "What is null hypothesis\n",
    "What is confidence interval\n",
    "What is covariance and correlation and how will u\n",
    "interpret it.\n",
    "\n",
    "How will you find out the outliers in the dataset\n",
    "and is it always to remove outliers\n",
    "\n",
    "Explain about Machine Learning\n",
    "Explain the algorithm of your choice\n",
    "Different methods of missing values imputation\n",
    "Explain me your ml project\n",
    "How did you handle imbalance dataset\n",
    "What is stratified samplings\n",
    "Difference between standard scalar and normal\n",
    "scalar\n",
    "\n",
    "Different type of visualization in Dl project\n",
    "What architecture have you used\n",
    "Why have u not used RNN in your nlp project\n",
    "Why we don't prefer CNN in nlp based project\n",
    "19 What is exploding gradient and vanishing gradient and how to rectify it\n",
    "\n",
    "Difference between LSTM and GRU\n",
    "What is precision and recall\n",
    "22 What is auc metic\n",
    "\n",
    "What if your precision and recall are same\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "What is Bias Variance Trade Off?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Bridgei2i\n",
    "\n",
    "Role: Senior Analytics Consultant\n",
    "\n",
    " \n",
    "\n",
    "1)    What is the difference between Cluster and Systematic Sampling?\n",
    "\n",
    "2)    Differentiate between a multi-label classification problem and a multi-class classification problem.\n",
    "\n",
    "3)    How can you iterate over a list and also retrieve element indices at the same time?\n",
    "\n",
    "4)    What is Regularization and what kind of problems does regularization solve?\n",
    "\n",
    "5)    If the training loss of your model is high and almost equal to the validation loss, what does it mean? What should you do?\n",
    "\n",
    "6)    Explain evaluation protocols for testing your models? Compare hold-out vs k-fold cross validation vs iterated k-fold cross-validation methods of testing.\n",
    "\n",
    "7)    Can you cite some examples where a false positive is important than a false negative?\n",
    "\n",
    "8)    What is the advantage of performing dimensionality reduction before fitting an SVM?\n",
    "\n",
    "9)    How will you find the correlation between a categorical variable and a continuous variable ?\n",
    "\n",
    "10)   How will you calculate the accuracy of a model using a confusion matrix?\n",
    "\n",
    "11)   You are given a dataset with 1500 observations and 15 features. How many observations you will select in each decision tree in a random forest?\n",
    "\n",
    "12)   Given that you let the models run long enough, will all gradient descent algorithms lead to the same model when working with Logistic or Linear regression problems?\n",
    "\n",
    "13)    What do you understand by statistical power of sensitivity and how do you calculate it?\n",
    "\n",
    "14)    What is pruning, entropy and information gain in decision tree algorithm?\n",
    "\n",
    "15)    What are the types of biases that can occur during sampling?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Prodapt Solutions\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "    Telecom Customer Churn Prediction. Explain the project end to end?\n",
    "    Data Pre-Processing Steps used.\n",
    "    Sales forecasting how is it done using Statistical vs DL models - Efficiency.\n",
    "    Logistic Regression - How much percent of Customer has churned and how much have not churned? \n",
    "    What are the Evaluation Metric parameters for testing Logistic Regression? \n",
    "    What packages in Python can be used for ML? Why do we prefer one over another?\n",
    "    Numpy vs Pandas basic difference.\n",
    "    Feature on which this Imputation was done, and which method did we use there?\n",
    "    Tuple vs Dictionary. Where do we use them?\n",
    "What is NER - Named Entity Recognition?\n",
    "\n",
    "\n",
    "\n",
    "Company: Landmark group\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "    SQL question on inner join and cross join\n",
    "    SQL question on group-by\n",
    "    Case study question on customer optimization of records for different marketing promotional offers\n",
    "    Tuple and list\n",
    "    Linear regression\n",
    "    Logistic regression steps and process\n",
    "    Tell me about your passion for data science? Or What brought you to this field?\n",
    "    What is the most common problems you face whilst working on data science projects?\n",
    "    Describe the steps to take to forecast quarterly sales trends. What specific models are most appropriate in this case?\n",
    "  What is the difference between gradient and slope, differentiation and integration?\n",
    "  When to use deep learning instead of machine learning. Advantages, Disadvantages of using deep learning?\n",
    "  What are vanishing and exploding gradients in neural networks?\n",
    "  What happens when neural nets are too small? What happens when they are large enough?\n",
    "  Why do we need pooling layer in CNN? Common pooling methods?\n",
    "  Are ensemble models better than individual models? Why/why - not?\n",
    "\n",
    "\n",
    "\n",
    "Company: Mindtree\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "What is central tendency\n",
    "Which central tendency method is used If there exists any outliers\n",
    "Central limit theorem\n",
    "Chi-Square test\n",
    "A/B testing\n",
    "Difference between Z and t distribution (Linked to A/B testing)\n",
    "Outlier treatment method\n",
    "ANOVA test\n",
    "Cross validation\n",
    "How will you work in a machine learning project if there is a huge imbalance in the data\n",
    "Formula of sigmoid function\n",
    "Can we use sigmoid function in case of multiple classification (I said no)\n",
    "Then which function is used\n",
    "What is Area under the curve\n",
    "Which metric is used to split a node in Decision Tree\n",
    "What is ensemble learning\n",
    "3 situation based questions\n",
    "\n",
    "\n",
    "\n",
    "Company: CodeBase Solutions\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "    What are the ML techniques you've used in projects?\n",
    "    Very first question was PCA? Why use PCA?\n",
    "    Types of Clustering techniques (Not algorithms)? Which Clustering techniques will you use in which Scenario - example with a Program?\n",
    "    OCR - What type of OCR did you use in your project - Graphical or Non - Graphical?\n",
    "    OCR - What is a Noise? What types of noise will you face when performing OCR? Handwritten can give more than 70% accuracy when I wrote in 2012 but you're saying 40%.\n",
    "    Logistic Regression vs Linear Regression with a real-life example - explain?\n",
    "    Is Decision tree Binary or multiple why use them?\n",
    "    Do you know Map Reduce and ETL concepts?\n",
    "    What is a Dictionary or Corpus in NLP and how do you build it? \n",
    "How do you basically build a Dictionary, Semantic Engine, Processing Engine in a NLP project, where does all the Synonyms (Thesaurus words go).\n",
    "What are the Types of Forecasting? What are the ML and DL models for forecasting (He said Fast-forwarding models as example) other than Statistical (ARIMA) models you've used in your projects?\n",
    "What is a Neural Network? Types of Neural Networks you know?\n",
    "Write a Decision Tree model with a Python Program.\n",
    "How do you build an AZURE ML model? What are all the Azure products you've used? I said Azure ML Studio.\n",
    "Cibil score is an example for Fuzzy model and not a Classification model.\n",
    "What is an outlier give a real life example? how do you find them and eliminate them? I gave an example of calculating Average salary of an IT employee. \n",
    "\n",
    "\n",
    "\n",
    "Company: Deloitte\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "    G values, P values, T values\n",
    "    Conditional Probability\n",
    "    Central Values of Tendency\n",
    "    Can Linear Regression be used for Classification? If Yes, why if No why?\n",
    "    Hypothesis Testing. Null and Alternate hypothesis\n",
    "    Derivation of Formula for Linear and logistic Regression\n",
    "    Where to start a Decision Tree. Why use Decision Trees?\n",
    "    PCA Advantages and Disadvantages?\n",
    "    Why Bayes theorem? DB Bayes and Naïve Bayes Theorem?\n",
    "Central Limit Theorem? \n",
    "R packages in and out? For us it's Python Packages in and out.\n",
    "Scenario based question on when to use which ML model?\n",
    "Over Sampling and Under Sampling\n",
    "Over Fitting and Under Fitting\n",
    "Core Concepts behind Each ML model.\n",
    "Genie Index Vs Entropy\n",
    "how to deal with imbalance data in classification modelling? SMOTHE techniques\n",
    "\n",
    "\n",
    "\n",
    "Verizon Data Science Interview Questions\n",
    "\n",
    " \n",
    "\n",
    "    How many cars are there in Chennai? How do u structurally approach coming up with that number?\n",
    "    Multiple Linear Regression?\n",
    "    OLS vs MLE?\n",
    "    R2 vs Adjusted R2? During Model Development which one do we consider?\n",
    "    Lift chart, drift chart\n",
    "    Sigmoid Function in Logistic regression\n",
    "    ROC what is it? AUC and Differentiation?\n",
    "    Linear Regression from Multiple Linear Regression\n",
    "    P-Value what is it and its significance? What does P in P-Value stand for? What is Hypothesis Testing? Null hypothesis vs Alternate Hypothesis?\n",
    "Bias Variance Trade off?\n",
    "Over fitting vs Underfitting in Machine learning?\n",
    "Estimation of Multiple Linear Regression\n",
    "Forecasting vs Prediction difference? Regression vs Time Series?\n",
    "p,d,q values in ARIMA models\n",
    "    What will happen if d=0\n",
    "    What is the meaning of p,d,q values?\n",
    "Is your data for Forecasting Uni or multi-dimensional?\n",
    "How to find the nose to start with in a Decision tree.\n",
    "TYPES of Decision trees - CART vs C4.5 vs ID3\n",
    "Genie index vs entropy\n",
    "Linear vs Logistic Regression\n",
    "Decision Trees vs Random Forests\n",
    "Questions on liner regression, how it works and all\n",
    "Asked to write some SQL queries\n",
    "Asked about past work experience\n",
    "Some questions on inferential statistics (hypothesis testing, sampling techniques)\n",
    "Some questions on table (how to filter, how to add calculated fields etc)\n",
    "Why do u use Licensed Platform when other Open source packages are available?\n",
    "What certification Have u done?\n",
    "What is a Confidence Interval?\n",
    "What are Outliers? How to Detect Outliers?\n",
    "How to Handle Outliers?\n",
    " \n",
    "\n",
    "Company: L&T Financial Services\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "Explain your Projects\n",
    "Assumptions in Multiple linear regression\n",
    "Decision tree algorithm\n",
    "Gini index\n",
    "Entropy\n",
    "Formulas of gini and entropy\n",
    "Random forest algorithm\n",
    "XGBoost Algorithm\n",
    "Central Limit theorem\n",
    "R2\n",
    "Adj R2\n",
    "VIF\n",
    "Different Methods to measure Accuracy\n",
    "Explain Bagging and Boosting\n",
    "Difference Between Bagging and Boosting\n",
    "Various Ensemble techniques\n",
    "P value and it’s significance\n",
    "F1 Score\n",
    "Type 1 and Type II error\n",
    "Logical questions for Type 1 and Type II error\n",
    "Logical questions for Null and alternate Hypothesis\n",
    "\n",
    "\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "Decorators in Python\n",
    "- Live Example\n",
    "\n",
    "Generators in Python\n",
    "- Live Example\n",
    "\n",
    " \n",
    "\n",
    "SQL Questions\n",
    " \n",
    "\n",
    "3.1 Group by Top 2 Salaries for Employees\n",
    "\n",
    "3.2 use Row num and Partition\n",
    "\n",
    " \n",
    "\n",
    "Pandas find Numeric and Categorical Columns.\n",
    "4.1 For Numeric columns, find the mean of the entire column and add that value to each row of the column.\n",
    "\n",
    " \n",
    "\n",
    "What is Gradient Descent?\n",
    "5.1 What is Learning Rate and Why is it reduce sometimes\n",
    "\n",
    " \n",
    "\n",
    "Two Logistic Regression Models - Which one will you choose - One is trained on 70% and other on 80% data. Accuracy is almost same.\n",
    "What is LogLoss ?\n",
    " \n",
    "\n",
    "Explain your Projects end to end.(15-20mins)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Role: Data Science Intern\n",
    "\n",
    " \n",
    "\n",
    "Tell me about your journey as a Data Science aspirant\n",
    "What was the one challenging project or task that you did in this domain and why was it challenging?\n",
    "What model did you use for that? I replied Random Forests\n",
    "What is Random Forest and how is it used?\n",
    "How are Random Forest different from Decision Trees and what problems do they solve that decision trees can't?\n",
    "Multi class Classification and which metric is preferred for it\n",
    "Given a banking scenario to predict Loan Defaulters, which metric will you use?\n",
    "How will you handle the class imbalance in this case?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Latentview Analytics\n",
    "\n",
    " \n",
    "\n",
    "What is mean and median\n",
    "Difference between normal and gaussian\n",
    "distribution\n",
    "\n",
    "What is central limit theorem\n",
    "What is null hypothesis\n",
    "What is confidence interval\n",
    "What is covariance and correlation and how will u\n",
    "interpret it.\n",
    "\n",
    "How will you find out the outliers in the dataset\n",
    "and is it always to remove outliers\n",
    "\n",
    "Explain about Machine Learning\n",
    "Explain the algorithm of your choice\n",
    "Different methods of missing values imputation\n",
    "Explain me your ml project\n",
    "How did you handle imbalance dataset\n",
    "What is stratified samplings\n",
    "Difference between standard scalar and normal\n",
    "scalar\n",
    "\n",
    "Different type of visualization in Dl project\n",
    "What architecture have you used\n",
    "Why have u not used RNN in your nlp project\n",
    "Why we don't prefer CNN in nlp based project\n",
    "19 What is exploding gradient and vanishing gradient and how to rectify it\n",
    "\n",
    "Difference between LSTM and GRU\n",
    "What is precision and recall\n",
    "22 What is auc metic\n",
    "\n",
    "What if your precision and recall are same\n",
    "\n",
    "\n",
    "\n",
    "Data Science Interview Questions\n",
    "\n",
    " \n",
    "\n",
    "Naive bayes assumptions\n",
    "What are the approaches for solving class imbalance problem?\n",
    "When sampling what types of biases can be inflected? How to control the biases?\n",
    "GRU is faster compared to LSTM. Why?\n",
    "What is difference between K-NN and K-Means clustering ?\n",
    "How to determine if a coin is biased ? Hint: Hypothesis testing\n",
    "How will u present the statistical inference of a particular numerical column?\n",
    "How would you design a data science pipeline ?\n",
    "Explain back propagation in few words and it’s variants?\n",
    "Explain topic modeling in NLP and various methods in performing topic modeling.\n",
    "\n",
    "\n",
    "\n",
    "Company: Myntra\n",
    "\n",
    "Role: Data Analyst\n",
    "\n",
    " \n",
    "\n",
    "Introduce yourself.\n",
    "\n",
    " \n",
    "\n",
    "One complex sql query- 2 table are there, Table1(cust_id,Name) Table2(cust_id,Transaction_amt)\n",
    "\n",
    "Write a query to return the name of customers with 8th highest lifetime purchase.\n",
    "\n",
    " \n",
    "\n",
    "Achieve the same using python.\n",
    "\n",
    " \n",
    "\n",
    "ML questions:\n",
    "\n",
    " \n",
    "\n",
    "What's the problem in having multi collinearity in data set.\n",
    "\n",
    "If there is business requirement to keep two corelated features in model, what would you do.\n",
    "\n",
    "How would you deal with feature of 4 categories and 20% null values\n",
    "\n",
    " \n",
    "\n",
    "Some questions based on my project.\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Nira Finance\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "Asked to explain my project.\n",
    "\n",
    "Have you not done any classification problem as your Resume only mentions regression tasks.\n",
    "\n",
    " \n",
    "\n",
    "Explain the working of Gradient boosting.\n",
    "\n",
    "Difference between boosting and bagging.\n",
    "\n",
    " \n",
    "\n",
    "What would you do when output is imbalanced.\n",
    "\n",
    "What is more preferred over sampling or under sampling.\n",
    "\n",
    "In what case under sampling a non harmful approach.\n",
    "\n",
    " \n",
    "\n",
    "How would you measure the performance of models built on imbalanced dataset.\n",
    "\n",
    "Whats the meaning of precision and recall.\n",
    "\n",
    " \n",
    "\n",
    "Tell me about a task you did and are very proud of.\n",
    "\n",
    "Do you have any questions for me\n",
    "\n",
    " \n",
    "\n",
    "Post interview I was given a ML assignment to solve and submit within next 2 weeks.\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Myntra\n",
    "\n",
    "Role: Data Analyst\n",
    "\n",
    "Round type: Use case Round\n",
    "\n",
    " \n",
    "\n",
    "Problem Statement:\n",
    "\n",
    " \n",
    "\n",
    "Given 2 teams of Myntra namely:\n",
    "\n",
    " \n",
    "\n",
    "Finance Team: They focus to take decisions which are Money driven.\n",
    " \n",
    "\n",
    "Customer Experience Team : They focus to improve the Customer Experience with Myntra.\n",
    " \n",
    "\n",
    "Whenever Customer places a refund request Myntra can process it in 2 different ways:\n",
    "\n",
    " \n",
    "\n",
    "Directly accept the Return request.\n",
    " \n",
    "\n",
    "Put the request on hold and verify the product for damages or manhandling by customer. Only if the products are found to be in proper state, accept the return.\n",
    " \n",
    "\n",
    "Now, there is a conflict of opinion between these two teams.\n",
    "\n",
    "Finance Team likes the 2nd option as it minimize the chances of loss.\n",
    "\n",
    " \n",
    "\n",
    "But Customer Experience teams likes the 1st option as their main aim is to improve Customer Experience.\n",
    "\n",
    " \n",
    "\n",
    "Now suppose you are part of the Customer Experience team. How would you convince the Finance team to follow the 1st step.\n",
    "\n",
    " \n",
    "\n",
    "What kind of Data you would be looking for solving this task.\n",
    "\n",
    " \n",
    "\n",
    "Is there any need for model building for this use case.\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Ericsson\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "Round No: 1st Round\n",
    "\n",
    " \n",
    "\n",
    "How to reverse a linked list\n",
    "\n",
    " \n",
    "\n",
    "Give a logistic regression model in production, how would you find out the coefficients of different input features.\n",
    "\n",
    " \n",
    "\n",
    "What is the p- value in OLS regression\n",
    "\n",
    " \n",
    "\n",
    "What's the reason for high bias or variance\n",
    "\n",
    " \n",
    "\n",
    "Which models are generally high biased or high variance\n",
    "\n",
    " \n",
    "\n",
    "Write code to find the 8 highest value in the DataFrame\n",
    "\n",
    " \n",
    "\n",
    "What's difference between array and list\n",
    "\n",
    " \n",
    "\n",
    "Whats the difference between Gradient boosting and Xgboost\n",
    "\n",
    " \n",
    "\n",
    "Is XOR data linearly separable\n",
    "\n",
    " \n",
    "\n",
    "How do we classify XOR data using logistic regression\n",
    "\n",
    " \n",
    "\n",
    "Some questions from my previous projects\n",
    "\n",
    " \n",
    "\n",
    "Given a sand timer of 4 and 7 mins how would you calculate 10 mins duration.\n",
    "\n",
    " \n",
    "\n",
    "What's the angle between hour and minute hand in clock as 3:15\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Legato Health Technologies\n",
    "\n",
    "Role: MLOps Engineer\n",
    "\n",
    "Experience: 2-3 years\n",
    "\n",
    " \n",
    "\n",
    "Round 2:\n",
    "\n",
    "Complete ML technical stack used in project?\n",
    "\n",
    "Different activation function?\n",
    "\n",
    "How do you handle imbalance data ?\n",
    "\n",
    "Difference between sigmoid and softmax ?\n",
    "\n",
    "Explain about optimizers ?\n",
    "\n",
    "Precision-Recall Trade off ?\n",
    "\n",
    "How do you handle False Positives ?\n",
    "\n",
    "Explain LSTM architecture by taking example of 2 sentences and how it will be processed?\n",
    "\n",
    "Decision Tree Parameters?\n",
    "\n",
    "Bagging and boosting ?\n",
    "\n",
    "Explain bagging internals\n",
    "\n",
    "Write a program by taking an url and give a rough code approach how you will pass payload and make a post request?\n",
    "\n",
    "Different modules used in python ?\n",
    "\n",
    "Another coding problem of checking balanced parentheses?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Role: Junior Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "1) Explain the architecture of CNN\n",
    "\n",
    "2)If we put a 3×3 filter over 6×6 image what will be the size of the output image\n",
    "\n",
    "3) What will you do to reduce overfitting In deep learning models\n",
    "\n",
    "3) Can you write a program for inverted star program in python\n",
    "\n",
    "4)Write a program to create a dataframe and remove elements from it\n",
    "\n",
    "5) I have 2 guns with 6 holes in each, and I load a single bullet In each gun, what is the probability that if I fire the guns simultaneously atleast 1 gun will fire (atleast means one or more than one)\n",
    "\n",
    "5) There are 2 groups g1 and g2, g1 will ask g2 members to give them 1 member so thay they both will be equal in number, g2 will ask g1 members to give them 1 member so thay they will be double of g1, how many members are there in the groups (I'm not sure of this question as I tried to solve but didnt get correct answer)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Data Science Interview Questions:\n",
    "\n",
    " \n",
    "\n",
    "How do check the Normality of a dataset?\n",
    "Difference Between Sigmoid and Softmax functions?\n",
    "Can logistic regression use for more than 2 classes?\n",
    "What are Loss Function and Cost Functions? Explain the key Difference Between them?\n",
    "What is F1 score? How would you use it?\n",
    "In a neural network, what if all the weights are initialized with the same value?\n",
    "Why should we use Batch Normalization?\n",
    "In a CNN, if the input size 5 X 5 and the filter size is 7 X 7, then what would be the size of the output?\n",
    "What do you mean by exploding and vanishing gradients?\n",
    "What are the applications of transfer learning in Deep Learning?\n",
    "Why does a Convolutional Neural Network (CNN) work better with image data?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Data Science Interview Questions:\n",
    "\n",
    " \n",
    "\n",
    "What is the Central Limit Theorem and why is it important?\n",
    "What is the difference between type I vs type II error?\n",
    "Tell me the difference between an inner join, left join/right join, and union.\n",
    "Explain the 80/20 rule, and tell me about its importance in model validation.\n",
    "What is one way that you would handle an imbalanced data set that’s being used for prediction (i.e., vastly more negative classes than positive classes)?\n",
    "Is it better to spend five days developing a 90-percent accurate solution or 10 days for 100-percent accuracy?\n",
    "Most common characteristics used in descriptive statistics?\n",
    "What do you mean by degree of freedom?\n",
    "Why is the t-value same for 90% two tail and 95% one tail test?\n",
    "What does it mean if a model is heteroscedastic? what about homoscedastic?\n",
    "You roll a biased coin (p(head)=0.8) five times. What’s the probability of getting three or more heads?\n",
    "What does interpolation and extrapolation mean? Which is generally more accurate?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Data Science Interview Questions:\n",
    "\n",
    " \n",
    "\n",
    "What the aim of conducting A/B Testing?\n",
    "Explain p-value.\n",
    "Explain how a ROC curve works?\n",
    "What is pruning in Decision Tree?\n",
    "How will you define the number of clusters in a clustering algorithm?\n",
    "When to use Precision and when to use Recall?\n",
    "What are the assumptions required for linear regression? What if some of these assumptions are violated?\n",
    "How are covariance and correlation different from one another?\n",
    "How can we relate standard deviation and variance?\n",
    "Explain the phrase \"Curse of Dimensionality\".\n",
    "What does the term Variance Inflation Factor mean?\n",
    "What is the significance of Gamma and Regularization in SVM?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Data Science Interview questions:\n",
    "\n",
    " \n",
    "\n",
    "How will you calculate the Sensitivity of machine learning models?\n",
    "\n",
    "What do you mean by cluster sampling and systematic sampling?\n",
    "\n",
    "Explain Eigenvectors and Eigenvalues.\n",
    "\n",
    "Explain Gradient Descent.\n",
    "\n",
    "How does Backpropagation work? Also, it states its various variants.\n",
    "\n",
    "What do you know about Autoencoders?\n",
    "\n",
    "What is Dropout in Neural Networks?\n",
    "\n",
    "What is the difference between Batch and Stochastic Gradient Descent?\n",
    "\n",
    "What are the different kinds of Ensemble learning?\n",
    "\n",
    "What is entropy, information gain and gini index in decision tree classifier and regression?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "What is central tendency\n",
    "Which central tendency method is used If there exists any outliers\n",
    "Central limit theorem\n",
    "Chi-Square test\n",
    "A/B testing\n",
    "Difference between Z and t distribution (Linked to A/B testing)\n",
    "Outlier treatment method\n",
    "ANOVA test\n",
    "Cross validation\n",
    "How will you work in a machine learning project if there is a huge imbalance in the data\n",
    "Formula of sigmoid function\n",
    "Can we use sigmoid function in case of multiple classification (I said no)\n",
    "Then which function is used\n",
    "What is Area under the curve\n",
    "Which metric is used to split a node in Decision Tree\n",
    "What is ensemble learning\n",
    "\n",
    "\n",
    "\n",
    "My Statistics Checklist before going for a Data Science Interview:\n",
    "\n",
    " \n",
    "\n",
    "Inferential and descriptive Statistics\n",
    "Sample\n",
    "Population\n",
    "Random variables\n",
    "Probability Distribution Function\n",
    "Probability Mass Function\n",
    "Cumulative Distribution Function\n",
    "Expectation and Variance\n",
    "Binomial Distribution\n",
    "Bernoulli Distribution\n",
    "Normal Distribution\n",
    "Z-score\n",
    "Central Limit Theorem\n",
    "Hypothesis Testing\n",
    "Confidence Interval\n",
    "Chi Square Test\n",
    "Anova Test\n",
    "F-Stats\n",
    "\n",
    "\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "What is central tendency\n",
    "Which central tendency method is used If there exists any outliers\n",
    "Central limit theorem\n",
    "Chi-Square test\n",
    "A/B testing\n",
    "Difference between Z and t distribution (Linked to A/B testing)\n",
    "Outlier treatment method\n",
    "ANOVA test\n",
    "Cross validation\n",
    "How will you work in a machine learning project if there is a huge imbalance in the data\n",
    "Formula of sigmoid function\n",
    "Can we use sigmoid function in case of multiple classification (I said no)\n",
    "Then which function is used\n",
    "What is Area under the curve\n",
    "Which metric is used to split a node in Decision Tree\n",
    "What is ensemble learning\n",
    "3 situation based questions\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "ompany: Legato Health Technologies\n",
    "\n",
    "Role: MLOps Engineer\n",
    "\n",
    " \n",
    "\n",
    "Round 2:\n",
    "\n",
    "Complete ML technical stack used in project?\n",
    "\n",
    "Different activation function?\n",
    "\n",
    "How do you handle imbalance data ?\n",
    "\n",
    "Difference between sigmoid and softmax ?\n",
    "\n",
    "Explain about optimisers ?\n",
    "\n",
    "Precision-Recall Trade off ?\n",
    "\n",
    "How do you handle False Positives ?\n",
    "\n",
    "Explain LSTM architecture by taking example of 2 sentences and how it will be processed?\n",
    "\n",
    "Decision Tree Parameters?\n",
    "\n",
    "Bagging and boosting ?\n",
    "\n",
    "Explain bagging internals\n",
    "\n",
    "Write a program by taking an url and give a rough code approach how you will pass payload and make a post request?\n",
    "\n",
    "Different modules used in python ?\n",
    "\n",
    "Another coding problem of checking balanced parentheses?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Cerence\n",
    "\n",
    "Role: NLU Developer\n",
    "\n",
    " \n",
    "\n",
    "Question1 :\n",
    "\n",
    "Write a function that take two strings as inputs and return true if they are anagrams of each other and false otherwise\n",
    "\n",
    "e.g.\n",
    "\n",
    "(hello, hlleo) --> true\n",
    "\n",
    "(hello, helo) --> false\n",
    "\n",
    " \n",
    "\n",
    "Question 2 :\n",
    "\n",
    "Write a function that take an array of strings \"A\" and an integer \"n\",\n",
    "\n",
    "that return the list of all strings of length \"n\" from the array \"A\" that can be constructed\n",
    "\n",
    "as the concatenation of two strings from the same array \"A\"\n",
    "\n",
    "e.g.\n",
    "\n",
    "A = [dog, tail, sky, or, hotdog, tailor, hot] and n=6\n",
    "\n",
    "output should be \"hotdog\" and \"tailor\"\n",
    "\n",
    " \n",
    "\n",
    "Question 3 :\n",
    "\n",
    "Given an array \"arr\" of numbers and a starting number \"x\",\n",
    "\n",
    "Find \"x\" such that the running sums of \"x\" and the elements of the array \"arr\" are never lower than 1.\n",
    "\n",
    "e.g.\n",
    "\n",
    "arr = [-2, 3, 1, -5].\n",
    "\n",
    "The running sums will be x-2, x-2+3, x-2+3+1 and x-2+3+1-5.\n",
    "\n",
    "So, the output should be 4.\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: GEOTAB\n",
    "\n",
    " \n",
    "\n",
    "Python :\n",
    "\n",
    "Is python a language that follows pass by value, or pass by reference or pass by object reference\n",
    "What are lambda functions and how to use them\n",
    "Difference between mutable and immutable objects with example.\n",
    "What are Python decorators? Why do we use them\n",
    " \n",
    "\n",
    "SQL :\n",
    "\n",
    "What is the difference between Inner join and left inner join ?\n",
    "What are window functions ?\n",
    "What is the use of groupby ?\n",
    " \n",
    "\n",
    "SQL Round\n",
    "\n",
    "3 tables given as below:\n",
    "\n",
    " \n",
    "\n",
    "TRIPS\n",
    "\n",
    "trip_id\n",
    "\n",
    "vehicle_id\n",
    "\n",
    "start_time\n",
    "\n",
    "stop_time\n",
    "\n",
    " \n",
    "\n",
    "VEHICLE_MAKE\n",
    "\n",
    "vehicle_id\n",
    "\n",
    "make_id\n",
    "\n",
    " \n",
    "\n",
    "MAKES\n",
    "\n",
    "make_id\n",
    "\n",
    "make_name\n",
    "\n",
    " \n",
    "\n",
    "There is a table which contains vehicle trips. Trips are not necessarily in order.\n",
    "\n",
    " \n",
    "\n",
    "There is a table which contains vehicle makes. Makes are not necessarily known.\n",
    "\n",
    " \n",
    "\n",
    "PROBLEM: Write SQL code that provides the number of trips that started on September 1st, 2020 for each vehicle with a KNOWN make. \n",
    "\n",
    "Order the results by the trip count.\n",
    "\n",
    " \n",
    "\n",
    "op\n",
    "\n",
    " vehicle_id | trip_count \n",
    "\n",
    "     4 |     2\n",
    "\n",
    "     1 |     1\n",
    "\n",
    "     2 |     1\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Role: MLOps Engineer\n",
    "\n",
    " \n",
    "\n",
    "1st round:-\n",
    "\n",
    "Introduction\n",
    "\n",
    "Current NLP architecture used in my project\n",
    "\n",
    "How will you identify Data Drift? Once identified how would you automate the handling of Data Drift\n",
    "\n",
    "Data Pipeline used\n",
    "\n",
    "Fasttext word embedding vs word2vec\n",
    "\n",
    "When should we use Tf-IDF and when predictive based word embedding will be advantageous over Tf-IDF\n",
    "\n",
    "Metrics used to validate our model\n",
    "\n",
    "In MongoDB write a query to find employee names from a collection\n",
    "\n",
    "In Python write a program to separate 0s and 1s from an array- (0,1,0,1,1,0,1,0)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Latentview.\n",
    "\n",
    " \n",
    "\n",
    "Initial they had asked for the explaining the project which I had done. I explained the Customer prediction case . Then I was asked with python questions by sharing my screen.\n",
    "\n",
    " \n",
    "\n",
    "How do you handle the correlated variables without removing them\n",
    "Explain the SMOTE, ADAYSN technique\n",
    "What is stratified sampling technique\n",
    "Explain the working of random forest and xgboost\n",
    "How do you optimise the Recall of your output\n",
    "What are chisquare and ANOVA test\n",
    "In python they asked for LOC,ILOC, how do you remove duplicate,How to unique values in column,\n",
    "In SQL they asked for the query for having matches between different teams\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Myntra\n",
    "\n",
    "Role: Data Analyst\n",
    "\n",
    " \n",
    "\n",
    "Introduce yourself.\n",
    "\n",
    " \n",
    "\n",
    "One complex sql query- 2 table are there, Table1(cust_id,Name) Table2(cust_id,Transaction_amt)\n",
    "\n",
    "Write a query to return the name of customers with 8th highest lifetime purchase.\n",
    "\n",
    " \n",
    "\n",
    "Achieve the same using python.\n",
    "\n",
    " \n",
    "\n",
    "ML questions:\n",
    "\n",
    " \n",
    "\n",
    "What's the problem in having multi collinearity in data set.\n",
    "\n",
    "If there is business requirement to keep two corelated features in model, what would you do.\n",
    "\n",
    "How would you deal with feature of 4 categories and 20% null values.\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Company: Enquero Global\n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    " \n",
    "\n",
    "Previous job role and responsibilities\n",
    "\n",
    "Problem statement of your project and How do you overcome challenges\n",
    "\n",
    "How do you handle feature which had many categories.\n",
    "\n",
    "When to use precision and recall.\n",
    "\n",
    "What are outliers & how do you handle them\n",
    "\n",
    "Joins, self joins, said me to write sql queries on self joins\n",
    "\n",
    "How good your with python\n",
    "\n",
    "Logic for reverse string.\n",
    "\n",
    "Data collection- how do you collect data and data preprocessing.\n",
    "\n",
    "Focused on EDA part\n",
    "\n",
    "Have you deveployed any project in cloud if you which cloud you had used and how do you do that.\n",
    "\n",
    "How do you interact with domain expertise and business analytics people.\n",
    "\n",
    "How do you replace Missing values for continuous variables.\n",
    "\n",
    "What is your largest data set you have handled till now and tell me size of dataset.\n",
    "\n",
    "Overall Mostly focused on SQL, DATA COLLECTION, EDA, feature engineering and selection.\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "A continuous variable is having missing values, so how will you decide that the missing values should be imputed by mean or median?\n",
    "\n",
    "What is PCA and what each component means? Also, what is the maximum value for number of components?\n",
    "\n",
    "What is test of independence? How do you calculate Chi-square value?\n",
    "\n",
    "When precision is preferred over recall or vice-versa?\n",
    "\n",
    "Advantages and disadvantages of Random forest over Decision Tree?\n",
    "\n",
    "What is the c hyperparameter in SVM algorithm and how it affects bias variance tradeoff?\n",
    "\n",
    "What are the assumptions of linear regression?\n",
    "\n",
    "Difference between Stemming and Lemmatization?\n",
    "\n",
    "Difference between Correlation and Regression?\n",
    "\n",
    "What is p-value and confidence interval?\n",
    "\n",
    "What is multicollinearity and how do you deal with multicollinearity? What is VIF?\n",
    "\n",
    "What is the difference between apply, applymap and map function in python?\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "Deloitte Interview :\n",
    "\n",
    " \n",
    "\n",
    "Role: Data Scientist\n",
    "\n",
    "Candidate Name: Wanted to remain anonymous\n",
    "\n",
    "ROUND 1 :\n",
    "\n",
    " \n",
    "\n",
    "Introduction\n",
    "\n",
    " \n",
    "\n",
    "- Started with Classification particularly Imbalance , oversampling.\n",
    "\n",
    "Which class should i oversample etc.\n",
    "\n",
    "Telecom Churn Case Study Questions like Evaluation metric for imbalance data\n",
    "\n",
    "what threshold to choose to diving the classes (0.5 in case of balanced else sensitivity / Specifivity etc.\n",
    "\n",
    "What if i don't use SMOTE() for handling imbalance how should i select the threshold now (messed up by me, roc , auc etc) Ans = Presion - Recall Curve\n",
    "\n",
    " \n",
    "\n",
    "- NLP Questions\n",
    "\n",
    "Sentiment analysis, preprocessing like (TFID, BOW), Embeddings, stemming, Lemmatization\n",
    "\n",
    "libraries in know : nltk, spacy\n",
    "\n",
    " \n",
    "\n",
    "- Regression Preprocessing\n",
    "\n",
    "answered outlier, missing value immputation, Distribution, dummies, multicolinearity etc\n",
    "\n",
    "You have two highy co-related columns which one will you drop? : \"Based on Business Problem i will see accordingly.\", \n",
    "\n",
    " \n",
    "\n",
    "- Naive Bayes Explanation , Drawback of Naive Bayes(couln't answere drawback of Naive Bayes, 'Assume all are independent', him)\n",
    "\n",
    "- Hand Gesture Recognition Techniques (End to End)\n",
    "\n",
    "- Resource Timesheet Forecasting . (What is it?? what you do on this?, \" Explained with a story based on what i do in TCS\".\n",
    "\n",
    " \n",
    "\n",
    "- Do you know any Boosting Algorithms : YES\n",
    "\n",
    "where have you used?? in Telecom Churn and Healthcare Analytics by AV\n",
    "\n",
    " \n",
    "\n",
    "- Gradient Descent (How it works)\n",
    "\n",
    " \n",
    "\n",
    "- KNN related. How do we choose value of K ??\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "- Stastical Computing:\n",
    "\n",
    "Type 1 and Type 2 error\n",
    "\n",
    "Alternate name of Type 1 error (couldn't answer alternate name of Type 1 error, 'False +ive, him)\n",
    "\n",
    "What is p-Value (Explaiend with the example of Linear Regression from statsmodel)\n",
    "\n",
    " \n",
    "\n",
    "- Do you have exposure of TimeSeires analysis : NO (didn't ask anything and seems fine with him)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}