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

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!