3 ms·
Ask HN: How would you solve this one-off data processing problem?
My mom asked me how many World Series championships have been won by each team since 1970. Since I didn't have this data readily available, I had to improvise.
Curious to see how others would solve this problem. For instance, where did you find the data, how did you fetch it and then transform it?
- cglong 4y agoI ended up using Wikipedia and Excel as a quick-and-dirty approach. Unfortunately, the Wikipedia table has a lot of extraneous annotations, so after copying it into my spreadsheet, I had to do some filtering and manual data munging to get it into a usable format. I then created a PivotTable to do the calculations.
- warpspin 4y agoWhen data like that is available in text format, I often use a simple "sort | uniq -c | sort -g" for that kind of problem.
- xrosbeh 4y agoA one line SDQL query in the online sportsdatabase.
- cglong 4y agoOh wow, I've never heard of this resource! Thanks :D
- pestatije 4y agoI'd go the Wikipedia way...50 data points doesn't look too many, so just a list would do it, maybe a spreadsheet...a few sums, voila...i wouldn't call it a data processing problem though