New AI-based NBA statistical querying tool

Moderator: Doctor MJ

Saints14
Assistant Coach
Posts: 3,776
And1: 5,461
Joined: Jul 19, 2013
 

New AI-based NBA statistical querying tool 

Post#1 » by Saints14 » Tue May 2, 2023 8:00 pm

Just a bit of promotion for a (free) tool RealGMers might find interesting. With Statmuse going paid this might be good timing...

Basically, with Definitive Notebooks you can ask questions about any NBA data related to player boxscores, team boxscores, play-by-play, or aggregated/advanced stats, and it'll run a query for you under the hood. For example, this is much quicker and easier than trying to run a query on basketball-reference:

Image
https://definitive.io/notebooks/NBA-Players-Meeting-Criteria-fdb41672-c421-4016-9d06-880de1f6eb4f


There's data that's REALLY hard to find otherwise, like:

- Which players have James Harden assisted the most in his career? (https://definitive.io/notebooks/James-Harden's-Top-Assists-7150c52e-b984-4502-8dd2-cd8130ebf972#1)
Spoiler:
Image

- Which players have had the most STOCKS in a single postseason game? (https://definitive.io/notebooks/Players-with-Most-Stocks-in-a-Single-Postseason-Game-18406c8f-4051-4a1e-a14a-311c3bf4ee22)
Spoiler:
Image


The combos are pretty endless, the stats heads on here would really enjoy it!
User avatar
ijspeelman
Forum Mod - Cavs
Forum Mod - Cavs
Posts: 1,720
And1: 856
Joined: Feb 17, 2022
Contact:
   

Re: New AI-based NBA statistical querying tool 

Post#2 » by ijspeelman » Tue May 2, 2023 8:40 pm

Will have to play around with this. Thanks for sharing!
User avatar
EvanZ
RealGM
Posts: 12,731
And1: 3,220
Joined: Apr 06, 2011

Re: New AI-based NBA statistical querying tool 

Post#3 » by EvanZ » Wed May 3, 2023 8:20 pm

Interesting that ChatGPT doesn't get it at all:
Which players have had the most STOCKS (steals + blocks) in a single postseason game?

The NBA began tracking steals and blocks as separate statistics in the 1973-74 season. Since then, there have been several players who have recorded the most stocks (steals + blocks) in a single postseason game. Here are the top five:

Hakeem Olajuwon - 10 stocks (6 steals, 4 blocks) on May 5, 1990, against the Seattle SuperSonics.
David Robinson - 9 stocks (6 blocks, 3 steals) on May 27, 1995, against the Houston Rockets.
Julius Erving - 8 stocks (5 steals, 3 blocks) on May 12, 1979, against the Boston Celtics.
Charles Barkley - 8 stocks (6 steals, 2 blocks) on May 11, 1993, against the Seattle SuperSonics.
Michael Jordan - 8 stocks (6 steals, 2 blocks) on June 2, 1991, against the Los Angeles Lakers.
It's worth noting that steals and blocks were not officially recorded until the 1973-74 season, so it's possible that players before this era may have had higher stocks in a game, but we don't have official statistics to verify it.
I was right about 3 point shooting. I expect to be right about Tacko Fall. Some coach will figure out how to use Tacko Fall. This movement towards undersized centers will sweep ng back. Back to the basket scorers will return to the NBA.
Saints14
Assistant Coach
Posts: 3,776
And1: 5,461
Joined: Jul 19, 2013
 

Re: New AI-based NBA statistical querying tool 

Post#4 » by Saints14 » Wed May 3, 2023 9:32 pm

EvanZ wrote:Interesting that ChatGPT doesn't get it at all:
Which players have had the most STOCKS (steals + blocks) in a single postseason game?

The NBA began tracking steals and blocks as separate statistics in the 1973-74 season. Since then, there have been several players who have recorded the most stocks (steals + blocks) in a single postseason game. Here are the top five:

Hakeem Olajuwon - 10 stocks (6 steals, 4 blocks) on May 5, 1990, against the Seattle SuperSonics.
David Robinson - 9 stocks (6 blocks, 3 steals) on May 27, 1995, against the Houston Rockets.
Julius Erving - 8 stocks (5 steals, 3 blocks) on May 12, 1979, against the Boston Celtics.
Charles Barkley - 8 stocks (6 steals, 2 blocks) on May 11, 1993, against the Seattle SuperSonics.
Michael Jordan - 8 stocks (6 steals, 2 blocks) on June 2, 1991, against the Los Angeles Lakers.
It's worth noting that steals and blocks were not officially recorded until the 1973-74 season, so it's possible that players before this era may have had higher stocks in a game, but we don't have official statistics to verify it.


ChatGPT is much more useful attached to a database :D
User avatar
EvanZ
RealGM
Posts: 12,731
And1: 3,220
Joined: Apr 06, 2011

Re: New AI-based NBA statistical querying tool 

Post#5 » by EvanZ » Wed May 3, 2023 11:10 pm

Basketball-Reference is also paid, so definitely nice to have something that is free (for now).
I was right about 3 point shooting. I expect to be right about Tacko Fall. Some coach will figure out how to use Tacko Fall. This movement towards undersized centers will sweep ng back. Back to the basket scorers will return to the NBA.
pdevos
Ballboy
Posts: 48
And1: 28
Joined: Jan 16, 2017

Re: New AI-based NBA statistical querying tool 

Post#6 » by pdevos » Fri May 5, 2023 12:52 am

That's pretty cool. They have a ton of datasets. It's weird, seems like they've just scraped a bunch of data sets and right now, just curating them without a stated business plan or intent.

Described as a "web3" company to basically do user engagement analytics for Web3 platforms.

"Definitive is the end-to-end insights and user acquisition platform for Web3 teams.
Our easy-to-use platform enables Web3 teams to understand user behavior, drive growth, and increase retention."

https://www.linkedin.com/company/definitiveio/about/
Saints14
Assistant Coach
Posts: 3,776
And1: 5,461
Joined: Jul 19, 2013
 

Re: New AI-based NBA statistical querying tool 

Post#7 » by Saints14 » Fri Jun 9, 2023 8:08 pm

toooskies
Analyst
Posts: 3,630
And1: 1,650
Joined: Jul 18, 2013
     

Re: New AI-based NBA statistical querying tool 

Post#8 » by toooskies » Fri Jun 16, 2023 5:03 pm

Saints14 wrote:
EvanZ wrote:Interesting that ChatGPT doesn't get it at all:
Which players have had the most STOCKS (steals + blocks) in a single postseason game?

The NBA began tracking steals and blocks as separate statistics in the 1973-74 season. Since then, there have been several players who have recorded the most stocks (steals + blocks) in a single postseason game. Here are the top five:

Hakeem Olajuwon - 10 stocks (6 steals, 4 blocks) on May 5, 1990, against the Seattle SuperSonics.
David Robinson - 9 stocks (6 blocks, 3 steals) on May 27, 1995, against the Houston Rockets.
Julius Erving - 8 stocks (5 steals, 3 blocks) on May 12, 1979, against the Boston Celtics.
Charles Barkley - 8 stocks (6 steals, 2 blocks) on May 11, 1993, against the Seattle SuperSonics.
Michael Jordan - 8 stocks (6 steals, 2 blocks) on June 2, 1991, against the Los Angeles Lakers.
It's worth noting that steals and blocks were not officially recorded until the 1973-74 season, so it's possible that players before this era may have had higher stocks in a game, but we don't have official statistics to verify it.


ChatGPT is much more useful attached to a database :D

Fun fact: Hakeem Olajuwon didn't play a game on May 5, 1990. Nor did he play the Sonics in 1990, although they faced off multiple times through the years, and a few times on May 5th. In none of those May 5th games did he have the stats listed.

Beware of using ChatGPT as a factual reference.
User avatar
EvanZ
RealGM
Posts: 12,731
And1: 3,220
Joined: Apr 06, 2011

Re: New AI-based NBA statistical querying tool 

Post#9 » by EvanZ » Fri Jun 16, 2023 5:04 pm

Yeah it definitely should not be used this way lol
I was right about 3 point shooting. I expect to be right about Tacko Fall. Some coach will figure out how to use Tacko Fall. This movement towards undersized centers will sweep ng back. Back to the basket scorers will return to the NBA.
Saints14
Assistant Coach
Posts: 3,776
And1: 5,461
Joined: Jul 19, 2013
 

Re: New AI-based NBA statistical querying tool 

Post#10 » by Saints14 » Fri Jun 16, 2023 9:12 pm

toooskies wrote:
Saints14 wrote:
EvanZ wrote:Interesting that ChatGPT doesn't get it at all:



ChatGPT is much more useful attached to a database :D

Fun fact: Hakeem Olajuwon didn't play a game on May 5, 1990. Nor did he play the Sonics in 1990, although they faced off multiple times through the years, and a few times on May 5th. In none of those May 5th games did he have the stats listed.

Beware of using ChatGPT as a factual reference.


Totally - the idea behind Definitive is to essentially hook ChatGPT up to a database so that it can run queries against actual data for those kinds of questions rather than just make stuff up. LLMs are trained for next word prediction, so regular ChatGPT just hallucinates facts it doesn't know but here the "next word prediction" is actually code running against a DB.

Here's a pretty cool example using the new chatbot feature (https://chat.lab.definitive.io/). You can ask it "Using the nba dataset, gather all of the x,y coordinates of three pointers that steph curry shot this season. Plot on a chart superimposed over an image of a basketball court", and it spits this out:

Image


Or you can tell it: "Write an ESPN-style article summarizing the 2023 NBA finals between DEN and MIA, including per-game stats by top players"...and get the following:


In the 2023 NBA finals, the Denver Nuggets (DEN) and the Miami Heat (MIA) faced off in a thrilling series. The series was a showcase of skill, strategy, and athleticism, with both teams giving their all on the court.

The series consisted of 5 games, with the DEN emerging as the champions.

Leading the pack was Nikola Jokic of the Denver Nuggets, who played in all 5 games, averaging 30.2 points, 14.0 rebounds, 7.2 assists, 0.8 steals, 1.4 blocks, and 3.4 turnovers per game. Close behind was Bam Adebayo of the Miami Heat, who also played in all 5 games, averaging 21.8 points, 12.4 rebounds, 3.2 assists, 0.4 steals, 0.8 blocks, and 2.4 turnovers per game.
LesGrossman
Head Coach
Posts: 6,158
And1: 4,114
Joined: Mar 24, 2014

Re: New AI-based NBA statistical querying tool 

Post#11 » by LesGrossman » Thu Jul 20, 2023 10:29 pm

Saints14 wrote:Just a bit of promotion for a (free) tool RealGMers might find interesting. With Statmuse going paid this might be good timing...

Basically, with Definitive Notebooks you can ask questions about any NBA data related to player boxscores, team boxscores, play-by-play, or aggregated/advanced stats, and it'll run a query for you under the hood. For example, this is much quicker and easier than trying to run a query on basketball-reference:

Image
https://definitive.io/notebooks/NBA-Players-Meeting-Criteria-fdb41672-c421-4016-9d06-880de1f6eb4f


There's data that's REALLY hard to find otherwise, like:

- Which players have James Harden assisted the most in his career? (https://definitive.io/notebooks/James-Harden's-Top-Assists-7150c52e-b984-4502-8dd2-cd8130ebf972#1)
Spoiler:
Image

- Which players have had the most STOCKS in a single postseason game? (https://definitive.io/notebooks/Players-with-Most-Stocks-in-a-Single-Postseason-Game-18406c8f-4051-4a1e-a14a-311c3bf4ee22)
Spoiler:
Image


The combos are pretty endless, the stats heads on here would really enjoy it!

Is there a way to get offline access to the entire data set? I need to run it through my tools and get persistent results. I couldnt find a way other than downloading them in chunks of 20000 rows which is terrible.
Pray for Israel
Peace in Jerusalem

Fan of the game of Basketball, no matter the team, league or players. Opposed to all sorts of person cult and show/entertainment/marketing over substance.
Saints14
Assistant Coach
Posts: 3,776
And1: 5,461
Joined: Jul 19, 2013
 

Re: New AI-based NBA statistical querying tool 

Post#12 » by Saints14 » Fri Jul 21, 2023 12:26 pm

LesGrossman wrote:
Saints14 wrote:Just a bit of promotion for a (free) tool RealGMers might find interesting. With Statmuse going paid this might be good timing...

Basically, with Definitive Notebooks you can ask questions about any NBA data related to player boxscores, team boxscores, play-by-play, or aggregated/advanced stats, and it'll run a query for you under the hood. For example, this is much quicker and easier than trying to run a query on basketball-reference:

Image
https://definitive.io/notebooks/NBA-Players-Meeting-Criteria-fdb41672-c421-4016-9d06-880de1f6eb4f


There's data that's REALLY hard to find otherwise, like:

- Which players have James Harden assisted the most in his career? (https://definitive.io/notebooks/James-Harden's-Top-Assists-7150c52e-b984-4502-8dd2-cd8130ebf972#1)
Spoiler:
Image

- Which players have had the most STOCKS in a single postseason game? (https://definitive.io/notebooks/Players-with-Most-Stocks-in-a-Single-Postseason-Game-18406c8f-4051-4a1e-a14a-311c3bf4ee22)
Spoiler:
Image


The combos are pretty endless, the stats heads on here would really enjoy it!

Is there a way to get offline access to the entire data set? I need to run it through my tools and get persistent results. I couldnt find a way other than downloading them in chunks of 20000 rows which is terrible.


I'll DM you
LesGrossman
Head Coach
Posts: 6,158
And1: 4,114
Joined: Mar 24, 2014

Re: New AI-based NBA statistical querying tool 

Post#13 » by LesGrossman » Sun Sep 24, 2023 11:08 pm

They seem to have gone offline now. Too bad, they had interseting features
Pray for Israel
Peace in Jerusalem

Fan of the game of Basketball, no matter the team, league or players. Opposed to all sorts of person cult and show/entertainment/marketing over substance.

Return to Statistical Analysis