Interactive Python Dashboards in Excel
Create interactive Excel dashboards with Python, Pandas and PyXLL.
Download the code: https://github.com/pyxll/pyxll-exampl...
This video demonstrates how Python code can be used in Excel to interactively process and analyse large data sets, using the US Cities data set as an example.
The data is loaded into Python using Pandas, filtered and aggregated interactively using inputs in Excel, before displaying the aggregated results in Excel.