Turn An Excel Sheet Into An Interactive Dashboard Using Python (Taipy Tutorial)
19.8 هزار بار بازدید -
6 ماه پیش
-
👉 Explore All My Excel
👉 Explore All My Excel Solutions: pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
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.
🌍 𝗟𝗜𝗡𝗞𝗦:
► Live Website: taipy.salesdashboard.pythonandvba.com/
► Source Code: github.com/Sven-Bo/taipy-sales-dashboard
► MyToolBelt Excel Add-in: pythonandvba.com/mytoolbelt
► Taipy Documentation: docs.taipy.io/en/latest/
► Pandas Tutorial: • Become a Pandas Pro: Learn Data Analy...
⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
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
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.com/mytoolbelt
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): pythonandvba.com/cuteplots
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.com/emojify
📑 Excel Templates: pythonandvba.com/go/excel-templates
🎓 My Courses: pythonandvba.com/go/courses
📚 Books, Tools, and More: pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: www.linkedin.com/in/sven-bosau/
📸 Instagram: instagram.com/codingisfun_official
💻 GitHub: github.com/Sven-Bo
💬 Discord: pythonandvba.com/discord
📬 Contact: pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:
▶ pythonandvba.com/coffee-donation
6 ماه پیش
در تاریخ 1403/01/26 منتشر شده
است.
19,846
بـار بازدید شده