Preppin' Data

You can see our full workflow solution below and download it here! There are 3 main portions to this solution: 1. Preparing the data. 2. Calculating each of the new fields. 3. Joining all the new fields together. In order to get to the point where we begin to figure out each of the 9 new fields we need to properly filter, shape, join, and prepare the data. You can see how our flow is broken into these three groups. Preparing the Data 1. Import the game data. Use a wildcard import which includes sheets with a matching pattern of "*Results". In the import, untick everything that we do't actually need. We only need to keep: [Visitor/Neutral] (renamed to [Visiting Team]) [Home/Neutral] (renamed to [Home Team]) [Date] [PTS] (renamed to [Visitor PTS]) [PTS 1] (renamed to [Home PTS]). Removing unplayed games. 2. Remove games that haven't been played yet. As January isn't yet over, there are a lot of fixtures without any results. W...

NBA Results to NBA Standings This week’s challenge is a simple concept that’s tricky to execute: we want to take the current results from the 2019/20 NBA season (as of Jan 6th, 2020 at 11:00AM GMT+0) and produce two league tables: one for the Eastern Conference and one for the Western Conference. We’ve sourced the game results in CSV format from www.basketball-reference.com and the exact league tables we’re recreating are the ones provided by Google . The link above displays the current standings, however we’re aiming to recreate the ones seen below as they represent the standings at 11:00AM GMT+0 on Jan 6th, 2020. Eastern Conference Standings Western Conference Standings Input There is one input with 5 sheets : Team List October November December January " Team List " contains the details of the conference and division for each team, whilst the other sheets contain the results of all the games so far. January's sheet has some e...