Automate Google Sheet Calculations with Python, Amazon Alexa, & WayScript


Automate Google Sheet Calculations with Python, Amazon Alexa, & WayScript

*

Full Code From This Example:


YouTube Description:

Link for WayScript -- https://wayscript.com/auth/register?invite_key=code-with-derrick&developer=yes In this video we'll cover how to get Amazon Alexa to do your python calculations for you with voice control. We'll create a workflow that starts with Alexa, uses python for calculations, and returns us alexa speech text as a result. Here's the link to the spreadsheet if you want to play with it yourself - https://drive.google.com/open?id=1maveiEDF_GQPmR3iQuSD_fxcSPoyh0_1axTeGSUm-eo Thanks so much for all the continued support - I wouldn't be getting the chance to talk to start ups if it wasn't for you guys. 4,300 subscribers at the time of typing this. You guys are incredible. Thank you. ***************************************************************** Full code from the video: import pandas as pd product = inputs['Product'] amount = inputs['Amount'] amount = [int(a) for a in amount] data = {'product':product, 'amount':amount} df = pd.DataFrame(data) a_total = df.loc[df['product']=='A']['amount'].sum() print(a_total) outputs['a_total'] = a_total https://github.com/Derrick-Sherrill/DerrickSherrill.com/blob/master/WayScriptGoogleSheets.py ***************************************************************** 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!