This repository contains all members' solutions to the Alteryx Weekly Challenges in R and Python. It is designed to help participants get better at writing R and/or Python code.
This project was started on 2018-08-28 and the aim is to complete a challenge every week. Doing them at your own pace is also fine. We hope to go through some of the solutions on Python Mondays.
Alteryx Weekly Challenges
| Challenge Number | Challenge Name | Level of Difficulty | Main Subject |
|---|---|---|---|
| 1 | Challenge #1: Join to Range | Intermediate | Data Preparation |
| 2 | Challenge #2: Preparing Delimited Data | Beginner | Data Parsing |
| 3 | Challenge #3: Running Averages | Intermediate | Data Preparation |
| 4 | Challenge #4: Date Parsing | Advanced | Data Parsing |
| 5 | Challenge #5: HR Position Finder Application | Intermediate | Apps |
| 6 | Challenge #6: Spatial Route | Intermediate | Spatial |
| 7 | Challenge #7: Download Data and Parse JSON | Advanced | Data Parsing |
| 8 | Challenge #8: Aggregate Consumer Purchases | Beginner | Data Analysis |
| 9 | Challenge #9: Analytics Ranking | Beginner | Data Analysis |
| 10 | Challenge #10: Date Time Calculations | Intermediate | Data Analysis |
| 11 | Challenge #11: Identify Logical Groups | Intermediate | Data Analysis |
| 12 | Challenge #12: Creating an HR Hierarchy | Advanced | Macros |
| 13 | Challenge #13: HTML Table Parsing | Advanced | Data Parsing |
| 14 | Challenge #14: Warehouse Distribution | Intermediate | Macros |
| 15 | Challenge #15: Warehouse Shipped Miles | Beginner | Spatial |
| 16 | Challenge #16: Parsing Out the New-line Character | Beginner | Data Cleansing |
| 17 | Challenge #17: Month-over-Month Retention Rate | Advanced | Macros |
| 18 | Challenge #18: Predicting Baseball Wins | Intermediate | Predictive |
| 19 | Challenge #19: Excel Record Locator | Beginner | Data Cleansing |
| 20 | Challenge #20: List Parsing | Advanced | Data Preparation |
| 21 | Challenge #21: Date Reformatting | Beginner | Data Cleansing |
| 22 | Challenge #22: Identify Values to Aggregate | Intermediate | Data Parsing |
| 23 | Challenge #23: Parsing CPG Data | Advanced | Data Parsing |
| 24 | Challenge #24: ARIMA Time Series | Intermediate | Predictive |
| 25 | Challenge #25: Creating Merchant Combos | Intermediate | Data Analysis |
| 26 | Challenge #26: Service Technician Travel Distance | Beginner | Spatial |
| 27 | Challenge #27: Spatial Telco Coverage Smoothing | Intermediate | Spatial |
| 28 | Challenge #28: Formatting Morningstar Data | Intermediate | Data Cleansing |
| 29 | Challenge #29: Alteryx '16 Grand Prix (Race1, L1) | Intermediate | Data Preparation |
| 30 | Challenge #30: Alteryx '16 Grand Prix (Race 1, L2) | Beginner | Data Analysis |
| 31 | Challenge #31: Alteryx '16 Grand Prix (Race 2, L1) | Intermediate | Data Preparation |
| 32 | Challenge #32: Alteryx '16 Grand Prix (Race 2, L2) | Intermediate | Spatial |
| 33 | Challenge #33: Reshaping Nielsen Data | Intermediate | Data Preparation |
| 34 | Challenge #34: Date-Time Formatting | Advanced | Macros |
| 35 | Challenge #35: Data Cleansing Practice | Beginner | Data Cleansing |
| 36 | Challenge #36: Data Cleansing Extract Authors | Intermediate | Data Parsing |
| 37 | Challenge #37: Parsing a Raw XML File | Intermediate | Data Parsing |
| 38 | Challenge #38: Data Blending for Batch Output | Beginner | Data Preparation |
| 39 | Challenge #39: Trouble Shooting a Broken Macro | Intermediate | Macros |
| 40 | Challenge #40: Parsing a HTML File | Intermediate | Data Parsing |
| 41 | Challenge #41: Analytics PayPeriodCalc | Beginner | Data Analysis |
| 42 | Challenge #42: Inspire Europe '16 Grand Prix (L1) | Intermediate | Data Analysis |
| 43 | Challenge #43: Inspire Europe '16 Grand Prix (L2) | Intermediate | Data Analysis |
| 44 | Challenge #44: Inspire Europe '16 Grand Prix (L3) | Intermediate | Data Analysis |
| 45 | Challenge #45: Parsing Bureau of Labor Data | Advanced | Data Parsing |
| 46 | Challenge #46: Formatting a Date from an Integer | Beginner | Data Preparation |
| 47 | Challenge #47: Vehicle Identification Number Test | Intermediate | Data Preparation |
| 48 | Challenge #48: Calculating Distribution Priority | Intermediate | Spatial |
| 49 | Challenge #49: Reformatting Transactional Data | Beginner | Data Preparation |
| 50 | Challenge #50: Preparing Survey Data | Advanced | Data Analysis |
| 51 | Challenge #51: Spatial County Coverage | Intermediate | Spatial |
| 52 | Challenge #52: Solving the Knapsack Problem | Advanced | Data Analysis |
| 53 | Challenge #53: Parsing Report Formatted Data | Intermediate | Data Parsing |
| 54 | Challenge #54: Data Prep Address Parsing | Beginner | Data Parsing |
| 55 | Challenge #55: 2013 Alteryx Grand Prix (L1) | Intermediate | Data Analysis |
| 56 | Challenge #56: Parsing and Counting Hashtags | Intermediate | Data Analysis |
| 57 | Challenge #57: Build a Valentine's Day App | Intermediate | Apps |
| 58 | Challenge #58: An Odd String to Date Conversion | Beginner | Data Preparation |
| 59 | Challenge #59: Is it an Anagram? | Intermediate | Data Analysis |
| 60 | Challenge #60: Fill in the Spatial Object | Intermediate | Spatial |
| 61 | Challenge #61: Save the Astronaut | Advanced | Data Analysis |
| 62 | Challenge #62: Find the Duplicate Clicks | Intermediate | Data Analysis |
| 63 | Challenge #63: Data Preperation Using Pivot Tools | Intermediate | Data Preparation |
| 64 | Challenge #64: Catch Me If You Can | Intermediate | Data Preparation |
| 65 | Challenge #65: Fulfilling Inventory Orders | Beginner | Data Analysis |
| 66 | Challenge #66: My Wine Problem | Intermediate | Macros |
| 67 | Challenge #67: Calculate Spatial Angles | Intermediate | Spatial |
| 68 | Challenge #68: Elapsed Classroom Times | Beginner | Data Analysis |
| 69 | Challenge #69: Web Stock Data | Beginner | Data Parsing |
| 70 | Challenge #70: Trade Area Drivetime Radii | Beginner | Spatial |
| 71 | Challenge #71: Recreate SQL Joins in Alteryx | Intermediate | Data Preparation |
| 72 | Challenge #72: Compare Data Sets (Fields/Columns) | Intermediate | Data Preparation |
| 73 | Challenge #73: Plinko Probabilities | Advanced | Data Analysis |
| 74 | Challenge #74: Build a Factorial Calculator | Beginner | Macros |
| 75 | Challenge #75: Scrabble Word Finder | Advanced | Data Preparation |
| 76 | Challenge #76: Strava Export Parse and Report | Intermediate | Data Parsing |
| 77 | Challenge #77: Extending Spatial Lines | Intermediate | SpatialMacros |
| 78 | Challenge #78: Find the Best Housing Markets | Intermediate | Data Parsing |
| 79 | Challenge #79: Find the Closest Prime Number | Intermediate | Apps |
| 80 | Challenge #80: Slowly Changing Dimensions | Intermediate | Data Preparation |
| 81 | Challenge #81: Multi-Level Bill of Materials Problem | Intermediate | Data Analysis |
| 82 | Challenge #82: Are You in the Path of the Solar Eclipse? | Intermediate | Spatial |
| 83 | Challenge #83: Pop-Tart and Beer Pairings | Intermediate | Data Preparation |
| 84 | Challenge #84: Map Hurricane Harvey's Storm Evolution | Intermediate | Spatial |
| 85 | Challenge #85: How Did Tara Place in Competition? | Intermediate | Data Analysis |
| 86 | Challenge #86: Create a Macro that Generates Past Dates | Advanced | Macros |
| 87 | Challenge #87: Losing Daylight | Beginner | Data Analysis |
| 88 | Challenge #88: Counting Combinations | Beginner | Data Analysis |
| 89 | Challenge #89: Analyzing Social Data | Beginner | Data Analysis |
| 90 | Challenge #90: Analyzing Social Data (Part 2) | Intermediate | Data Analysis |
| 91 | Challenge #91: Getting into the Weeds | Advanced | Apps |
| 92 | Challenge #92: The Blob! | Beginner | Data Parsing |
| 93 | Challenge #93: Pumpkin Production | Beginner | Data Analysis |
| 94 | Challenge #94: Have we reached Peak Pumpkin? | Advanced | Predictive |
| 95 | Challenge #95: Draw 1000 Apples in Under 60 Seconds | Advanced | Spatial |
| 96 | Challenge #96: Who Stole my Latte? | Intermediate | Data Preparation |
| 97 | Challenge #97: SANTALYTICS 2017 - Part 1 | Intermediate | Data Preparation |
| 98 | Challenge #98: SANTALYTICS 2017 - Part 2 | Intermediate | Data Analysis |
| 99 | Challenge #99: SANTALYTICS 2017 - Part 3 | Advanced | Data Analysis |
| 100 | Challenge #100: Find Ned! | Advanced | Spatial |
- Philip Mannering
- Alex Jones
- Rachel Phang
- David Sanchez Martin
- William Guicheney
- Jamie Gough
The top 10 solvers are: Create script that tallies up everyone's contribution and create table here!
Markdown - If you want to edit this README.md file!
Happy Coding :)