A 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 /.