Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAA solution to last week’s challenge can be found here.
For this week's challenge, let’s do a bit of data preparation using shoe inventory data!
The following dataset contains a list of shoes with an ID, colors, and sizes available.
For this challenge, you want to clean the inventory data and reorganize the list to have:
- A new ID number
- The size
- A comment stating how many colors are available, and
- Three columns for color
Keep in mind that the names of the colors are separated by the sign /.
Fun challenge!
Thanks for the delay. I finally made it to first 5.