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

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
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:

[CodingIsFun]

*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* ✌

[ici]

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

[marcelkummer]

Thank you for your effort! I really like this 👍

[nilsonherbert]

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

[sheikhawais]

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

[Jriad]

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

[onepiece]

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

[MaxMustermann-ongd]

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?

[DieserWeg]

how does it work with polars dataframe?