Weekly Challenge
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit Feedback
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
I missed the part of the direction that you round 'up'. That cost a few min getting it to equal 35 results.
Now the question is what percent of people are working in the specialized field of study? I'm definitely not.
