This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackA solution to last week’s challenge can be found here."Women Shoe Store" by MyStockPhotos is marked with CC0 1.0
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.