If the number of Facebook friend requests dropped by 10%, how would you investigate the problem as a data scientist?
Data Interview Questions
133,160 data interview questions shared by candidates
Data Model: LinkedIn data model - model for 1st degree connection Python: 1. Dedup items in the list - retaining the order of items. ==> cannot use dict/set since order will not be retained. Follow up question on this - How would you handle nested lists? (they are looking for recursion) 2. Find the number of words in a sentence /avg length of word SQL On the product-sales-customers data model that is preloaded in coderpad.io, write the following queries 1. Count of stores in OR state with area_sqft > 25000 2. avg number of Female Customers group by state 3. Customer FirstName, Last Name and count of unqiue products purchased by state followup question - Return the top customer by state based on diverse product purchased (diverse = count(distinct product_id))
How many orders of Fries does McDonald's sell in a year?
What percent of all products in the grocery chain's catalog are both low fat and recyclable?
Write a query that returns product_family, units_sold, percentage of promoted.
Write a python program to remove duplicates , keep the first occurrance
You have 24 hours, how would you measure what % of FB stories are fake news? How would you refine your process if you have more time?
How will you analyze if launching stories is a good idea? What data would you look at?
The rest 30minutes was for algorithmic programming in language of your choice. I completed 3.5 questions in 30minutes.
SQL Coding: 5 questions 4 tables were given and questions were mostly on joins, aggregate functions, sub queries. Python Coding: I guess there were total 5 questions but could reach only till second question. Count the number of words in a sentence. Count the frequency of words from the list and store the results in a hash map.
Viewing 1141 - 1150 interview questions