Data scientist Interview Questions in Boston, MA | Glassdoor

Data scientist Interview Questions in Boston, MA

"Every business collects data, and it's the job of the data scientist to analyze, interpret, and communicate that information in a way that will help drive company decisions. In an interview, expect to answer technical questions about your ability to perform quantitative tests as well as create clear visualizations of large, complex data sets. Come ready to discuss past projects you've worked on and how you communicate data findings clearly and concisely in order to help solve business-related problems."

Top Interview Questions

Sort: RelevancePopular Date

A table has a column with full names(e.g. 'Tom Hardin'). write a python code to get distinct first names(i know its super easy in sql)

5 Answers

select distinct (substr(fullname, 0, instr(fullname,' ')-1)) from data

Assuming table has only one column and first & last name separated with space. f = open('file','r') set([i.split(" ")[0] for i in f]) f.close

import pandas as pd df = pd.read_csv('name.csv') df['First Name'] = df['Full Name'].apply(lambda x: x.split(' ')[0]) df['Surname'] = df['Full Name'].apply(lambda x: x.split(' ')[1])

SQL : Top 3 Products by sale, % using Case, Basic Having clause and one Set operator (Intersect) type question Python : Average word length, ip-address parsing, dictionary, list of lists, flatten list of lists. ( Similar to previous interview experiences)

6 Answers

Mostly case based questions intended to see my ability to reason through the problems the team was facing at the time of my interview. Also some more technical coding questions.

5 Answers

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.

4 Answers

Phone Interview #2 You are playing a game of baseball. There are two outs in the bottom of the ninth, and you are down by one run. You are currently a baserunner on first base. [Obviously, you must score or else the game ends]. A)You are trying to figure out if you should steal second base or not. What kind of information do you need to know to inform this decision? B) Every batter in your lineup has identical odds.They get a single 50% of the time and they strike out 50% of the time. If you are on first base, you cannot score on a single. If you are on second, you are guaranteed to score on a single. You successfully steal 75% of the time. Should you steal? [I may be missing some of the nonsense here, but this is all the relevant information] C) It turns out the pitcher acts a bit differently with a runner on second [regardless of who the batter is] and no other runners on base. Under these circumstances, he is 50% to strike them out, 40% to surrender a walk, and 10% to surrender a hit. How does this change things/ should you steal?

3 Answers

Technical case interview which is a mix of modelling skills + classical case interview structure

3 Answers

How would you correlate each device a person visits the website with back to that person?

3 Answers

They gave me a hypothetical fantasy sports game and asked me to find the appropriate prize pool for the game

2 Answers

What does our market data analyst do?

2 Answers

In my opinion the most challenge question is to ask you to determine whether the difference of mean values of two columns is significant or not?

2 Answers
110 of 455 Interview Questions