Over the campfire, you and a friend get into a debate about which college in Georgia has had the best MLB success. You need clear visualizations that depict the performance of Geogia college players compared to your favorite college's players. The SeanLahman.com has a comprehensive set of baseball data. We are going to use the 2019 SQL Lite version of the data.
- Complete the data joing and munging in R, Python, and SQL.
- Complete the visualizations in R and Python.
- Establish 2-3 metrics/visualizations that can settle the debate and provide a sketch of what the charts may look like.
- Diagram the data you will need from the Lahman database.
- Polish two charts (annotations, titles, labels, etc.) and provide a detailed paragraph explaining the highlight of your chart.
- Write 1-2 paragraphs comparing R, Python, and SQL for relational data.