Data Interview Qs - Active users on a messaging application

Active users on a messaging application
Data Analysis Python Pandas Data Manipulation External Dataset

Here is a table containing information from a P2P messaging application. The table contains send/receive message data for the application's users. The structure is as follows:

Table name: user_messaging

date
sender_id (#id of the message sender)
receiver_id (#id of the message receiver)

Question: Using Python, calculate what fraction of senders sent messages to at least 9 unique people on March 1, 2018.

//

Click here to view this problem in an interactive Colab (Jupyter) notebook.






Want the solutions? Upgrade to premium to access detailed solutions to each problem (including this one).

Was this email forwarded to you? You can join our list here to receive questions


Unsubscribe

Older messages

Pricing a coin flip

Friday, March 19, 2021

Data Interview Qs Pricing a coin flip Statistics Probability Theory Suppose a casino has created a new game, determined via coin toss. If the coin is tails, the individual is paid $1, and if the coin

Checking whether array elements can be made equal

Wednesday, March 17, 2021

Data Interview Qs Checking whether array elements can be made equal Python Data Structures Arrays Given an array a, write a function to feed in the array elements and check whether they can all be made

Shoe prices

Monday, March 15, 2021

Data Interview Qs Shoe prices SQL Database Querying Update Function Suppose you are given a SQL table containing the brands of shoes (field name: brand) as well as the shoe price (field name: price).

Filtering strings in Pandas dataframes

Saturday, March 13, 2021

Data Interview Qs Filtering strings in Pandas dataframes Data Analysis Python Pandas Data Manipulation Given the following dataframe, write code using Python (Pandas) to return the rows that contain

One way Anova

Wednesday, March 10, 2021

Data Interview Qs One way Anova Statistics ANOVA Test Give an example of when you would want to use a One Way ANOVA test. Walk through the example, your reasoning for choosing a One Way ANOVA, and the

You Might Also Like

[Virtual talk] How to remove the biggest blocker to production AI/ML

Monday, May 20, 2024

ML teams are being asked to power every customer experience and interaction with AI/ML. The pressure to go faster is high, but the reality is that the complex data engineering to get the right data to

What to expect from Microsoft Build 2024

Monday, May 20, 2024

The Morning After It's Monday, May 20, 2024. Normally, Microsoft's Build is a straightforward (often dry) showcase of the company's software and hardware developments, with a dash of on-

Import AI 373: Guaranteed safety; West VS East AI attitudes; MMLU-Pro

Monday, May 20, 2024

…As the money and stakes get higher, things will get crazier… ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏

Cyber Criminals Exploit GitHub and FileZilla to Deliver Cocktail Malware

Monday, May 20, 2024

THN Daily Updates Newsletter cover Webinar - Navigating the SMB Threat Landscape: Key Insights from Huntress' Threat Report Analyzing the Post-Qakbot Era and Emerging Threats with Cybersecurity

Architecture Weekly #180 - 20th May 2024

Monday, May 20, 2024

We started with an invitation to discuss Conway's Law. Then, we discussed recent Cloud provider mishaps. Well, one AWS mishap on the bill for a DDoSed S3 bucket and a nightmare from Google Cloud

Retiring!

Monday, May 20, 2024

Moving to a different Newsletter ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏

SRE Weekly Issue #425

Monday, May 20, 2024

View on sreweekly.com Welcome to a special re-send of SRE Weekly Issue #425! For those of you getting this for a second time, my apologies. I attempted to change to a new email vendor, but they

SRE Weekly Issue #425

Monday, May 20, 2024

View on sreweekly.com A message from our sponsor, FireHydrant: FireHydrant is now AI-powered for faster, smarter incidents! Power up your incidents with auto-generated real-time summaries,

🤖 Will AI Gadgets Replace Our Smartphones? — 4 Ways to Use Excel in Daily Life

Sunday, May 19, 2024

Also: How to Declutter Your Google Search Results, and More! How-To Geek Logo May 19, 2024 📩 Get expert reviews, the hottest deals, how-to's, breaking news, and more delivered directly to your

Daily Coding Problem: Problem #1446 [Medium]

Sunday, May 19, 2024

Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Google. Given a set of closed intervals, find the smallest set of numbers that covers