Data scientist Interview Questions in Boston, MA | Glassdoor.co.in

Data scientist Interview Questions in Boston, MA, US

253

data scientist interview questions shared by candidates

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])

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

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

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

They did not ask me any technical questions

2 Answers

Write a program in Python to calculate tax if Salary and Tax Brackets are given as list in the form [ [10000, .3],[20000, .2], [30000, .1], [None, .1]]. You don’t know in the beginning how many tax brackets are there. You have to test for all of them.

3 Answers

One or more comments have been removed.
Please see our Community Guidelines or Terms of Service for more information.

They focus a lot on their leadership principles and your resume

2 Answers

In an array having 0s and 1s , sort such that all 0s are seperated by all 1s.

1 Answer
110 of 253 Interview Questions