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.
Questo esercizio fa parte del corso
Introduction to Snowflake CoCo CLI
Istruzioni dell'esercizio
- 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.
esercizio interattivo pratico
Trasforma la teoria in pratica con uno dei nostri esercizi interattivi
Inizia esercizio