Page 1 of 1

New AI-based NBA statistical querying tool

Posted: Tue May 2, 2023 8:00 pm
by Saints14
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!

Re: New AI-based NBA statistical querying tool

Posted: Tue May 2, 2023 8:40 pm
by ijspeelman
Will have to play around with this. Thanks for sharing!

Re: New AI-based NBA statistical querying tool

Posted: Wed May 3, 2023 8:20 pm
by EvanZ
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.

Re: New AI-based NBA statistical querying tool

Posted: Wed May 3, 2023 9:32 pm
by Saints14
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

Re: New AI-based NBA statistical querying tool

Posted: Wed May 3, 2023 11:10 pm
by EvanZ
Basketball-Reference is also paid, so definitely nice to have something that is free (for now).

Re: New AI-based NBA statistical querying tool

Posted: Fri May 5, 2023 12:52 am
by pdevos
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/

Re: New AI-based NBA statistical querying tool

Posted: Fri Jun 9, 2023 8:08 pm
by Saints14

Re: New AI-based NBA statistical querying tool

Posted: Fri Jun 16, 2023 5:03 pm
by toooskies
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.

Re: New AI-based NBA statistical querying tool

Posted: Fri Jun 16, 2023 5:04 pm
by EvanZ
Yeah it definitely should not be used this way lol

Re: New AI-based NBA statistical querying tool

Posted: Fri Jun 16, 2023 9:12 pm
by Saints14
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.

Re: New AI-based NBA statistical querying tool

Posted: Thu Jul 20, 2023 10:29 pm
by LesGrossman
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.

Re: New AI-based NBA statistical querying tool

Posted: Fri Jul 21, 2023 12:26 pm
by Saints14
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

Re: New AI-based NBA statistical querying tool

Posted: Sun Sep 24, 2023 11:08 pm
by LesGrossman
They seem to have gone offline now. Too bad, they had interseting features