Data Analyst Interview Questions

Alex C. - "I would have been destroyed on this."See full answer

Prachi G. - "The solution produces the same result as the 'prescribed solution' yet it does not get accepted In the test results section transcript['year'] = transcript['year'].astype(str) df = pd.pivottable(data = transcript, index = 'studentid', columns = 'year', values = 'yearlygpa', aggfunc = 'mean').resetindex() df = df[(df['2021'] < df['2022']) & (df['2022'] < df['2023'])] df['average_gpa'] = df[['2021', '2022', '2023']].mean(axis=1).round(2) return df "See full answer

Anonymous Cricket - "Clarify can we limit traffic to normal commute time for people going to work in their city? Not include business travel? (Recognize traffic can mean: pick up drop off kids; errands, grocery, shopping, social, people who drive for their job etc.) limit to US? pre-covid time? Equation \# of working people in US x # of hours commute per year per person \# of working people in US 320M total population, 40M per age group of 10 years working age = 20 to 70, 5 groups of 1"See full answer

Priyanka D. - "Target Consumers: corporate clients - for business meetings students (in school, college) aspirants who want to take competitive exams/tests Identify underserved customer needs: re-application leads to post-it's not being sticky enough space crunch so user needs to be precise post-its need to stick from all 4 corners for it to be readable and so it folds less writing with pen, marker gets imprinted on next page Define Value Proposition: a small piece of paper with concise list of"See full answer

Chao peter Y. - "The question is incomplete --- the code only passes if you return the data frame sorted by BOTH department name AND rank. While in the problem description, it mentions to only rank by department name: "The results should be ordered by department name." Not a big difference I know, but students shouldn't need to look into the solution to get the necessary knowledge to answer the question."See full answer