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
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](/board/proxy.php?image=https%3A%2F%2Fimg.youtube.com%2Fvi%2FHvH7t6ejCFs%2Fmaxresdefault.jpg&hash=8083b8ef0caaa9c97f0ec67cdd572172)
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!"
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!"