Challenge #216: The Big Five

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

The Big Five personality traits, also known as the five-factor model (FFM), is a taxonomy, or grouping, for personality traits.

The dataset contains responses from users who rated themselves on a scale of 1 to 5 for 50 questions in the 5 personality factors. Some questions are weighted positively in the final score, some are weighted negatively.

Your job is to give each user a score in each of the 5 factors (Sum of all points per factor). Additionally, each users' final score should be adjusted as follows per the scoring instructions on https://openpsychometrics.org/

Extraversion: 20 + Score
Agreeableness: 14 + Score
Conscientiousness: 14 + Score
Neuroticism: 38 - Score
Openness: 8 + Score

challenge_216_start_file.yxzp

challenge_216_solution.yxzp

Join

Preparation

Advanced

Data Analysis

Intermediate

Transform

Accepted answers

All comments

johnemery

Interesting challenge. Somewhat tricky to parse the instructions properly, but I got there in the end.

Spoiler

View my video solution here:

Spoiler

Challenge 216 Solution jemery v2.yxmd

Aaron_Harter

Fun parsing and mapping challenge!

Spoiler

challenge_216_solution_AB Data Consulting_Aaron.yxzp

Blake

That was an interesting challenge.

Spoiler

Spoiler

EDIT : 11:30 CST added video link

challenge_216_BH.yxzp

dsmdavid

Confused at the beginning about those _E fields

Spoiler

david_216.yxzp

Kenda

Spoiler

challenge_216_start_file.yxmd

Victor_Mendes

Fun challenge, but just took too long to understand what was supposed to be done...

Spoiler

challenge_216_Victor_Mendes.yxzp

Jean-Balteryx

Here is my solution !

challenge_216_workflow.yxzp

LorenzoDB_dup_193

Hi this is my answer

Spoiler

And this is my workflow

Challenge #216 - LDB Scai Financeyxmd.yxmd

Challenge #216 - LDB Scai Financeyxmd.yxzp

balajilolla

Spoiler

Solution Attached

challenge_216_start_file.yxmd

ggruccio

I hadn't heard of the test before. Looks like we can take it online!

Spoiler

challenge_216_gg_finish.yxzp

filipe_quintieri

Hi,

this is my answer

Spoiler

challenge_216_start_file_Filipe_Quintieri.yxzp

abrouwer

My solution is attached

challenge_216_solution_file - AJB.yxmd

mestevez1

Took a while to figure out there was as a lot of junk data to dismiss

challenge_216_mestevez.yxmd

mbogusz

Spoiler

challenge_216_solution_mbogusz (The Big Five).yxzp

DaisukeTsuchiya

This is Interesting challenge.

Spoiler

challenge_216_start_file_DT.yxzp

randreag

Nice challenge!

Spoiler

challenge_216_solved.yxmd

Leo_Almeida

Debuting at Alteryx and Alteryx Community with a challenge.

Here the solution hide by containers to follow logical steps

Spoiler

And now with nothing hidden:

Spoiler

challenge_216_solution_Leo_Almeida.yxmd

Sudha8990AI

Good Exercise! Used most of the Data Preparation Tools.

216_Solution.yxmd

dkoenawan004

Haven't been doing this for a while, good challenge to jump back on.

Spoiler

challenge_216_dkk_solution.yxmd

estherb47

Once you get past the data messiness, it's a fun blending and summarizing challenge

Spoiler

Cheers!

Esther

challenge_216_EHB_completed.yxzp

jasperlch

Spoiler

challenge_216_JL.yxmd

Haftom

Educational Challenge.

challenge_216_start_file.yxmd

arathirajeev

The extra columns got me a bit confused in the beginning - but otherwise a fun challenge to begin the Weekly Challenges with!

challenge_216_solution_file.yxzp

RolandSchubert

Interesting challenge.

Spoiler

challenge_216_solution_rsc.yxmd

JeremyGonzva

Got there

challenge_216_start_file.yxmd

Ladarthure

My solution!

challenge_216_start_file.yxmd

patrick_digan

Spoiler

challenge_216_start_file.yxmd

pasccout

Here is my solution

Spoiler

Why does Neuroticism need to be put in absolute value before adding the adder???? The score matches by doing this but...

challenge_216_my_solution.yxmd

aletoto

This is my solution

challenge_216_start_file.yxmd

AcevedoYo

I enjoyed this challenge. I recently learned how to use the Tile Tool so I have been looking for excuses to use it although I'm not sure that this particular case really calls for it. Still - I got to the solution eventually! Looking forward to seeing a more efficient solution.

EDIT: So after taking a peek at some of the other solutions users have posted, the biggest inefficiency with my workflow is I should have used a Summary Tool instead of a Running Total tool. Doh!