Challenge #231: What a Combo!

A solution to last week’s challenge can be found here. Source: https://commons.wikimedia.org/wiki/File:Combination.png

This week's challenge was submitted by @Kenda - Thanks for your submission!

Mathematicians and statisticians often work with permutations and combinations. In this challenge, we will focus on the latter. You are given 15 unique variables. The goal is to create a list of each of the combinations containing 3 variables (that is, 15C3). Remember, with combinations, order does not matter and the same variable cannot show up more than once in a given combination.

Since @Kenda is vertical user, this week's challenge is also a vertical workflow!

challenge_231_start_file.yxmd

challenge_231_solution.yxmd

Parse

Join

Preparation

Data Analysis

Intermediate

Core

Transform

Accepted answers

All comments

johnemery

Enjoyable challenge, but that vertical layout.... oof.

Spoiler

View my solution video here:

Spoiler

Challenge 231 Solution jemery.yxmd

Blake

Nice challenge, @Kenda!

Spoiler

Check out my video solution :

Spoiler

challenge_231_start_file_BH_.yxmd

atcodedog05

Fun challenge. Knew combinations for a while, but this is the first i am implementing.

Thank you for this challenge @Kenda

got agree with @johnemery . Suddenly working with vertical flow is not easy.

Spoiler

PS: I started with vertical flow eventually moved to horizontal orientation.

I wonder whether any other way of optimizer tool exist for this.

Cheers and Happy Analyzing 🙂

challenge_231_atcodedog05_solution.yxmd

Aaron_Harter

Thanks @Kenda for the fun challenge!

While I respect the vertical canvas orientation, I switched my canvas to horizontal to fit my annotation style:

Spoiler

challenge_231_AB Data_Aaron.yxmd

phottovy

Here is my inefficient answer!

challenge_231_ph_solution.yxmd

patrick_digan

Spoiler

I tried to make it "dynamic" so that it could be turned into a macro easily. For small datasets like this, I like holding info in comma separated strings. I did that A LOT in the AdventOfCode AlteryxOfCode challenges last December.

challenge_231_start_file.yxmd

Sashikumar

i love it.

challenge_231_start_file_sk.yxmd

philipmannering

Thank you @Kenda! Not yet a vertical convert, but will try it from time to time.

Spoiler

Workflow

Challenge 231 - What a Combo.yxmd

philipmannering

Solution using Python's marvelous itertools,

Spoiler

RobertW

Never used vertical layout. Very interesting.

Spoiler

challenge_231_start_file.yxmd

RolandSchubert

Interesting challenge, thank you @Kenda. It took me some time to get used to the vertical layout, but I will definitely try it again.

Spoiler

challenge_231_solution_rsc.yxmd

MattK

Seems like I had a relatively novel/compact solution compared to those posted so far!

I'm normally a horizontal user but enjoyed trying vertical for once. Weird to me to move the log to the right hand side to add to my available space.

challenge_231_mrk_solution.yxmd

etzele

Everybody seems to have a different solution. Here is mine:

Spoiler

challenge_231_solution.yxmd

gffcoutinho

Hello,

It's my first time submitting an answer and the first time using Alteryx. The magic happens on the formula step.

I also can't use the vertical layout as I don't find them compact enough to fit one screen wherever possible. And if a function to pick the nth lastest value would exist, my solution would be more elegant, in my opinion.

Thank you for the challenge, @Kenda.

challenge_231.yxmd

cgoodman

Here's my solution:

Spoiler

challenge_231_solution.yxmd

dsmdavid

Bit of a brute force approach, which works for this small sample, else worth considering a python tool

Edit: much prefer the version with generate rows.

🙂

Spoiler

david_231.yxmd

alexdel

Spoiler

allwynthomas24

Don't know whether its the right way but used Generate Rows Tool to get the desired combination output. Anyways the best part, got to learn about the tool.

Spoiler

Workflow:

Thanks & Regards,

Allwyn Thomas

challenge_231_solution_AllwynThomas.yxmd

balajilolla

Spoiler

Solution Attached

challenge_231_start_file.yxmd

NithinK

Spoiler

Found it difficult at the beginning with the vertical layout but found an easier way to get it done (switching the configuration window - Layout Direction).

Good one!

challenge_231_solution_knk.yxmd

RupaliMore

import warnings
import itertools
import pandas as pd
import numpy as np
import statsmodels.api as sm

# Define the p, d and q parameters to take any value between 0 and 15
p = d = q = range(0, 15)

# Generate all different combinations of p, d and q triplets
pdq = list(itertools.product(p, d, q))
print(pdq)

Miles_Waller

I think I figured it out! Workflow attached.

Spoiler

challenge_231_Complete_MW.yxmd

Jean-Balteryx

Here is my solution !

challenge_231_workflow.yxmd

DaisukeTsuchiya

It was easy.

Spoiler

challenge_231_start_file_DT.yxmd

LHolmes

Always love a fun math challenge. My solution came out much simpler than most of the ones I saw but have not dug into any workflows to understand the extra steps and if they would be necessary.