Python in Excel! Part 9 - Basics of configurable plots! 🐍📊
Here's yet another Python in Excel video. This time I'm taking the Tour de France data and producing a simple bar plot with matplotlib.
While this kind of plot can easily be produced in Excel without Python, this simple introduction is intended to help convey some of the basic elements of producing plots with matplotlib.
In the video:
1. Use of named cells in the xl method
2. Filtering a data frame using a boolean mask
3. Parameterizing plot components by storing variables in the worksheet
I hope it's interesting. In future I will dig a bit deeper into the kinds of charts that will be more challenging without Python.
This series of short videos is in a playlist on my YT channel at flexyourdata.
Follow here, Subscribe on YT, drop a like, share, comment for more!
Have a great day!
#data #analytics #python #excel #pythoninexcel