Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
alteryx Community

# 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.

## Challenge #357: College Majors in High Demand

Alteryx

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

To solve this week's challenge, use Designer Cloud or Designer Desktop.

This challenge comes to us from @randall_king

Haven't heard about Designer Cloud yet? Watch a demo.

In this weekly challenge, you need to clean and format data; sort data; and create a calculated field.

Your high school-aged child is planning on attending college after graduation. They do not know what they should choose as a major, so being the great parent you are, you want to steer them in the right direction.

Based on this dataset, determine which majors have an employment rate equal to or higher than 80%. If you suggest these areas of study to your child, you may have the best chance of making sure they don't move back into your house after college graduation!

For this challenge you should:

1. Split the data into columns on the comma delimiter.
2. Convert the first row of data into a header.
3. Assign appropriate data types to numeric columns.
4. Create a column that calculates the percent (rounded up to the nearest whole number) of students who are employed. Use the Employed and Total columns for your calculation.
5. Sort the data in descending order.
6. Filter the majors with an employment percentage equal to or higher than 80%.

Data Source: www.kaggle.com/datasets/tunguz/college-majors

11 - Bolide
Spoiler

13 - Pulsar
Spoiler

8 - Asteroid
Spoiler
Solution Attached

9 - Comet
Spoiler
Straightforward

Alteryx Alumni (Retired)

Completed using Designer Cloud (Trifacta Experience)! Recipe included.

Spoiler

12 - Quasar

I missed the part of the direction that you round 'up'.   That cost a few min getting it to equal 35 results.

Spoiler

11 - Bolide

Now the question is what percent of people are working in the specialized field of study? I'm definitely not.

Spoiler

8 - Asteroid
Spoiler

20 - Arcturus
Spoiler