Script the refund check
The support team has just uploaded this month's returns export, returns.csv, to the home folder of your session. It's messy, and a new one arrives every month, so instead of working out each product's refund rate by hand, have CoCo write a Python script that does it and that you can rerun.
Это упражнение является частью курса
Introduction to Snowflake CoCo CLI
Инструкции к упражнению
- Start a CoCo session and paste this prompt:
returns.csv is the support team's export of returned items. Using Python, clean it up, total the refunds for each product, compare each total with that product's revenue from the orders, and save the result as a new table SHOP.REFUND_RATE. Save the script as refunds.py and run it. - Approve CoCo's steps until it reports the refund rate for each product.
- Close the session, then rerun the script yourself with
python3.
Практическое интерактивное упражнение
Превратите теорию в практику с помощью одного из наших интерактивных упражнений
Начать упражнение