Week 12 - Streamlit & Apps

This week's challenge is another Streamlit challenge, we want you to produce an interface where you can upload files into whichever table is selected.

create schema <enter_db_name_here>.world_bank_metadata;create or replace table <enter_db_name_here>.world_bank_metadata.country_metadata(country_code varchar(3),region string,income_group string);create schema <enter_db_name_here>.world_bank_economic_indicators;create or replace table <enter_db_name_here>.world_bank_economic_indicators.gdp(country_name string,country_code varchar(3),year int,gdp_usd double);create table <enter_db_name_here>.world_bank_economic_indicators.gov_expenditure(country_name string,country_code varchar(3),year int,gov_expenditure_pct_gdp double);create schema <enter_db_name_here>.world_bank_social_indiactors;create or replace table <enter_db_name_here>.world_bank_social_indiactors.life_expectancy(country_name string,country_code varchar(3),year int,life_expectancy float);create or replace table <enter_db_name_here>.world_bank_social_indiactors.adult_literacy_rate(country_name string,country_code varchar(3),year int,adult_literacy_rate float);create or replace table <enter_db_name_here>.world_bank_social_indiactors.progression_to_secondary_school(country_name string,country_code varchar(3),year int,progression_to_secondary_school float);

Unfortunately, basic Python knowledge is essential for this week. But, it's nothing a quick beginner's course couldn't quickly teach you!

You can find the data here, and the FF logo here.

RESULT

Remember if you want to participate:

1. 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)
2. Post your code to GitHub and make it publicly available (Check out our guide if you don't know how to here)
3. Post the URL in the comments of the challenge.

You can also sign up to our mailing list below.