Tools For Humanity·Data Scientist·Technical Phone Screen
- Given a table of posts and replies with timestamps, find the number of distinct original post authors who have at least one post that received 2 or more replies within 7 days of the original post being created.
- Among users who received at least one reply to any of their original posts, what percentage received replies from at least two distinct US-based repliers?
“The 7-day window tripped me up a bit because I kept second-guessing whether 'inclusive' meant I should use <= 7 or < 7 in the date diff.”