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
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!
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 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/
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 :
Shout out and thanks
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.