Build an Online KPI Dashboard from Real Time Spreadsheet Data (The Easy Way)


Build an Online KPI Dashboard from Real Time Spreadsheet Data (The Easy Way)

*

Full Code From This Example:


YouTube Description:

Sign up for WayScript completely free: https://wayscript.com/auth/register?invite_key=code-with-derrick&developer=yes In this one I'll show you the fundamentals of how we can build a KPI Dashboard using Python Programming and the WayScript platform (which is completely free!) Key Performance Indicator Dashboards can be used to track tons of items. This one we'll build in this tutorial will be real time and run off a google sheet (Although you can use a variety of different sources) Huge shoutout to WayScript for supplying their product completely free to my audience! Join The Socials -- Picking Shoutouts Across YouTube, Insta, FB, and Twitter! FB - https://www.facebook.com/CodeWithDerrick/ Insta - https://www.instagram.com/codewithderrick/ Twitter - https://twitter.com/codewithderrick LinkedIn - https://www.linkedin.com/in/derricksherrill/ GitHub - https://github.com/Derrick-Sherrill 5280+ Subscribers at the time of writing! Thanks so much for all the love. You all are incredible. Thank you from the bottom of my heart for supporting me video after video. You all are incredible. Thank you. ***************************************************************** Full code from the video: The Python code: import pandas as pd import numpy as np shift = inputs['shift'] time = inputs['time'] product = inputs['product'] amount = inputs['amount'] amount = np.array(amount, dtype=np.float32) print(amount) data = {'product':product, 'amount':amount} df = pd.DataFrame(data) print(df) a_total = df.loc[df['product'] == 'A', 'amount'].sum() print(a_total) outputs['a_total'] = a_total HTML: YouTube Descriptions don't allow angled brackets :( https://github.com/Derrick-Sherrill/DerrickSherrill.com/blob/master/KPI_Dashboard.html Packages (& Versions) used in this video: Python 3 HTML CSS Bootstrap 4 NumPy 1.17 Pandas 0.25.0 ***************************************************************** Code from this tutorial and all my others can be found on my GitHub: https://github.com/Derrick-Sherrill/DerrickSherrill.com Check out my website: https://www.derricksherrill.com/ If you liked the video - please hit the like button. It means more than you know. Thanks for watching and thank you for all your support!! Always looking for suggestions on what video to make next -- leave me a comment with your project! Happy Coding!

Enjoy this content? Consider Subbing to the Youtube channel





Derrick Sherrill

By: Derrick Sherrill

Thanks for visiting my page! I'm working hard to make the best content I can for you. I love watching people learn and teaching others. Happy Coding!

Become a Patreon!