Coursework files for CS257
Created on: Friday, March 31st, 2023.
Project team: J
Members: Samuel Kim, Taylor Kang, John Win
- This is the original dataset scraped from the web by Sam at the beginning of the project. The dataset is already perfect so no changes were made. However, something that can be improved is normalization for the dataset. There is repetition in the team name since a team has different parameteres for each game season.
- The first query filters out data for the team Los Angeles Angels for all of their seasons. This will help the audience figure out their performance through the years. The second query finds the average total payroll of the Los Angeles Angels through the years. This will be useful in comparing the team's average payroll to a different team's. The second query finds the average win percentage of the Los Angeles Angels through the years. This will be useful in comparing the team's average win percentage to a different team's.