Excel - Create an NBA Shot Chart Using Python & Copilot | LeBron James - 16 Playoffs - Episode 2657

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Sep 25, 2024.
Microsoft Excel Tutorial: Create an NBA Shot Chart Using Python & Copilot | LeBron James - 16 Playoffs

In this video, I’m excited to show you a demo I saw from Microsoft that's seriously cool! We’re diving into how to use the new Python integration with Excel Copilot to create an NBA basketball shot chart. With data sensors installed in every NBA arena since 2013, we now have detailed info on every shot, including the exact X and Y coordinates and whether the shot was made or missed. This data opens up a whole new world of possibilities for sports analytics in Excel.

For this example, I’ve extracted LeBron James' shot data from the 2016 playoffs with the Cleveland Cavaliers – the Cavs' only championship season during my lifetime! With Excel Copilot’s Advanced Analysis feature (currently in beta, so you’ll need to be on Insiders Fast and lucky to access it), I’ll walk you through the process of transforming that data into an eye-popping NBA shot chart.

The magic happens when Copilot takes our data and creates a new data frame. With a simple command – "create an NBA shot chart from this data" – we get a stunning visual of LeBron’s shots from that playoff run. Green dots represent made shots, while red dots are the misses. What’s even more amazing is how Python is used to generate a detailed basketball court layout, plotting the X and Y shot locations right on the chart.

While this feature probably isn’t something you’ll convince your boss to get just for basketball charts (unless you work for an NBA team!), it’s a great demonstration of the powerful new analysis options we have in Excel now with Python. Excel Copilot + Python opens up incredible possibilities for complex data analysis.

Thanks for watching, and I hope you enjoyed this sneak peek into how Copilot and Python can transform data visualization in Excel. Be sure to subscribe, and I’ll see you next time for another netcast from MrExcel!

Buy Bill Jelen's latest Excel book: MrExcel 2024 Igniting Excel

Table of Contents
(0:00) Basketball Shot Chart in Excel
(0:11) NBA Shot Location Data
(0:25) LeBron James 2016 Playoffs Data
(0:37) Start Copilot with Advanced Analysis
(0:52) Prompt for NBA Shot Chart
(1:13) Explaining the Shot Chart
(1:23) Python Code to plot basketball court
(1:38) Will your manager pay for this?
(2:03) Closing Theme Shot Charts in Excel

1. Excel Copilot Python NBA Shot Chart
2. Create basketball shot chart in Excel
3. LeBron James 2016 playoffs data in Excel
4. Python advanced analysis Excel tutorial
5. Excel Copilot beta shot chart demo
6. NBA shot data visualization in Excel
7. How to use Python in Excel Copilot
8. Excel sports analytics with Copilot
9. Plot NBA shots in Excel with Python
10. LeBron James playoff stats Excel chart
maxresdefault.jpg


Transcript of the video:
I saw Microsoft do this demo is so cool.
We're going to use Copilot.  The new Python and Copilot to create  a basketball shot chart in Excel.  The NBA ever since 2013 has  sensors in every single arena.  They know the exact location, X  and Y of the ball at all times.  These amazing databases of  every shot taken in a game.  Where it was taken.
Whether it was made or missed.  So here I've extracted LeBron James 2016  playoffs with the Cleveland Cavaliers.  The Cavs only championship  season during my lifetime.  So we have this data.  Come over here to Co-pilot and we're  going to use Advanced Analysis.  Now, all of these are now in General  Availability except for Advanced Analysis.  This is still in beta.
So you got to be on Insiders Fast.  You got to be on the Beta channel  and be lucky enough to have it.  So we choose Advanced Analysis.
We'll start advanced analysis.  And they basically take my data and create  it in a new data frame here on a new sheet.  And then we just type create a  NBA shot chart from this data.  Okay, there we are.
This is a chart unlike any   other chart I've ever seen in Excel.
The green dots are the made shots.  Red dots are the missed shots.
This is pretty wild.  To take a look at this code that they used here.
They're actually plotting the basketball court   using these circles and rectangles and  everything to create the basketball court.  And then plotting the X and  Y locations on the chart.  I don't think you're going to be able to  get your boss to pay for Copilot with Python   just so you can create basketball charts.
Unless you work for one of the NBA teams.  But I thought this was a really  cool example and a cool chart.  Having Python in Copilot really just opens up  the amount of different analysis that we can do.  Well, hey, I want to thank you for stopping by.
We'll see you next time for   another net cast from MrExcel.
[ Singing ] "Boss, I know it’s kinda strange.  Basketball ain't in my work range.
But with Python in Excel, hear me out.  I can make shot charts, without a doubt!" “Python in Excel, just give it a chance.  I’ll turn numbers into magic, make the data dance!
It’s not just sports, it’s skills I’ll gain.  Invest in the tools, we’ll see big change!” "Think of all the graphs and tricks I'll know.  It’s more than just hoops, I’ll watch data grow.
Pivot tables?  I’ll go beyond the norm.
With Python in Excel, I'll truly transform!"  “Python in Excel, just give it a chance.
I’ll turn numbers into magic, make the data dance!  It’s not just sports, it’s skills I’ll gain.
Invest in the tools, we’ll see big change!”  "Think of all the graphs and tricks I'll know.
It’s more than just hoops, I’ll watch data grow.  Pivot tables?
I’ll go beyond the norm.  With Python in Excel, I'll truly transform!" “Python in Excel, just give it a chance.  I’ll turn numbers into magic, make the data dance!  It’s not just sports, it’s skills I’ll gain.
Invest in the tools, we’ll see big change!”  "From sales to budgets, I’ll save the day.
And maybe a shot chart just to play!"  “So pay for Python, it’ll be real fun.
I’ll show you it’s worth it when the work’s done!"
 

Forum statistics

Threads
1,226,453
Messages
6,191,136
Members
453,642
Latest member
jefals

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top