Turn An Excel Sheet Into An Interactive Dashboard Using Python (Taipy Tutorial)

preview_player
ะŸะพะบะฐะทะฐั‚ัŒ ะพะฟะธัะฐะฝะธะต

๐——๐—˜๐—ฆ๐—–๐—ฅ๐—œ๐—ฃ๐—ง๐—œ๐—ข๐—ก
โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€
In this video, I'll show you how to start using Taipy to turn an Excel spreadsheet into a web application. We'll start from nothing and step by step, you'll learn how to set up filters, make charts, and add a theme switch to toggle between light and dark modes. This tutorial is perfect for anyone new to Taipy or those wanting to create functional, easy-to-use web apps with Python. By the end, you'll be familiar with building web applications using Taipy and how it can simplify your development process.

๐ŸŒ ๐—Ÿ๐—œ๐—ก๐—ž๐—ฆ:

โญ ๐—ง๐—œ๐— ๐—˜๐—ฆ๐—ง๐—”๐— ๐—ฃ๐—ฆ:
0:00 โ€“ Introduction
0:38 โ€“ Turn the Excel Data into a Pandas DataFrame
2:00 โ€“ Install the dependencies (Pandas, Openpyxl, Taipy)
2:38 โ€“ Creating a very simple app
5:03 โ€“ Creating the top KPIs
7:00 โ€“ Creating the filter selections
9:00 โ€“ Customize the layout
10:38 โ€“ Creating the chart DataFrames with Pandas
12:23 โ€“ Creating the Charts
13:35 โ€“ Interactions (Filter the dataset)
17:31 โ€“ Styling the app incl. toggle button
20:43 โ€“ The final app
21:07 โ€“ Deployment of the app
21:23 โ€“ Outro

๐—ง๐—ข๐—ข๐—Ÿ๐—ฆ ๐—”๐—ก๐—— ๐—ฅ๐—˜๐—ฆ๐—ข๐—จ๐—ฅ๐—–๐—˜๐—ฆ
โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€

๐—–๐—ข๐—ก๐—ก๐—˜๐—–๐—ง ๐—ช๐—œ๐—ง๐—› ๐— ๐—˜
โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€

โ˜• ๐—•๐˜‚๐˜† ๐—บ๐—ฒ ๐—ฎ ๐—ฐ๐—ผ๐—ณ๐—ณ๐—ฒ๐—ฒ?
If you want to support this channel, you can buy me a coffee here:
ะ ะตะบะพะผะตะฝะดะฐั†ะธะธ ะฟะพ ั‚ะตะผะต
ะšะพะผะผะตะฝั‚ะฐั€ะธะธ
ะะฒั‚ะพั€

*Hope you liked the Taipy tutorial. I'm here in the comment section, so if you have any questions, comments, or feedback, let me know!*
Below are the links I mentioned in the video:



*Happy Coding! Cheers, Sven* โœŒ

CodingIsFun
ะะฒั‚ะพั€

Truthly let me say you that you are one of the best in this field. Be blessed

ici
ะะฒั‚ะพั€

Thank you for your effort! I really like this ๐Ÿ‘

marcelkummer
ะะฒั‚ะพั€

Hi, bro. How's going? Whatยดs the big difference that you have realized between Taipy and Streamlit?

nilsonherbert
ะะฒั‚ะพั€

Awesome tutorial! Could the Taipy app be converted to a desktop app?

sheikhawais
ะะฒั‚ะพั€

excellent content as always,
btw is it me or streamlit is somehow easier and faster i feel it is a lot of effort here

Jriad
ะะฒั‚ะพั€

Hi
Is there a video on your channel explaining how to run AdSense on Streamlit ?Is that technically possible?
Thanks

onepiece
ะะฒั‚ะพั€

I wonder how lines 7+8 in your code actually work? (where it gets the path etc.)
What is the logic behind it and how does line 8 work?

MaxMustermann-ongd
ะะฒั‚ะพั€

how does it work with polars dataframe?

DieserWeg