Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI used the RegEx tool instead of the Text-to-Columns tool so I could specify names and data types for the output.
Same here. The regex tool was a easier option.
Solution
I am new, taking the Designer class that recently opened, and tried to get along with the tools that we learned so far.
So I created my solution, only after that I also checked the one provided. My solution takes 8.9 s, the one provided 20.7 s. I am probably breaking some official/unofficial rules of the data science game, and I am aware it works because the data set is pretty much perfect. I can see how, for example, the RegEx tool is more elegant and would also work for more unruly datasets, but again, it hasn't yet been discussed in class. I hope the way I did it is legit.