Data Interview Qs - Data Interview Questions: Problem #64
Application feedback
Data Analysis Python Pandas Data Manipulation
Your team at Apple released a new feature that collects feedback when an app launches. As part of the Alpha Launch for testing, the feedback consists of 1 question within a dialog box that asks "Would you like to give {App Name} your credit card number?", with potential answers being "Yes" and "No".
This data is logged within a table named 'dialogbox_feedback' with the following schema:
Table: dialogbox_feedback| Column Name | Data Type | Description |
|---|---|---|
| time | integer | epoch time of response |
| user_id | integer | unique id of user |
| app_id | integer | unique id of application |
| app_name | string | name of application |
| event | string | Possible values are: impressed (when user sees the dialog box), "Yes" (when user clicks yes). There is no logging for when the user clicks "No". |
Question: A Product Manager asked you to give an update on how the Alpha Launch is going. You decide to aggregate (e.g. pivot) the events by each app to provide a quick summary. Write the aggregation using Python (Pandas).
Want the solutions? Upgrade to premium to access detailed solutions to each problem (including this one, as well as the questions you've previously received).
Was this email forwarded to you? You can join our list here to receive questions
Unsubscribe
Older messages
Data Interview Questions: Problem #63
Monday, August 31, 2020
Data Interview Qs Chi square testing candy distribution Statistics Chi-square Test Suppose Candy Company XYZ produces lollipops. The company claims that 30% of the lollipops are cherry, 60% are grape,
Data Interview Questions: Problem #62
Friday, August 28, 2020
Data Interview Qs American Football Scoring Python Algorithms There are a few ways we can score in American Football: 1 point - After scoring a touchdown, the team can choose to score a field goal 2
Data Interview Questions: Problem #61
Wednesday, August 26, 2020
Data Interview Qs Twitch content creators SQL Database Querying You are working for a company like Twitch.tv. Twitch.tv is a live streaming platform, where content creators (eg the people creating
Data Interview Questions: Problem #53
Tuesday, August 25, 2020
Data Interview Qs Reddit comment activity SQL Database Querying Suppose you're working for Reddit as an analyst. Reddit is trying to optimize its server allocation per subreddit, and you've
Data Interview Questions: Problem #55
Tuesday, August 25, 2020
Data Interview Qs Rolling 9s for $50 Statistics Probability Theory Expected Value Suppose you are playing a game where there are two fair six-sided dice, and every time you roll the dice and they add
You Might Also Like
Daily Coding Problem: Problem #1431 [Medium]
Saturday, May 4, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by MongoDB. Given a list of elements, find the majority element, which appears more than
Ranked | The World's Top Media Franchises by All-Time Revenue 📊
Saturday, May 4, 2024
From Pokémon to Star Wars, some media franchises are globally recognizable. How do media franchises compare in terms of all-time revenue? View Online | Subscribe Presented by Voronoi: The App Where
Noonification: Read Code Like a Hacker With the SAST
Saturday, May 4, 2024
Top Tech Content sent at Noon! Get Algolia: AI Search that understands How are you, @newsletterest1? 🪐 What's happening in tech today, May 4, 2024? The HackerNoon Newsletter brings the HackerNoon
Weekend Reading — May the fourth
Saturday, May 4, 2024
This week we setup our new Minecraft server, play Spacewar, avoid burnout, wonder about Facebook AI spam, lose our passkeys, and claim stairs on the way back home. 😎 Labnotes (by Assaf Arkin) Weekend
Google lays off workers
Saturday, May 4, 2024
Plus: Tesla cans its Supercharger team and UnitedHealthcare reveals security lapses View this email online in your browser By Kyle Wiggers Saturday, May 4, 2024 Image Credits: Tomohiro Ohsumi / Getty
When It Rains, It Pours ☔
Saturday, May 4, 2024
Why the umbrella's design can't be beat. Here's a version for your browser. Hunting for the end of the long tail • May 04, 2024 Hey there, Ernie here with a refreshed piece about umbrellas
🐍 New Python tutorials on Real Python
Saturday, May 4, 2024
Hey there, There's always something going on over at realpython.com as far as Python tutorials go. Here's what you may have missed this past week: Python's unittest: Writing Unit Tests for
Microsoft Outlook Flaw Exploited by Russia's APT28 to Hack Czech, German Entities
Saturday, May 4, 2024
THN Daily Updates Newsletter cover Webinar -- Data Security is Different at the Petabyte Scale Discover the secrets to securing fast-moving, massive data sets with insights from industry titans
Stop spam texts today!
Saturday, May 4, 2024
Have you been receiving a ton of spam texts lately? In April alone, spammers sent out over 19.2 billion texts. Ever wonder where they get your info to begin with? Data brokers. They sell your address,
DeveloPassion's Newsletter #165 - She Said Yes ❤️
Saturday, May 4, 2024
Edition 165 of my newsletter, discussing Knowledge Management, Knowledge Work, Zen Productivity, Personal Organization, and more! Sébastien Dubois DeveloPassion's Newsletter DeveloPassion's