Q1. SQL Given tables: employees(id, unixname,team,role,days_since_started) projects(id,name,....) commits(id,file_path,proj_id,auth_id,timestamp) Find the number of unique employees per project per month? Q2. Imagine you have a CSV file: john_doe,android,ios,infra bob_law,is,backend jane_doe,frontend ------------------------------ Containing,for each employee, a list of projects he/she works on Write a script/function/else that reads data from CSV file and creates a data structure that stores, for each project, a list of employees who work on it.
Data Scientists Interview Questions
54,213 data scientists interview questions shared by candidates
It's a phone interview about technical question. About how to generate all possible friendship given four tables with the "request", "accept","reject", and "remove" information.
How many dentist are there in the US?
Given a database of posts and a database of comments on those posts, how do you determine how many conversations are happening in the comments per post on average.
The three data structure questions are: 1. the difference between linked list and array; 2. the difference between stack and queue; 3. describe hash table.
Q. Tell me about a time when you were short on deadline and how did you handle it? Q. Write a Python code to return the count of words in a string Q. What is cross validation Q. Tell me about your favorite algorithm
How to build a dictionary in such a way that it'd be efficient to search for all valid words which are permutations of a given string?
If you were the one interviewing, what type of person would you look for, for this role?
How would you build and test a metric to compare two user's ranked lists of movie/tv show preferences?
What is probability of getting one pair of card from 52 deck of cards? How would you improve work hours?
Viewing 101 - 110 interview questions