Challenge #169: Women's World Cup Wins

AYXAcademy

A solution to last week's challenge can be found here.

Using the values in the attached file "womens_world_cup_data.txt", determine which team won the most matches.

Go Team USA!

womens_world_cup_data.txt

challenge_169_start_file.yxmd

challenge_169_solution.yxzp

Join

Preparation

Data Analysis

Data Preparation

Transform

Basic

Foundation

Accepted answers

All comments

cgoodman

Spoiler

I like how the input data is a separate file as it:
1) checks users know how to read in different delimited files
2) As users are likely to save the input file to the same location as the workflow then it makes viewing other people's solutions a bit easier compared to when the files are packaged up.

Here's my solution:

challenge 169.PNG

challenge_169_solution.yxmd

afv2688

Nice one 🙂

Spoiler

challenge_169_end_file.yxmd

Verakso

I do love the weekly challenges, and here is my solution

Spoiler

This is a nice "beginner" task, since you will need to import the CSV file yourself.

Meaning, finding the right tool and the import a ANSI file that has tab as delimiter (\t).

Settings

I am not sure if it is "cheating" to use the Formula tool, but the winner can be determined using a formula like this:

Winner = IF [score_i]>[score_j] THEN [Team_i] ELSEIF [score_i]<[score_j] THEN [Team_j] ELSE Null() ENDIF

The is was just a matter on do a Count NonNull's on the result, sort and pick the fist record

Workflow

That is how I matched the provided result

Result Result

Still Climbing

/Verakso

challenge_169_solution_verakso.yxmd

pasccout

Nice little challenge!

challenge_169_my_solution.yxmd

wwatson

My Solution

challenge_169.yxmd

danilang

Fun one

Spoiler

Dan

challenge_169_solution_DL.yxmd

neilgallen

Decent enough way to start the day...

challenge_169_NGA Solution.yxmd

badiualex

Spoiler

challenge_169_AB.yxmd

rinacio

challenge_169_rvi.yxmd

Tom_Pilgrem

Here's my solution

Spoiler

Challenge 169 TP.yxmd

klyuka

Spoiler

Main idea to guess "\t" delimeter for csv file.

challenge_169_solution_ayklyuka.yxmd

JReid

First Challenge!

Spoiler

I noticed most people using a sample tool to take the first value, I chose not to do this because I wanted to be able to see if there were multiples tied for the most wins.

jasperlch

Solution attached.

challenge_169_JL.yxmd

Hannah_Lissaman

My solution 🙂

Spoiler

challenge_169_Solution.yxmd

ElijahRobb

I was curious the combination of win/loss/tie, so this is how I assembled the result.

challenge 169.JPG

Challenge 169 Women's World Cup Wins.yxmd

grantski

Spoiler

Grant_challenge_169_start_file.yxmd

Asal

This is my solution !

challenge_169_start_file Hanieh.yxmd

JoeHollub

challenge_169_solution.yxmd

Ryan_K

Nice straightforward prompt to dip my toes into the weekly challenges.

Spoiler

challenge_169_complete.yxmd

CPAul

First challenge complete!

Spoiler

challenge_169_start_file_PTM.yxmd

Miner49er

Spoiler

LM1

Spoiler

challenge_169_start_file.yxmd

Spoiler

My solution:

Solution attached.

Spoiler

challenge_169_start_file.yxmd

pjdit

My solution..

Spoiler

challenge_169_PD Solution.yxmd

kelly_gilbert

A fun, quick one! This one is going to be a lot of fun to look through the different solutions, since there are so many different ways to handle it!

Spoiler

challenge_169_solution_klg.yxzp

dholle1958A

Spoiler

Hoping for a different outcome in the real event...

challenge_169_DBH.yxmd

Richard_E_Welch

Feeling happy to have completed my first challenge!

Spoiler

bdelarosa

Spoiler

Spolier

Still new to some of the functions so I did some work arounds to get to the final answer. after I submit I will check out some of your solutions to simply my workflow. nice challenge.

challenge_169_solved_bdelarosa.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703