Create a Python Dashboard from Multiple Excel Sheets - Plotly Dash

If you're using the same excel sheets over and over again, learn to create a python Dash app that would visualize the data with Plotly graphs.

The Code:

Plotly Forum:

View my book - The Book of Dash:

Video layout:
00:00 - Intro & What you will Learn
02:56 - Layout and creating tables
07:38 - Pattern matching callbacks
08:54 - Build the graphs: callback decorator
12:00 - Build the graphs
16:13 - Final remarks & support your learning

************************************************************************
👉 Your support keeps Charming Data running, which is proudly a 100% member-supported educational channel:

[CharmingData]

The data (excel sheets) used in this video is from:

[moulikunapareddy]

excellent content. No one else is making content on this

[Dave-fvtt]

Can you show how to use dash and Stripe API to accept payment? Another topic is how to add user registration, login, logout to a dash app. Thanks!

[xiangyuzhang]

That's quite helpful but how could I filter through between, like I would like to filter Temperature between 1 to 10 degrees?

[DepressedMonkeyGaming]

Simply excellent tutorial 🔥 really helpful

[artisthadassah]

Thanks for the video. I got this error though "ValueError: signal only works in main thread of the main interpreter
Traceback:"

[nikhilramabadran]

Hello, I'm having an issue running my dash code, which is syntactically correct, on Jupyter Notebook, whenever I set debug=True within the parentheses of the app.run() statement. Can you please let me know why that could be? If you want to have a look at the code, I can send it to you where you wish. Although the doubt could be from an unrelated topic, I'm posting it here as this is your most recent video.

[geetikavadali]

Thanks a lot for these videos on dash, I just came to know about this library for a hackathon and we have a little doubt. I have a large dataset that pans over 365 days of a year and across several years too. Every day has a different excel file, so essentially we have 365*4 excel files each with 334K data points. And we want visualisations for each day in the form of a slider moving across the timeline to show the slow traffic change (its a navigation based data). Can you help me in understanding how i can mount all that data and incorporate that into a web application that shows this timeline?

[adrimoreno]

Hi, I love your tutorials, all life and time-saving!
Do you have any suggestions on deploying the Dash apps on AWS? I haven´t found any "easy" way to do it :S
Thanks for your cool work :D