Week 18 - Snowpark & Python

Snowpark & Python

14 Oct

Written By

Snowflake guest challenge!

For this week's challenge, we're very happy to announce a guest challenge designed and written by Snowflake's own Daniel Myers! We've given him carte blanche to pick up any feature or subject that he could think of and, to be honest, we're very happy he picked this one!
Don't be put off thinking 'but I've never done data science before', use this as an opportunity to get that experience in!
Not sure where to begin? Check the resources underneath the Help / Hints / Tips section

Hey folks!

Frost Fridays have been incredibly awesome!

I've put together a proposed challenge that uses snowpark and data from our data marketplace to predict inflation for 2024 in the US!

The Challenge

Inflation is rising! Today's challenge is to predict future inflation using actual economic data from the Snowflake Data Marketplace. Specifically, you will train a linear regression model inside snowflake that predicts the personal consumption expenditures (PCE) for any given future year! To answer this challenge, provide the PCE for the year 2024.

The Data

The data source: https://www.snowflake.com/datasets/knoema-economy-data-atlas/

Help / Hints / Tips

To view historical personal consumption data:

SELECT "Date", "Value" FROM "ECONOMY"."BEANIPA"WHERE "Table Name" = 'Price Indexes For Personal Consumption Expenditures By Major Type Of Product'AND "Indicator Name" = 'Personal consumption expenditures (PCE)'AND "Frequency" = 'A'AND "Date" >= '1972-01-01'ORDER BY "Date"

Helpful quickstart (answers): https://quickstarts.snowflake.com/guide/data_apps_summit_lab/

Expected Answer

This time, we're not showing you the entire answer but a value from a previous year so that you've got a hint if you're on the right track :

You can see that this is for 2021, not the required answer for 2024

Shout out and thanks

We want to again thank Daniel for writing this challenge for us!
You can find and follow Daniel on LinkedIn and on Twitter

Remember if you want to participate:

Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘ (note joining our mailing list does not give you a Frosty Friday account)
Post your code to GitHub and make it publicly available (Check out our guide if you don't know how to here)
Post the URL in the comments of the challenge.

Hard