Spaces:
Running
on
CPU Upgrade
Running
on
CPU Upgrade
| """ | |
| Page to analyse the link between crs codes, countries and organizations | |
| """ | |
| ################ | |
| # DEPENDENCIES # | |
| ################ | |
| import streamlit as st | |
| import pandas as pd | |
| import utils.crs_table as crs_table | |
| import utils.sdg_table as sdg_table | |
| import utils.filter_modules as filter_modules | |
| """ | |
| from importlib.machinery import SourceFileLoader | |
| crs_overlap = SourceFileLoader("crs_overlap", "data/models/crs_overlap.py").load_module() | |
| sdg_overlap = SourceFileLoader("sdg_overlap", "data/models/sdg_overlap.py").load_module() | |
| CONSTANTS = SourceFileLoader("CONSTANTS", "config/CONSTANTS.py").load_module() | |
| # CHACHE DATA | |
| # FETCH NEEDED DATA AND STORE IN CHACHE MEMORY TO SAVE LOADING TIME | |
| @st.cache_data | |
| def getCRS3(): | |
| # Read in CRS3 CODELISTS | |
| crs3_df = pd.read_csv('app/src/codelists/crs3_codes.csv') | |
| CRS3_CODES = crs3_df['code'].tolist() | |
| CRS3_NAME = crs3_df['name'].tolist() | |
| CRS3_MERGED = {f"{name} - {code}": code for name, code in zip(CRS3_NAME, CRS3_CODES)} | |
| return CRS3_MERGED | |
| @st.cache_data | |
| def getCRS5(): | |
| # Read in CRS3 CODELISTS | |
| crs5_df = pd.read_csv('app/src/codelists/crs5_codes.csv') | |
| CRS5_CODES = crs5_df['code'].tolist() | |
| CRS5_NAME = crs5_df['name'].tolist() | |
| CRS5_MERGED = {code: [f"{name} - {code}"] for name, code in zip(CRS5_NAME, CRS5_CODES)} | |
| return CRS5_MERGED | |
| @st.cache_data | |
| def getSDG(): | |
| # Read in SDG CODELISTS | |
| sdg_df = pd.read_csv('app/src/codelists/sdg_goals.csv') | |
| SDG_NAMES = sdg_df['name'].tolist() | |
| return SDG_NAMES | |
| @st.cache_data | |
| def getCountry(): | |
| # Read in countries from codelist | |
| country_df = pd.read_csv('app/src/codelists/country_codes_ISO3166-1alpha-2.csv') | |
| COUNTRY_CODES = country_df['Alpha-2 code'].tolist() | |
| COUNTRY_NAMES = country_df['Country'].tolist() | |
| return country_df, COUNTRY_CODES, COUNTRY_NAMES | |
| CRS3_MERGED = getCRS3() | |
| CRS5_MERGED = getCRS5() | |
| SDG_NAMES = getSDG() | |
| country_df, COUNTRY_CODES, COUNTRY_NAMES = getCountry() | |
| # SPECIAL SELECTIONS | |
| ## COUNTRY | |
| SPECIAL_COUNTRY_SLECTIONS = ["All"] | |
| SHOW_ALL_COUNTRIES = False # If all countries should be showed in matching | |
| ## ORGANIZATION | |
| SPECIAL_ORGA_SLECTIONS = ["All"] | |
| SHOW_ALL_ORGAS = False | |
| """ | |
| ######## | |
| # PAGE # | |
| ######## | |
| def show_page(): | |
| """ | |
| def show_crs(): | |
| # SESSION STATES | |
| st.session_state.crs5_option_disabled = True | |
| # SELECTION FIELDS | |
| col1, col2 = st.columns([1, 1]) | |
| with col1: | |
| ##################### | |
| # CRS 3 CODE SELECT # | |
| ##################### | |
| crs3_option = st.multiselect( | |
| 'CRS 3', | |
| CRS3_MERGED, | |
| placeholder="Select" | |
| ) | |
| ##################### | |
| # CRS 5 CODE SELECT # | |
| ##################### | |
| # Only enable crs5 select field when crs3 code is selected | |
| if crs3_option != []: | |
| st.session_state.crs5_option_disabled = False | |
| # define list of crs5 codes dependend on crs3 codes | |
| crs5_list = [txt[0].replace('"', "") for crs3_item in crs3_option for code, txt in CRS5_MERGED.items() if str(code)[:3] == str(crs3_item)[-3:]] | |
| # crs5 select field | |
| crs5_option = st.multiselect( | |
| 'CRS 5', | |
| crs5_list, | |
| placeholder="Select", | |
| disabled=st.session_state.crs5_option_disabled | |
| ) | |
| with col2: | |
| # COUNTRY SELECTION | |
| country_option = filter_modules.country_option(SPECIAL_COUNTRY_SLECTIONS, COUNTRY_NAMES) | |
| # ORGA SELECTION | |
| orga_option = filter_modules.orga_option(SPECIAL_ORGA_SLECTIONS, CONSTANTS.ORGA_SEARCH) | |
| ################ | |
| # SHOW RESULTS # | |
| ################ | |
| # Extract Orgas from multiselect | |
| if "All" in orga_option: | |
| SHOW_ALL_ORGAS = True | |
| selected_orgas = [] | |
| else: | |
| SHOW_ALL_ORGAS = False | |
| selected_orgas = [str(o).replace(")", "").lower().split("(")[1] for o in orga_option] | |
| if country_option != []: | |
| # all selection | |
| if "All" in country_option: | |
| SHOW_ALL_COUNTRIES = True | |
| country_option.remove("All") | |
| else: | |
| SHOW_ALL_COUNTRIES = False | |
| if crs3_option != []: | |
| # CRS 3 codes from option | |
| crs3_list = [i[-3:] for i in crs3_option] | |
| # get country codes from multiselect | |
| country_names = [str(c) for c in country_option] | |
| country_codes = [ | |
| country_df[country_df['Country'] == c]['Alpha-2 code'].values[0].replace('"', "").strip(" ") | |
| for c in country_names | |
| ] | |
| result_df = crs_overlap.calc_crs3(crs3_list, country_codes, selected_orgas, SHOW_ALL_COUNTRIES, SHOW_ALL_ORGAS) | |
| if crs5_option != []: | |
| # CRS 5 codes from option | |
| crs5_list = [i[-5:] for i in crs5_option] | |
| result_df = crs_overlap.calc_crs5(crs5_list, country_codes, selected_orgas, SHOW_ALL_COUNTRIES, SHOW_ALL_ORGAS) | |
| # TABLE FOR CRS OVERLAP | |
| crs_table.show_table(result_df) | |
| def show_sdg(): | |
| # SELECTION | |
| col1, col2 = st.columns([1, 1]) | |
| with col1: | |
| # CRS3 CODE SELECT | |
| sdg_option = st.selectbox( | |
| label = 'SDG', | |
| index = None, | |
| placeholder = "Select SDG", | |
| options = SDG_NAMES, | |
| ) | |
| with col2: | |
| # COUNTRY SELECTION | |
| country_option = filter_modules.country_option(SPECIAL_COUNTRY_SLECTIONS, COUNTRY_NAMES) | |
| # ORGA SELECTION | |
| orga_option = filter_modules.orga_option(SPECIAL_ORGA_SLECTIONS, CONSTANTS.ORGA_SEARCH) | |
| # SHOW RESULTS | |
| if sdg_option != None: | |
| sdg_int = int(sdg_option.split(" ")[0].replace(".", "")) | |
| # Extract Orgas from multiselect | |
| if "All" in orga_option: | |
| SHOW_ALL_ORGAS = True | |
| selected_orgas = [] | |
| else: | |
| SHOW_ALL_ORGAS = False | |
| selected_orgas = [str(o).replace(")", "").lower().split("(")[1] for o in orga_option] | |
| if country_option != []: | |
| # all selection | |
| if "All" in country_option: | |
| SHOW_ALL_COUNTRIES = True | |
| country_option.remove("All") | |
| else: | |
| SHOW_ALL_COUNTRIES = False | |
| country_names = [str(c) for c in country_option] | |
| country_codes = [ | |
| country_df[country_df['Country'] == c]['Alpha-2 code'].values[0].replace('"', "").strip(" ") | |
| for c in country_names | |
| ] | |
| result_df = sdg_overlap.calc_crs3(sdg_int, country_codes, selected_orgas, SHOW_ALL_COUNTRIES, SHOW_ALL_ORGAS) | |
| # TABLE FOR SDG OVERLAP | |
| sdg_table.show_table(result_df) | |
| # SELECT IF CRS or SDG Match | |
| match_option = st.selectbox( | |
| label = 'Matching Method', | |
| index = 0, | |
| placeholder = "Select", | |
| options = ["CRS", "SDG"], | |
| ) | |
| st.write("------------------") | |
| if match_option == "CRS": | |
| show_crs() | |
| elif match_option == "SDG": | |
| show_sdg() | |
| """ | |