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.
SUBMIT YOUR IDEA
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
Now the question is what percent of people are working in the specialized field of study? I'm definitely not.
