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

1.The most success and failure customers

2.Ratio of acceptor

3.SQL Problem Solving

4.How to test a probability problem

5.Calculate Business Interaction Weights

6.Evaluating Overall Effectiveness from Multiple A/B Tests

7.Applying Bonferroni Correction in Multiple A/B Tests

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

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

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

11.User Rating System Similarity Score

12.Designing a Personalized Landing Page

13.Calculate Similarity Between Two Names

14.Restaurant Waiting Time

15.Prefix Search

16.Python Pandas Data Cleaning

17.SQL Query for Popular Items

18.Jaccard Similarity Calculation

19.Identify Customers with Most Successes and Failures in Campaigns

20.Calculate Donor to Acceptor Ratio

21.Medium difficulty SQL and pandas in Python

22.Statistical knowledge and A/B testing

23.Review Summary Status Algorithm

24.Business Similarity Python Script

25.City Blood Donation Ratio SQL Query

26.Intermediate Activity SQL Query

27.AB Testing Fundamentals

28.Python Functions for Maximum Values

29.SQL Query for Business Data

30.Business Review Suggestions Ranking

31.Predicting Business Type for Yelp

32.Python Business Filter Similar to a LeetCode Problem

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

34.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. SQL Problem Solving

During an SQL assessment, you encounter a question that seems to have issues and cannot be solved considering special cases. How would you handle this situation during the interview?

4. 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.

5. 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.