Downloaded 59 times
Uploaded byValeri Karpov
MongoDB: Queries and Aggregation Framework with NBA Game Data
This document provides an overview of querying and aggregating a dataset containing NBA box scores for over 30,000 games since 1985 using MongoDB. It demonstrates various MongoDB query and aggregation operations including findOne(), find(), count(), distinct(), $elemMatch, $sort, $limit, $unwind and aggregation pipelines to analyze and extract insights from the data such as answering questions about individual player and team statistics and performance.
MongoDB: Queries and Aggregation Framework with NBA Game Data
- 1. MongoDB Queries andAggregation Valeri Karpov Kernel Tools Engineer, MongoDB www.thecodebarbarian.com github.com/vkarpov15 @code_barbarian
- 2. Introducing an AwesomeData Set •Scraped basketball-reference.com •Mad props to NPM module Cheerio •Box scores for all 31,686 NBA games since 1985 •Download: http://bit.ly/1jlgs9u via S3 •Untar and run mongorestore *
- 3. Data Set Structure •Containsfinal score •Contains box score for teams and players *
- 4. Data Set Structure- High Level •Contains _id, date •Info on winning team and losing team *
- 5. Data Set Structure- Box •Box score contains detailed stats by team *
- 6. Data Set Structure- Box •And also for individual players: *
- 7. Queries and Aggregation •MongoDBhas a rich query framework •Aggregation framework is like SQL’s group by *
- 8. Query Basics -findOne() •When was Kobe Bryant’s 81 point game? *
- 9. Query Basics -find() •Which teams have lost despite scoring more than 150 points? *
- 10. Query Basics -count() •How many games did the Lakers win in the 19992000 season? *
- 11. Query Basics -distinct() •Which teams have lost a game despite having a player make at least 10 3 pointers? *
- 12. Query Basics -$elemMatch operator •When did Michael Jordan score 60 points in a losing effort? *
- 13. Query Basics -$elemMatch operator *
- 14. Query Basics -.sort() and .limit() •What are the 5 highest point totals for a losing team? *
- 15. Query Basics -.sort() and .limit() •What are the 5 highest point totals for a losing team? *
- 16. Aggregation •Similar to SQLgroup by •Filters and transforms data in pipeline stages •Stages are chainable •Accessible via the .aggregate() function in shell *
- 17. Aggregation - LakersSeason PPG •How many points did the Lakers average in games they won in the 2008-2009 season? *
- 18. Aggregation - LakersSeason PPG •How many points did the Lakers average in games they won in the 2008-2009 season? *
- 19. Aggregation - $sortand $limit •Compute the teams with the 5 best records in the 1999-2000 season *
- 20. Aggregation - $sortand $limit *
- 21. Aggregation - $sortand $limit *
- 22. Aggregation - $unwind •Randomstatistic: player with highest scoring average in games their team lost *
- 23. Aggregation - $unwind •Randomstatistic: player with highest scoring average in games their team lost *
- 24. Aggregation - FunWith Steals •How often does a team win when they record more steals than the other team? *
- 25. Aggregation - FunWith Steals *
- 26. Aggregation - FunWith Steals *
- 27. Thanks for Listening! Slideson Twitter, @code_barbarian *