Reddit数据相关面经_Reddit数据相关面试真题及高频题

1.Calculate Event Counts

2.Favorite App Product Case

3.SQL Top 5 of Each Group

4.Python Coding Challenge

5.Machine Learning Project Experience

6.Aggregate JSON Objects by Dimensions

7.Statistical Test Selection

8.Opportunity Sizing and Experiment Design

9.Metric Investigation and Business Interpretation

10.Sorting Based on Timestamps

11.Binary Classification Model Training and Testing

12.Machine Learning System Design for an Advertising System

1. Calculate Event Counts

Given a set of data with each line containing a timestamp, event type, and event count, calculate the total number of events for each type over the past seven days.

2. Favorite App Product Case

Discuss your favorite app and if you were to launch it, what experience would you focus on? Suggest any new features, describe how you would test these features, and what metrics you would use to measure their success.

3. SQL Top 5 of Each Group

Write an SQL query to retrieve the top 5 records from each group in a dataset. Review window functions and ranking methods to accomplish this task.

4. Python Coding Challenge

Complete a Python coding challenge on CoderPad (details not provided in the text).

5. Machine Learning Project Experience

Discuss a machine learning project you have worked on. Explain the methods you implemented and how you defined the k-means clusters.