Yelp数据相关面经_Yelp数据相关面试真题及高频题

1.The most success and failure customers

2.Ratio of acceptor

3.How to test a probability problem

4.Calculate Business Interaction Weights

5.Evaluating Overall Effectiveness from Multiple A/B Tests

6.Applying Bonferroni Correction in Multiple A/B Tests

7.Decision Making Based on Significant A/B Test Results

8.Interpreting A/B Test Results with a 2% CTR Improvement

9.Designing an A/B Test for a New Feature in the Yelp App

10.User Rating System Similarity Score

11.Designing a Personalized Landing Page

12.Calculate Similarity Between Two Names

13.Restaurant Waiting Time

14.Prefix Search

15.Python Pandas Data Cleaning

16.SQL Query for Popular Items

17.Jaccard Similarity Calculation

18.Identify Customers with Most Successes and Failures in Campaigns

19.Calculate Donor to Acceptor Ratio

20.Medium difficulty SQL and pandas in Python

21.Statistical knowledge and A/B testing

22.Review Summary Status Algorithm

23.Business Similarity Python Script

24.City Blood Donation Ratio SQL Query

25.Intermediate Activity SQL Query

26.AB Testing Fundamentals

27.Python Functions for Maximum Values

28.SQL Query for Business Data

29.Business Review Suggestions Ranking

30.Predicting Business Type for Yelp

31.Python Business Filter Similar to a LeetCode Problem

32.SQL Query to Find the Product with the Maximum Discount in Each Category

33.SQL Query to Find Activity Count That Is Neither Maximum Nor Minimum

1. The most success and failure customers

| 三个input table，第一个table是customer id 和name，第二个table是campaign
id, customer id和campaign name，第三个table是campaign id 和 success / failure,要求output success 最多和failure最多的customer。

2. Ratio of acceptor

两个input table，分别是blood donor和acceptor，算每个城市donor：acceptor的ratio
output出ratio最高和最低的。

3. How to test a probability problem

During the interview, a follow-up question was asked about how to test a probability problem. Discuss the approach you would take to test such a problem, including any considerations for edge cases and the use of global variables and pointers, especially in the context of Python's shallow copy and deep copy.

4. Calculate Business Interaction Weights

Given a list of user interactions with businesses on Yelp, where each interaction type has a specific weight (review: 1, comment: 2, liked: 0.3, etc.), write a function to calculate the total weight for each business ID. Then, sort the businesses by descending total weight and ascending business ID, and return a list of the sorted business IDs.

5. Evaluating Overall Effectiveness from Multiple A/B Tests

If ten separate A/B tests each show a 5% improvement, and the product manager claims a total improvement of 50%, how would you assess this claim?