In this tutorial we’ll automate your excel reports, using pure Python. We’ll use Pandas and Plotly to create the graphs, and we’ll go over Dash to build the interactive capabilities. Download the excel sheet below to follow along. I recommend you start a new .py file and write the code with me, as you’re going through the tutorial. However, if you’re encountering difficulties, feel free to download the full code below.
Video layout:
00:00 - App demo and what you will learn
01:53 - Getting started (libraries, data)
03:28 - Part 1: Data Exploration with Pandas
07:46 - Part 1: Data Visualization with Plotly
14:26 - Part 2: Interactive Graphing with Dash
23:00 - Part 2: Dash Callback
Code: https://github.com/Coding-with-Adam/Dash-by-Plotly/tree/master/Other/Excel_Dash
Excel Data: https://drive.google.com/file/d/1MBwS3h6QEGCbVWsQ2OygUQIcPRFIn3_N/view
👕 T-shirts for programmers: https://bit.ly/3ir3Gci
Subscribe : https://www.youtube.com/channel/UCqBFsuAz41sqWcFjZkqmJqQ
#python #dash #excel