PracHub
QuestionsPremiumCoachesLearningGuidesInterview Prep

Quick Overview

This question evaluates proficiency in data manipulation and relational reasoning using Python/pandas, focusing on transforming event logs into canonical pairwise relationships and extracting activation timestamps.

  • Medium
  • Roblox
  • Data Manipulation (SQL/Python)
  • Data Scientist

Generate Friendship List with Acceptance Dates Using Pandas

Company: Roblox

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: Medium

Interview Round: Onsite

friend_events | requester_id | accepter_id | request_date | accept_date | |--------------|-------------|--------------|-------------| | 1 | 2 | 2024-01-01 | 2024-01-02 | | 2 | 3 | 2024-01-03 | 2024-01-05 | | 3 | 2 | 2024-01-04 | 2024-01-05 | | 2 | 1 | 2024-01-06 | 2024-01-07 | | 4 | 1 | 2024-01-08 | 2024-01-09 | ##### Scenario After launching a social feature, product wants a list of confirmed friendships with the date they formed. ##### Question Given friend request logs, write Python/pandas that returns each distinct user pair once (smaller id first) and the acceptance date when the friendship became active. ##### Hints Filter accepted rows, sort ids, drop_duplicates.

Quick Answer: This question evaluates proficiency in data manipulation and relational reasoning using Python/pandas, focusing on transforming event logs into canonical pairwise relationships and extracting activation timestamps.

Last updated: Mar 29, 2026

Loading coding console...

PracHub

Master your tech interviews with 8,500+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities
  • Student Access

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.

Related Coding Questions

  • Write SQL for influence score and follower growth - Roblox (easy)
  • Match requests and accepts into friendships in SQL - Roblox (Medium)
  • Clean and aggregate factory event data in Pandas - Roblox (Medium)
  • Implement deduped CTR/RPM aggregator over event stream - Roblox (Medium)
  • Compute CTR, RPM, and daily RPM variability in SQL - Roblox (Medium)