Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #447: Analysis of Survey Results Delivered in a Consolidated Format

AYXAcademy
Alteryx
Alteryx

Banner_WC_October Takeover.png

 

Hello Community Members,

 

A solution to last week’s challenge can be found here

 

We are wrapping up the October Takeover event with this fourth challenge submitted by Akimasa Kajitani (@AkimasaKajitani)  from the Tokyo User Group. Huge thanks to Aki for this fantastic challenge and his contributions to the Tokyo User Group.

 

For this week’s challenge, your task is to highlight the impressions people have of Jupyter Notebook, one of the most widely used Python development environments in data science. Many of you may already be familiar with it, especially since it is integrated into the Python tool in Alteryx Designer.

 

Your challenge is to analyze survey results on Jupyter Notebook usage. The data provided includes responses, but there is a twist—some survey entries are incomplete, and you need to remove them, also all the questions and answers are merged into a single cell in Excel.

 

To solve this challenge, your first step is to organize the responses to Questions 1 through 10 into a table. Then, complete the following tasks:

  1. Calculate the median, maximum, and minimum time (in minutes) that respondents took to complete the survey.
  2. Determine the count and percentage of respondents who use Jupyter Notebook regularly.

Hint: Use the frequency labels from the question How often do you use Jupyter Notebook?

  1. Analyze responses to Question 7 to identify the top five words used by respondents to best describe Jupyter Notebook.

 

Happy solving!

 

Data Source: https://data.world/technology/jupyter-notebook-ux-survey

Note: The format of this data has been modified to meet the objectives of this challenge.

 

The Academy Team

alacoume
9 - Comet

My solution: 

Spoiler
Challenge_447.jpg
PhilipMannering
16 - Nebula
16 - Nebula

Solution attached.

 

Spoiler
image.png
mmontgomery
11 - Bolide
11 - Bolide

c447

Spoiler
c447.png
patrick_digan
17 - Castor
17 - Castor
Spoiler
image.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution!

 

Spoiler
image.png
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
447.jpg
ahsanaali
11 - Bolide
Spoiler
447.png

Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
wdula
8 - Asteroid
Spoiler
Solution.png

A bit of a doozy haha