Datascience Interview
Datascience Interview
Datascience Interview
data?
Tweet: Data Science Interview questions #1 - How would you create a taxonomy
The best way to approach this question is to mention that it is good to check
with the business owner and understand their objectives before categorizing the
pulling new data samples and improving the model accordingly by validating it
for accuracy by soliciting feedback from the stakeholders of the business. This
helps ensure that your model is producing actionable results and improving over
the time.
analytics?
The best possible answer for this would be Python because it has Pandas library
that provides easy to use data structures and high performance data analysis
tools.
CLICK HERE to get the data scientist salary report delivered to your inbox!
if you want to predict whether a particular political leader will win the election
The predictor variables here would be the amount of money spent for election
etc.
are widely used in movies, news, research articles, products, social tags, music,
etc.
Cleaning data from multiple sources to transform it into a format that data
the number of data sources increases, the time take to clean the data increases
exponentially due to the number of sources and the volume of data generated in
these sources. It might take up to 80% of the time for just cleaning data making
multivariate analysis.
time. For example, the pie charts of sales based on territory involve only one
Analysis that deals with the study of more than two variables to understand the
Data is usually distributed in different ways with a bias to the left or to the
right or it can all be jumbled up. However, there are chances that data is
distributed around a central value without any bias to the left or right and
reaches normal distribution in the form of a bell shaped curve. The random
facts.
size.
agents.
Sampling?
Cluster sampling is a technique used when it becomes difficult to study the target
population spread across a wide area and simple random sampling cannot be applied.
the list is progressed in a circular manner so once you reach the end of the
list,it is progressed from the top again. The best example for systematic
They are not different but the terms are used in different contexts. Mean is
context.
Mean value is the only value that comes from the sampling data.
Expected Value is the mean of all the means i.e. the value that is built from
For Distributions
Mean value and Expected value are same irrespective of the distribution, under
between 0 and 1.
No, they do not because in some cases it reaches a local minima or a local optima
point. You don’t reach the global optima point. It depends on the data and
starting conditions
19) A test has a true positive rate of 100% and false positive rate
of 5%. There is a population with a 1/1000 rate of having the condition the
that condition?
Let’s suppose you are being tested for a disease, if you have the illness the
test will end up saying you have the illness. However, if you don’t have the
illness- 5% of the times the test will end up saying you have the illness and
95% of the times the test will give accurate result that you don’t have the
illness. Thus there is a 5% error in case you do not have the illness.
Out of 1000 people, 1 person who has the disease will get true positive result.
Out of the remaining 999 people, 5% will also get true positive result.
Close to 50 people will get a true positive result for the disease.
This means that out of 1000 people, 51 people will be tested positive for the
disease even though only one person has the illness. There is only a 2%
probability of you having the disease even if your reports say that you have
the disease.
20) How you can make data normal using Box-Cox transformation?
Unsupervised Learning?
If an algorithm learns something from the training data so that the knowledge
code?
variables A and B. The goal of A/B Testing is to identify any changes to the
web page to maximize or increase the outcome of an interest. An example for this
analysis method. If the number of outlier values is few then they can be assessed
individually but for large number of outliers the values can be substituted with
either the 99th or the 1st percentile values. All extreme values are not outlier
analysis-
logistic model to differentiate between the event happening and not happening.
random selection.
the result and tweak the approach. This is an iterative step till the best
30) How can you iterate over a list and also retrieve element indices at the
same time?
This can be done using the enumerate function which takes every element in a
sequence just like in a list and adds its location just before it.
The extent of the missing values is identified after identifying the variables
with missing values. If any patterns are identified the analyst has to
insights. If there are no patterns identified, then the missing values can be
Understand the problem statement, understand the data and then give the
If 80% of the values for a variable are missing then you can answer that you
33) Can you use machine learning for time series analysis?
34) Write a function that takes in two sorted lists and outputs
First solution which will come to your mind is to merge two lists and short them
afterwards
Python code-
R code-
list_c<-list(c(unlist(list_a),unlist(list_b)))
return(list(list_c[[1]][order(list_c[[1]])]))
Generally, the tricky part of the question is not to use any sorting or ordering
function. In that case you will have to write your own logic to answer the question
Python code-
len1 = len(list_a)
len2 = len(list_b)
final_sorted_list = []
j = 0
k = 0
for i in range(len1+len2):
if k == len1:
final_sorted_list.extend(list_b[j:])
break
elif j == len2:
final_sorted_list.extend(list_a[k:])
break
final_sorted_list.append(list_a[k])
k += 1
else:
final_sorted_list.append(list_b[j])
j += 1
return final_sorted_list
j=1
k=1
#Creating an empty list which has length equal to sum of both the lists
list_c <- list(rep(NA,len))
for(i in 1:len)
if(j>len_a)
break
else if(k>len_b)
break
j <- j+1
k <- k+1
return(list(unlist(list_c)))
regularization solve?
39) How do you decide whether your linear regression model fits
the data?
error?
The simplest way to answer this question is – we give the data and equation
to the machine. Ask the machine to look at the data and identify the coefficient
values in an equation.
For example for the linear regression y=mx+c, we give the data for the variable
x, y and the machine learns about the values of m and c from the data.
42) How are confidence intervals constructed and how will you interpret them?
48) How will you define the number of clusters in a clustering algorithm?
Though the Clustering Algorithm is not specified, this question will mostly be
cluster. If you plot WSS for a range of number of clusters, you will get the
Red circled point in above graph i.e. Number of Cluster =6 is the point after
which you don’t see any decrement in WSS. This point is known as bending point
This is the widely used approach but few data scientists also use Hierarchical
clustering first to create dendograms and identify the distinct groups from
there.
49) Is it better to have too many false negatives or too many false positives?
But when this question is being asked in an interview, interviewer is not looking
for a name of Add-ins rather a method using the base excel functionalities.
Let’s use a sample data to learn about logistic regression using Excel. (Example
assumes that you are familiar with basic concepts of logistic regression)
Data shown above consists of three variables where X1 and X2 are independent
variables and Y is a class variable. We have kept only 2 categories for our purpose
51) What do you understand by Fuzzy merging ? Which language will you use
to handle it?
multiple regressions. What are the steps you would follow to validate the model?
Since the question asked, is about post model building exercise, we will assume
that you have already tested for null hypothesis, multi collinearity and Standard
error of coefficients.
Once you have built the model, you should check for following –
· R^2
· Adjusted R^2
· RMSE, MAPE
In addition to above mentioned quantitative metrics you should also check for-
· Residual plot
does not?
problems.
sparsity.
In other words, errors are squared in L2, so model sees higher error and tries
58) How can you deal with different types of seasonality in time series
modelling?
Seasonality in time series occurs when time series shows a repeated pattern over
time. E.g., stationary sales decreases during holiday season, air conditioner
sales increases during the summers etc. are few examples of seasonality in a
time series.
Seasonality makes your time series non-stationary because average value of the
known as the best method of removing seasonality from a time series. Seasonal
differencing can be defined as a numerical difference between a particular
value and a value with a periodic lag (i.e. 12, if monthly seasonality is present)
61) Can you cite some examples where a false positive is important than a false
negative?
Before we start, let us understand what are false positives and what are false
negatives.
False Positives are the cases where you wrongly classified a non-event as an
And, False Negatives are the cases where you wrongly classify events as
In medical field, assume you have to give chemo therapy to patients. Your lab
tests patients for certain vital information and based on those results they
Assume a patient comes to that hospital and he is tested positive for cancer
(But he doesn’t have cancer) based on lab prediction. What will happen to him?
(Assuming Sensitivity is 1)
One more example might come from marketing. Let’s say an ecommerce company
decided to give $1000 Gift voucher to the customers whom they assume to purchase
at least $5000 worth of items. They send free voucher mail directly to 100
customers without any minimum purchase condition because they assume to make
positive?
Assume there is an airport ‘A’ which has received high security threats and
can be a threat or not. Due to shortage of staff they decided to scan passenger
airport model?
Another example can be judicial system. What if Jury or judge decide to make
a criminal go free?
What if you rejected to marry a very good person based on your predictive model
and you happen to meet him/her after few years and realize that you had a false
negative?
63) Can you cite some examples where both false positive and false negatives
In the banking industry giving loans is the primary source of making money but
at the same time if your repayment rate is not good you will not make any profit,
Banks don’t want to lose good customers and at the same point of time they don’
t want to acquire bad customers. In this scenario both the false positives and
These days we hear many cases of players using steroids during sport competitions
Every player has to go through a steroid test before the game starts. A false
positive can ruin the career of a Great sportsman and a false negative can make
64) Can you explain the difference between a Test Set and a Validation Set?
Validation set can be considered as a part of the training set as it is used
for parameter selection and to avoid Overfitting of the model being built. On
the other hand, test set is used for testing or evaluating the performance of
Test Set is to assess the performance of the model i.e. evaluating the
66) What do you understand by statistical power of sensitivity and how do you
calculate it?
SVM, RF etc.). Sensitivity is nothing but “Predicted TRUE events/ Total events”.
True events here are the events which were true and model also predicted them
as true.
Where, True positives are Positive events which are correctly classified as
Positives.
68) Give some situations where you will use an SVM over a RandomForest Machine
for SVM. It is the opposite - if your data might contain outliers then Random
Forest, so if you are constrained with memory go for Random Forest machine
learning algorithm.
c) Random Forest gives you a very good idea of variable importance in your
data, so if you want to have variable importance then choose Random Forest machine
learning algorithm.
multiclass problems.
classification
but as a good data scientist, you should experiment with both of them and test
for accuracy or rather you can use ensemble of many Machine Learning techniques.
70) How do data management procedures like missing data handling make selection
bias worse?
Missing value treatment is one of the primary tasks which a data scientist is
supposed to do before starting data analysis. There are multiple methods for
missing value treatment. If not done properly, it could potentially result into
selection bias. Let see few missing value treatment examples and their impact
on selection-
Complete Case Treatment: Complete case treatment is when you remove entire row
in data even if one value is missing. You could achieve a selection bias if your
values are not missing at random and they have some pattern. Assume you are
conducting a survey and few people didn’t specify their gender. Would you remove
Available case analysis: Let say you are trying to calculate correlation matrix
for data so you might remove the missing values from variables which are needed
for that particular correlation coefficient. In this case your values will not
Mean Substitution: In this method missing values are replaced with mean of
other available values.This might make your distribution biased e.g., standard
deviation, correlation and regression are mostly dependent on the mean value
of variables.
Hence, various data management procedures might include selection bias in your
71) What are the advantages and disadvantages of using regularization methods
73) What do you understand by outliers and inliers? What would you do if you
74) Write a program in Python which takes input as the diameter of a coin and
weight of the coin and produces output as the money value of the coin.
75) What are the basic assumptions to be made for linear regression?
and additivity.
fitting an SVM?
Support Vector Machine Learning Algorithm performs better in the reduced space.
78) How will you assess the statistical significance of an insight whether it
Emp_sal= 2000+2.5(emp_age)2
var2<- c("I","Love,"DeZyre")
var2
s assume Chicago has close to 10 million people and on an average there are 2
people in a house. For every 20 households there is 1 Piano. Now the question
how many pianos are there can be answered. 1 in 20 households has a piano, so
Now the next question is-“How often would a Piano require tuning? There is no
exact answer to this question. It could be once a year or twice a year. You need
on whether you take this into consideration or not. Let’s suppose each piano
requires tuning once a year so on the whole 250,000 piano tunings are required.
Let’s suppose that a piano tuner works for 50 weeks in a year considering a
5 day week. Thus a piano tuner works for 250 days in a year. Let’s suppose tuning
a piano takes 2 hours then in an 8 hour workday the piano tuner would be able
to tune only 4 pianos. Considering this rate, a piano tuner can tune 1000 pianos
a year.
Thus, 250 piano tuners are required in Chicago considering the above estimates.
2) There is a race track with five lanes. There are 25 horses of which you want
to find out the three fastest horses. What is the minimal number of races needed
Divide the 25 horses into 5 groups where each group contains 5 horses. Race
between all the 5 groups (5 races) will determine the winners of each group.
A race between all the winners will determine the winner of the winners and must
be the fastest horse. A final race between the 2nd and 3rd place from the
winners group along with the 1st and 2nd place of thee second place group along
with the third place horse will determine the second and third fastest horse
second one contains 5 litres of water.How can you our exactly 7 litres of water
into a bucket?
6) A coin is flipped 1000 times and 560 times heads show up. Do you think the
coin is biased?
7) Estimate the number of tennis balls that can fit into a plane.
9) In a city where residents prefer only boys, every family in the city
they plan for another child. If a boy is born, they stop. Find out the proportion
manufactures defective chips with a probability of 20% and good quality chips
probability of 80% and good chips with a probability of 20%.If you get just one
2. Suppose that you now get a pack of 2 electronic chips coming from the
same company either A or B. When you test the first electronic chip it appears
to be good. What is the probability that the second electronic chip you received
is also good?
their likes and preferences. A match is said to be found between two users on
the website if the match on atleast 5 adjectives. If Steve and On a dating site,
declared between two users if they match on at least 4 adjectives. If Brad and
Angelina randomly pick adjectives, what is the probability that they will form
a match?
4. A coin is tossed 10 times and the results are 2 tails and 8 heads. How
will you analyse whether the coin is fair or not? What is the p-value for the
same?
tosses are made in total). Will you modify your approach to the test the fairness
6. An ant is placed on an infinitely long twig. The ant can move one step
backward or one step forward with same probability during discrete time steps.
Find out the probability with which the ant will return to the starting point.
Frequently Asked Open Ended Machine Learning Interview Questions for Data
Scientists
2. In which libraries for Data Science in Python and R, does your strength
lie?
4. Tell us about the biggest data set you have processed till date and for
7. What were the business outcomes or decisions for the projects you worked
on?
8. What unique skills you think can you add on to our data science team?
12. What has been the most useful business insight or development you have
found?
13. How will you explain an A/B test to an engineer who does not know
statistics?
14. When does parallelism helps your algorithms run faster and when does it
15. How can you ensure that you don’t analyse something that ends up producing
meaningless results?
16. How would you explain to the senior management in your organization as
18. What are your favourite imputation techniques to handle missing data?
1. What is the biggest data set that you processed, and how did you process
it, what were the results?
2. Tell me two success stories about your analytic or computer science
projects? How was lift (or success) measured?
3. What is: lift, KPI, robustness, model fitting, design of experiments,
80/20 rule?
4. What is: collaborative filtering, n-grams, map reduce, cosine distance?
5. How to optimize a web crawler to run much faster, extract better
information, and better summarize data to produce cleaner databases?
6. How would you come up with a solution to identify plagiarism?
7. How to detect individual paid accounts shared by multiple users?
8. Should click data be handled in real time? Why? In which contexts?
9. What is better: good data or good models? And how do you define "good"?
Is there a universal good model? Are there any models that are definitely
not so good?
10. What is probabilistic merging (AKA fuzzy merging)? Is it easier to handle
with SQL or other languages? Which languages would you choose for
semi-structured text data reconciliation?
11. How do you handle missing data? What imputation techniques do you
recommend?
12. What is your favorite programming language / vendor? why?
13. Tell me 3 things positive and 3 things negative about your favorite
statistical software.
14. Compare SAS, R, Python, Perl
15. What is the curse of big data?
16. Have you been involved in database design and data modeling?
17. Have you been involved in dashboard creation and metric selection? What
do you think about Birt?
18. What features of Teradata do you like?
19. You are about to send one million email (marketing campaign). How do you
optimze delivery? How do you optimize response? Can you optimize both
separately? (answer: not really)
20. Toad or Brio or any other similar clients are quite inefficient to query
Oracle databases. Why? How would you do to increase speed by a factor 10,
and be able to handle far bigger outputs?
21. How would you turn unstructured data into structured data? Is it really
necessary? Is it OK to store data as flat text files rather than in an
SQL-powered RDBMS?
22. What are hash table collisions? How is it avoided? How frequently does
it happen?
23. How to make sure a mapreduce application has good load balance? What is
load balance?
24. Examples where mapreduce does not work? Examples where it works very well?
What are the security issues involved with the cloud? What do you think
of EMC's solution offering an hybrid approach - both internal and external
cloud - to mitigate the risks and offer other advantages (which ones)?
25. Is it better to have 100 small hash tables or one big hash table, in memory,
in terms of access speed (assuming both fit within RAM)? What do you think
about in-database analytics?
26. Why is naive Bayes so bad? How would you improve a spam detection algorithm
that uses naive Bayes?
27. Have you been working with white lists? Positive rules? (In the context
of fraud or spam detection)
28. What is star schema? Lookup tables?
29. Can you perform logistic regression with Excel? (yes) How? (use linest
on log-transformed data)? Would the result be good? (Excel has numerical
issues, but it's very interactive)
30. Have you optimized code or algorithms for speed: in SQL, Perl, C++, Python
etc. How, and by how much?
31. Is it better to spend 5 days developing a 90% accurate solution, or 10
days for 100% accuracy? Depends on the context?
32. Define: quality assurance, six sigma, design of experiments. Give
examples of good and bad designs of experiments.
33. What are the drawbacks of general linear model? Are you familiar with
alternatives (Lasso, ridge regression, boosted trees)?
34. Do you think 50 small decision trees are better than a large one? Why?
35. Is actuarial science not a branch of statistics (survival analysis)? If
not, how so?
36. Give examples of data that does not have a Gaussian distribution, nor
log-normal. Give examples of data that has a very chaotic distribution?
37. Why is mean square error a bad measure of model performance? What would
you suggest instead?
38. How can you prove that one improvement you've brought to an algorithm
is really an improvement over not doing anything? Are you familiar with
A/B testing?
39. What is sensitivity analysis? Is it better to have low sensitivity (that
is, great robustness) and low predictive power, or the other way around?
How to perform good cross-validation? What do you think about the idea of
injecting noise in your data set to test the sensitivity of your models?
40. Compare logistic regression w. decision trees, neural networks. How have
these technologies been vastly improved over the last 15 years?
41. Do you know / used data reduction techniques other than PCA? What do you
think of step-wise regression? What kind of step-wise techniques are you
familiar with? When is full data better than reduced data or sample?
42. How would you build non parametric confidence intervals, e.g. for scores?
(see the AnalyticBridge theorem)
43. Are you familiar either with extreme value theory, monte carlo
simulations or mathematical statistics (or anything else) to correctly
estimate the chance of a very rare event?
44. What is root cause analysis? How to identify a cause vs. a correlation?
Give examples.
45. How would you define and measure the predictive power of a metric?
46. How to detect the best rule set for a fraud detection scoring technology?
How do you deal with rule redundancy, rule discovery, and the combinatorial
nature of the problem (for finding optimum rule set - the one with best
predictive power)? Can an approximate solution to the rule set problem be
OK? How would you find an OK approximate solution? How would you decide
it is good enough and stop looking for a better one?
47. How to create a keyword taxonomy?
48. What is a Botnet? How can it be detected?
49. Any experience with using API's? Programming API's? Google or Amazon
API's? AaaS (Analytics as a service)?
50. When is it better to write your own code than using a data science software
package?
51. Which tools do you use for visualization? What do you think of Tableau?
R? SAS? (for graphs). How to efficiently represent 5 dimension in a chart
(or in a video)?
52. What is POC (proof of concept)?
53. What types of clients have you been working with: internal, external,
sales / finance / marketing / IT people? Consulting experience? Dealing
with vendors, including vendor selection and testing?
54. Are you familiar with software life cycle? With IT project life cycle
- from gathering requests to maintenance?
55. What is a cron job?
56. Are you a lone coder? A production guy (developer)? Or a designer
(architect)?
57. Is it better to have too many false positives, or too many false negatives?
58. Are you familiar with pricing optimization, price elasticity, inventory
management, competitive intelligence? Give examples.
59. How does Zillow's algorithm work? (to estimate the value of any home in
US)
60. How to detect bogus reviews, or bogus Facebook accounts used for bad
purposes?
61. How would you create a new anonymous digital currency?
62. Have you ever thought about creating a startup? Around which idea /
concept?
63. Do you think that typed login / password will disappear? How could they
be replaced?
64. Have you used time series models? Cross-correlations with time lags?
Correlograms? Spectral analysis? Signal processing and filtering
techniques? In which context?
65. Which data scientists do you admire most? which startups?
66. How did you become interested in data science?
67. What is an efficiency curve? What are its drawbacks, and how can they
be overcome?
68. What is a recommendation engine? How does it work?
69. What is an exact test? How and when can simulations help us when we do
not use an exact test?
70. What do you think makes a good data scientist?
71. Do you think data science is an art or a science?
72. What is the computational complexity of a good, fast clustering algorithm?
What is a good clustering algorithm? How do you determine the number of
clusters? How would you perform clustering on one million unique keywords,
assuming you have 10 million data points - each one consisting of two
keywords, and a metric measuring how similar these two keywords are? How
would you create this 10 million data points table in the first place?
73. Give a few examples of "best practices" in data science.
74. What could make a chart misleading, difficult to read or interpret? What
features should a useful chart have?
75. Do you know a few "rules of thumb" used in statistical or computer science?
Or in business analytics?
76. What are your top 5 predictions for the next 20 years?
77. How do you immediately know when statistics published in an article (e.g.
newspaper) are either wrong or presented to support the author's point of
view, rather than correct, comprehensive factual information on a specific
subject? For instance, what do you think about the official monthly
unemployment statistics regularly discussed in the press? What could make
them more accurate?
78. Testing your analytic intuition: look at these three charts. Two of them
exhibit patterns. Which ones? Do you know that these charts are called
scatter-plots? Are there other ways to visually represent this type of data?
79. You design a robust non-parametric statistic (metric) to replace
correlation or R square, that (1) is independent of sample size, (2) always
between -1 and +1, and (3) based on rank statistics. How do you normalize
for sample size? Write an algorithm that computes all permutations of n
elements. How do you sample permutations (that is, generate tons
of random permutations) when n is large, to estimate the asymptotic
distribution for your newly created metric? You may use this asymptotic
distribution for normalizing your metric. Do you think that an exact
theoretical distribution might exist, and therefore, we should find it,
and use it rather than wasting our time trying to estimate the asymptotic
distribution using simulations?
80. More difficult, technical question related to previous one. There is an
obvious one-to-one correspondence between permutations of n elements and
integers between 1 and n! Design an algorithm that encodes an integer less
than n! as a permutation of n elements. What would be the reverse algorithm,
used to decode a permutation and transform it back into a number? Hint:
An intermediate step is to use the factorial number
system representation of an integer. Feel free to check this reference
online to answer the question. Even better, feel free to browse the web
to find the full answer to the question (this will test the candidate's
ability to quickly search online and find a solution to a problem without
spending hours reinventing the wheel).
81. How many "useful" votes will a Yelp review receive? My
answer: Eliminate bogus accounts (read this article), or competitor
reviews (how to detect them: use taxonomy to classify users, and location
- two Italian restaurants in same Zip code could badmouth each other and
write great comments for themselves). Detect fake likes: some companies
(e.g. FanMeNow.com) will charge you to produce fake accounts and fake
likes. Eliminate prolific users who like everything, those who hate
everything. Have a blacklist of keywords to filter fake reviews. See if
IP address or IP block of reviewer is in a blacklist such as "Stop Forum
Spam". Create honeypot to catch fraudsters. Also watch out for
disgruntled employees badmouthing their former employer. Watch out for 2
or 3 similar comments posted the same day by 3 users regarding a company
that receives very few reviews. Is it a brand new company? Add more weight
to trusted users (create a category of trusted users). Flag all reviews
that are identical (or nearly identical) and come from same IP address or
same user. Create a metric to measure distance between two pieces of text
(reviews). Create a review or reviewer taxonomy. Use hidden decision
trees to rate or score review and reviewers.
82. What did you do today? Or what did you do this week / last week?
83. What/when is the latest data mining book / article you read? What/when
is the latest data mining conference / webinar / class / workshop / training
you attended? What/when is the most recent programming skill that you
acquired?
84. What are your favorite data science websites? Who do you admire most in
the data science community, and why? Which company do you admire most?
85. What/when/where is the last data science blog post you wrote?
86. In your opinion, what is data science? Machine learning? Data mining?