import pandas as pd

sdg_column_mapping = {
        0:[
            'Goal_Rating', 'Goal_Trend', 'Value_sdg_earlyedu', 'Year_sdg_earlyedu', 'impute_sdg_earlyedu',
            'Score_sdg_earlyedu', 'Rating_sdg_earlyedu', 'Trend_sdg_earlyedu', 'Value_sdg_primary',
            'Year_sdg_primary', 'Score_sdg_primary', 'Rating_sdg_primary', 'Trend_sdg_primary',
            'Value_sdg_second', 'Year_sdg_second', 'impute_sdg_second', 'Score_sdg_second', 'Rating_sdg_second',
            'Trend_sdg_second', 'Value_sdg_literacy', 'Year_sdg_literacy', 'Score_sdg_literacy', 'Rating_sdg_literacy',
            'Trend_sdg_literacy', 'Value_sdg_tertiary', 'Year_sdg_tertiary', 'Score_sdg_tertiary', 'Rating_sdg_tertiary',
            'Trend_sdg_tertiary', 'Value_sdg_pisa', 'Year_sdg_pisa', 'Rating_sdg_pisa', 'Trend_sdg_pisa',
            'Value_sdg_socioec', 'Year_sdg_socioec', 'Rating_sdg_socioec', 'Trend_sdg_socioec', 'Value_sdg_science',
            'Year_sdg_science', 'Rating_sdg_science', 'Trend_sdg_science',],
        3:[
            'Goal_3_Rating', 'Goal_3_Trend', 'Value_sdg3_matmort', 'Year_sdg3_matmort',
            'Score_sdg3_matmort', 'Rating_sdg3_matmort', 'Trend_sdg3_matmort', 'Value_sdg3_neonat',
            'Year_sdg3_neonat', 'Score_sdg3_neonat', 'Rating_sdg3_neonat', 'Trend_sdg3_neonat', 'Value_sdg3_u5mort',
            'Year_sdg3_u5mort', 'Score_sdg3_u5mort', 'Rating_sdg3_u5mort', 'Trend_sdg3_u5mort', 'Value_sdg3_tb',
            'Year_sdg3_tb', 'Score_sdg3_tb', 'Rating_sdg3_tb', 'Trend_sdg3_tb', 'Value_sdg3_hiv', 'Year_sdg3_hiv',
            'Score_sdg3_hiv', 'Rating_sdg3_hiv', 'Trend_sdg3_hiv', 'Value_sdg3_ncds', 'Year_sdg3_ncds', 'Score_sdg3_ncds',
            'Rating_sdg3_ncds', 'Trend_sdg3_ncds', 'Value_sdg3_pollmort', 'Year_sdg3_pollmort', 'Score_sdg3_pollmort',
            'Rating_sdg3_pollmort', 'Value_sdg3_traffic', 'Year_sdg3_traffic', 'Score_sdg3_traffic', 'Rating_sdg3_traffic',
            'Trend_sdg3_traffic', 'Value_sdg3_lifee', 'Year_sdg3_lifee', 'Score_sdg3_lifee', 'Rating_sdg3_lifee',
            'Trend_sdg3_lifee', 'Value_sdg3_fertility', 'Year_sdg3_fertility', 'Score_sdg3_fertility', 'Rating_sdg3_fertility',
            'Trend_sdg3_fertility', 'Value_sdg3_births', 'Year_sdg3_births', 'Score_sdg3_births', 'Rating_sdg3_births',
            'Trend_sdg3_births', 'Value_sdg3_vac', 'Year_sdg3_vac', 'Score_sdg3_vac', 'Rating_sdg3_vac', 'Trend_sdg3_vac',
            'Value_sdg3_uhc', 'Year_sdg3_uhc', 'Score_sdg3_uhc', 'Rating_sdg3_uhc', 'Trend_sdg3_uhc', 'Value_sdg3_swb',
            'Year_sdg3_swb', 'Score_sdg3_swb', 'Rating_sdg3_swb', 'Trend_sdg3_swb', 'Value_sdg3_region', 'Year_sdg3_region',
            'Rating_sdg3_region', 'Trend_sdg3_region', 'Value_sdg3_incomeg', 'Year_sdg3_incomeg', 'Rating_sdg3_incomeg',
            'Trend_sdg3_incomeg', 'Value_sdg3_smoke', 'Year_sdg3_smoke', 'Rating_sdg3_smoke', 'Trend_sdg3_smoke',
        ],
        4: [
            'Goal_4_Rating', 'Goal_4_Trend', 'Value_sdg4_earlyedu', 'Year_sdg4_earlyedu',
            'Score_sdg4_earlyedu', 'Rating_sdg4_earlyedu', 'Value_sdg4_primary',
            'Year_sdg4_primary', 'Score_sdg4_primary', 'Rating_sdg4_primary',
            'Trend_sdg4_primary', 'Value_sdg4_second', 'Year_sdg4_second',
            'impute_sdg4_second', 'Score_sdg4_second', 'Rating_sdg4_second',
            'Trend_sdg4_second', 'Value_sdg4_literacy', 'Year_sdg4_literacy',
            'Score_sdg4_literacy', 'Rating_sdg4_literacy', 'Trend_sdg4_literacy',
            'Value_sdg4_tertiary', 'Year_sdg4_tertiary', 'Rating_sdg4_tertiary',
            'Trend_sdg4_tertiary', 'Value_sdg4_pisa', 'Year_sdg4_pisa',
            'Rating_sdg4_pisa', 'Trend_sdg4_pisa', 'Value_sdg4_socioec',
            'Year_sdg4_socioec', 'Rating_sdg4_socioec', 'Trend_sdg4_socioec',
            'Value_sdg4_science', 'Year_sdg4_science', 'Rating_sdg4_science',
        ],
        5:[
            'Goal_5_Rating', 'Goal_5_Trend', 'Value_sdg5_rratio', 'Year_sdg5_rratio',
            'Score_sdg5_rratio', 'Rating_sdg5_rratio', 'Trend_sdg5_rratio', 'Value_sdg5_vawage',
            'Year_sdg5_vawage', 'Score_sdg5_vawage', 'Rating_sdg5_vawage', 'Trend_sdg5_vawage', 'Value_sdg5_lfpart',
            'Year_sdg5_lfpart', 'Score_sdg5_lfpart', 'Rating_sdg5_lfpart', 'Trend_sdg5_lfpart', 'Value_sdg5_parl',
            'Year_sdg5_parl', 'Score_sdg5_parl', 'Rating_sdg5_parl', 'Trend_sdg5_parl', 'Value_sdg5_fgm', 'Year_sdg5_fgm',
            'Score_sdg5_fgm', 'Rating_sdg5_fgm', 'Trend_sdg5_fgm', 'Value_sdg5_cmarry', 'Year_sdg5_cmarry', 'Score_sdg5_cmarry',
            'Rating_sdg5_cmarry', 'Trend_sdg5_cmarry', 'Value_sdg5_vabirth', 'Year_sdg5_vabirth', 'Score_sdg5_vabirth',
            'Rating_sdg5_vabirth', 'Trend_sdg5_vabirth',
        ],
        6:[
            'Goal_6_Rating', 'Goal_6_Trend', 'Value_sdg6_safewater', 'Year_sdg6_safewater',
            'Score_sdg6_safewater', 'Rating_sdg6_safewater', 'Trend_sdg6_safewater', 'Value_sdg6_sanitation',
            'Year_sdg6_sanitation', 'Score_sdg6_sanitation', 'Rating_sdg6_sanitation', 'Trend_sdg6_sanitation',
            'Value_sdg6_freshwater', 'Year_sdg6_freshwater', 'Score_sdg6_freshwater', 'Rating_sdg6_freshwater',
            'Trend_sdg6_freshwater', 'Value_sdg6_ecosystems', 'Year_sdg6_ecosystems', 'Score_sdg6_ecosystems',
            'Rating_sdg6_ecosystems', 'Trend_sdg6_ecosystems', 'Value_sdg6_wateruse', 'Year_sdg6_wateruse',
            'Score_sdg6_wateruse', 'Rating_sdg6_wateruse', 'Trend_sdg6_wateruse', 'Value_sdg6_waterstress',
            'Year_sdg6_waterstress', 'Score_sdg6_waterstress', 'Rating_sdg6_waterstress', 'Trend_sdg6_waterstress',
            'Value_sdg6_quality', 'Year_sdg6_quality', 'Score_sdg6_quality', 'Rating_sdg6_quality', 'Trend_sdg6_quality',
            'Value_sdg6_wastewater', 'Year_sdg6_wastewater', 'Score_sdg6_wastewater', 'Rating_sdg6_wastewater',
            'Trend_sdg6_wastewater', 'Value_sdg6_river', 'Year_sdg6_river', 'Score_sdg6_river', 'Rating_sdg6_river',
            'Trend_sdg6_river', 'Value_sdg6_fisheries', 'Year_sdg6_fisheries', 'Score_sdg6_fisheries',
            'Rating_sdg6_fisheries', 'Trend_sdg6_fisheries',
        ],
        7:[
            'Goal_7_Rating', 'Goal_7_Trend', 'Value_sdg7_access', 'Year_sdg7_access',
            'Score_sdg7_access', 'Rating_sdg7_access', 'Trend_sdg7_access', 'Value_sdg7_electrify',
            'Year_sdg7_electrify', 'Score_sdg7_electrify', 'Rating_sdg7_electrify', 'Trend_sdg7_electrify',
            'Value_sdg7_renewcon', 'Year_sdg7_renewcon', 'Score_sdg7_renewcon', 'Rating_sdg7_renewcon',
            'Trend_sdg7_renewcon', 'Value_sdg7_afford', 'Year_sdg7_afford', 'Score_sdg7_afford',
            'Rating_sdg7_afford', 'Trend_sdg7_afford', 'Value_sdg7_cleancook', 'Year_sdg7_cleancook',
            'Score_sdg7_cleancook', 'Rating_sdg7_cleancook', 'Trend_sdg7_cleancook', 'Value_sdg7_nonrenewcon',
            'Year_sdg7_nonrenewcon', 'Score_sdg7_nonrenewcon', 'Rating_sdg7_nonrenewcon',
            'Trend_sdg7_nonrenewcon', 'Value_sdg7_biofuel', 'Year_sdg7_biofuel', 'Score_sdg7_biofuel',
            'Rating_sdg7_biofuel', 'Trend_sdg7_biofuel',
        ],
        8:[
            'Goal_8_Rating', 'Goal_8_Trend', 'Value_sdg8_adjgrowth', 'Year_sdg8_adjgrowth',
            'Score_sdg8_adjgrowth', 'Rating_sdg8_adjgrowth', 'Value_sdg8_slavery', 'Year_sdg8_slavery',
            'impute_sdg8_slavery', 'Score_sdg8_slavery', 'Rating_sdg8_slavery', 'Value_sdg8_accounts',
            'Year_sdg8_accounts', 'Score_sdg8_accounts', 'Rating_sdg8_accounts', 'Trend_sdg8_accounts',
            'Value_sdg8_unemp', 'Year_sdg8_unemp', 'Score_sdg8_unemp', 'Rating_sdg8_unemp',
            'Trend_sdg8_unemp',
        ],
        9:[
            'Goal_9_Rating', 'Goal_9_Trend', 'Value_sdg9_roads', 'Year_sdg9_roads',
            'Score_sdg9_roads', 'Rating_sdg9_roads', 'Value_sdg9_intuse', 'Year_sdg9_intuse',
            'Score_sdg9_intuse', 'Rating_sdg9_intuse', 'Trend_sdg9_intuse', 'Value_sdg9_mobuse',
            'Year_sdg9_mobuse', 'Score_sdg9_mobuse', 'Rating_sdg9_mobuse', 'Trend_sdg9_mobuse',
            'Value_sdg9_lpi', 'Year_sdg9_lpi', 'Score_sdg9_lpi', 'Rating_sdg9_lpi', 'Trend_sdg9_lpi',
            'Value_sdg9_uni', 'Year_sdg9_uni', 'impute_sdg9_uni', 'Score_sdg9_uni', 'Rating_sdg9_uni',
            'Value_sdg9_articles', 'Year_sdg9_articles', 'Score_sdg9_articles', 'Rating_sdg9_articles',
            'Trend_sdg9_articles', 'Value_sdg9_rdex', 'Year_sdg9_rdex', 'impute_sdg9_rdex', 'Score_sdg9_rdex',
            'Rating_sdg9_rdex', 'Trend_sdg9_rdex', 'Value_sdg9_rdres', 'Year_sdg9_rdres',
            'Rating_sdg9_rdres', 'Trend_sdg9_rdres', 'Value_sdg9_patents', 'Year_sdg9_patents',
            'Rating_sdg9_patents', 'Trend_sdg9_patents', 'Value_sdg9_netacc', 'Year_sdg9_netacc',
            'Rating_sdg9_netacc', 'Trend_sdg9_netacc', 'Value_sdg9_womensci', 'Year_sdg9_womensci',
            'Rating_sdg9_womensci', 'Trend_sdg9_womensci',
        ],
        10:[
            'Goal_10_Rating', 'Goal_10_Trend', 'Value_sdg10_gini', 'Year_sdg10_gini',
            'Score_sdg10_gini', 'Rating_sdg10_gini', 'Trend_sdg10_gini', 'Value_sdg10_palma',
            'Year_sdg10_palma', 'Score_sdg10_palma', 'Rating_sdg10_palma', 'Trend_sdg10_palma',
            'Value_sdg10_elder', 'Year_sdg10_elder', 'Rating_sdg10_elder', 'Trend_sdg10_elder',
        ],
        11:[
            'Goal_11_Rating', 'Goal_11_Trend', 'Value_sdg11_slums', 'Year_sdg11_slums',
            'impute_sdg11_slums', 'Score_sdg11_slums', 'Rating_sdg11_slums', 'Trend_sdg11_slums',
            'Value_sdg11_pm25', 'Year_sdg11_pm25', 'Score_sdg11_pm25', 'Rating_sdg11_pm25',
            'Trend_sdg11_pm25', 'Value_sdg11_pipedwat', 'Year_sdg11_pipedwat',
            'Score_sdg11_pipedwat', 'Rating_sdg11_pipedwat', 'Trend_sdg11_pipedwat',
            'Value_sdg11_transport', 'Year_sdg11_transport', 'Score_sdg11_transport',
            'Rating_sdg11_transport', 'Trend_sdg11_transport', 'Value_sdg11_rentover',
            'Year_sdg11_rentover', 'Rating_sdg11_rentover', 'Trend_sdg11_rentover',
            'Value_sdg11_walkable', 'Year_sdg11_walkable', 'Rating_sdg11_walkable',
        ],
        12:[
            'Goal_12_Rating', 'Goal_12_Trend', 'Value_sdg12_waste', 'Year_sdg12_waste',
            'impute_sdg12_waste', 'Score_sdg12_waste', 'Rating_sdg12_waste', 'Trend_sdg12_waste',
            'Value_sdg12_recycling', 'Year_sdg12_recycling', 'impute_sdg12_recycling',
            'Score_sdg12_recycling', 'Rating_sdg12_recycling', 'Trend_sdg12_recycling',
            'Value_sdg12_solidwaste', 'Year_sdg12_solidwaste', 'impute_sdg12_solidwaste',
            'Score_sdg12_solidwaste', 'Rating_sdg12_solidwaste', 'Trend_sdg12_solidwaste',
        ],
        13:[
            'Goal_13_Rating', 'Goal_13_Trend', 'Value_sdg13_emissions', 'Year_sdg13_emissions',
            'impute_sdg13_emissions', 'Score_sdg13_emissions', 'Rating_sdg13_emissions',
            'Trend_sdg13_emissions', 'Value_sdg13_forests', 'Year_sdg13_forests',
            'impute_sdg13_forests', 'Score_sdg13_forests', 'Rating_sdg13_forests',
            'Trend_sdg13_forests',
        ],
        14:[
            'Goal_14_Rating', 'Goal_14_Trend', 'Value_sdg14_overfishing', 'Year_sdg14_overfishing',
            'impute_sdg14_overfishing', 'Score_sdg14_overfishing', 'Rating_sdg14_overfishing',
            'Trend_sdg14_overfishing', 'Value_sdg14_mpa', 'Year_sdg14_mpa', 'impute_sdg14_mpa',
            'Score_sdg14_mpa', 'Rating_sdg14_mpa', 'Trend_sdg14_mpa',
        ],
        17:[
            'Goal_17_Rating', 'Goal_17_Trend', 'Value_sdg17_govex', 'Year_sdg17_govex',
            'Score_sdg17_govex', 'Rating_sdg17_govex', 'Trend_sdg17_govex', 'Value_sdg17_oda',
            'Year_sdg17_oda', 'Score_sdg17_oda', 'Rating_sdg17_oda', 'Trend_sdg17_oda',
            'Value_sdg17_fp', 'Year_sdg17_fp', 'impute_sdg17_fp', 'Score_sdg17_fp',
            'Rating_sdg17_fp', 'Trend_sdg17_fp',
        ]
    }

def filter_data(country_name, sdg_number):
    # Load your dataset
    data = pd.read_csv(r'C:\Users\Samer\OneDrive\DS\SDG\new\Sustainable_Development_Report_2023_(with_indicators)__-2086263501583264136.csv')
    
    # Create a mapping of SDG numbers to their corresponding columns
    sdg_column_mapping = {
        0:[
            'Goal_Rating', 'Goal_Trend', 'Value_sdg_earlyedu', 'Year_sdg_earlyedu', 'impute_sdg_earlyedu',
            'Score_sdg_earlyedu', 'Rating_sdg_earlyedu', 'Trend_sdg_earlyedu', 'Value_sdg_primary',
            'Year_sdg_primary', 'Score_sdg_primary', 'Rating_sdg_primary', 'Trend_sdg_primary',
            'Value_sdg_second', 'Year_sdg_second', 'impute_sdg_second', 'Score_sdg_second', 'Rating_sdg_second',
            'Trend_sdg_second', 'Value_sdg_literacy', 'Year_sdg_literacy', 'Score_sdg_literacy', 'Rating_sdg_literacy',
            'Trend_sdg_literacy', 'Value_sdg_tertiary', 'Year_sdg_tertiary', 'Score_sdg_tertiary', 'Rating_sdg_tertiary',
            'Trend_sdg_tertiary', 'Value_sdg_pisa', 'Year_sdg_pisa', 'Rating_sdg_pisa', 'Trend_sdg_pisa',
            'Value_sdg_socioec', 'Year_sdg_socioec', 'Rating_sdg_socioec', 'Trend_sdg_socioec', 'Value_sdg_science',
            'Year_sdg_science', 'Rating_sdg_science', 'Trend_sdg_science',],
        3:[
            'Goal_3_Rating', 'Goal_3_Trend', 'Value_sdg3_matmort', 'Year_sdg3_matmort',
            'Score_sdg3_matmort', 'Rating_sdg3_matmort', 'Trend_sdg3_matmort', 'Value_sdg3_neonat',
            'Year_sdg3_neonat', 'Score_sdg3_neonat', 'Rating_sdg3_neonat', 'Trend_sdg3_neonat', 'Value_sdg3_u5mort',
            'Year_sdg3_u5mort', 'Score_sdg3_u5mort', 'Rating_sdg3_u5mort', 'Trend_sdg3_u5mort', 'Value_sdg3_tb',
            'Year_sdg3_tb', 'Score_sdg3_tb', 'Rating_sdg3_tb', 'Trend_sdg3_tb', 'Value_sdg3_hiv', 'Year_sdg3_hiv',
            'Score_sdg3_hiv', 'Rating_sdg3_hiv', 'Trend_sdg3_hiv', 'Value_sdg3_ncds', 'Year_sdg3_ncds', 'Score_sdg3_ncds',
            'Rating_sdg3_ncds', 'Trend_sdg3_ncds', 'Value_sdg3_pollmort', 'Year_sdg3_pollmort', 'Score_sdg3_pollmort',
            'Rating_sdg3_pollmort', 'Value_sdg3_traffic', 'Year_sdg3_traffic', 'Score_sdg3_traffic', 'Rating_sdg3_traffic',
            'Trend_sdg3_traffic', 'Value_sdg3_lifee', 'Year_sdg3_lifee', 'Score_sdg3_lifee', 'Rating_sdg3_lifee',
            'Trend_sdg3_lifee', 'Value_sdg3_fertility', 'Year_sdg3_fertility', 'Score_sdg3_fertility', 'Rating_sdg3_fertility',
            'Trend_sdg3_fertility', 'Value_sdg3_births', 'Year_sdg3_births', 'Score_sdg3_births', 'Rating_sdg3_births',
            'Trend_sdg3_births', 'Value_sdg3_vac', 'Year_sdg3_vac', 'Score_sdg3_vac', 'Rating_sdg3_vac', 'Trend_sdg3_vac',
            'Value_sdg3_uhc', 'Year_sdg3_uhc', 'Score_sdg3_uhc', 'Rating_sdg3_uhc', 'Trend_sdg3_uhc', 'Value_sdg3_swb',
            'Year_sdg3_swb', 'Score_sdg3_swb', 'Rating_sdg3_swb', 'Trend_sdg3_swb', 'Value_sdg3_region', 'Year_sdg3_region',
            'Rating_sdg3_region', 'Trend_sdg3_region', 'Value_sdg3_incomeg', 'Year_sdg3_incomeg', 'Rating_sdg3_incomeg',
            'Trend_sdg3_incomeg', 'Value_sdg3_smoke', 'Year_sdg3_smoke', 'Rating_sdg3_smoke', 'Trend_sdg3_smoke',
        ],
        4: [
            'Goal_4_Rating', 'Goal_4_Trend', 'Value_sdg4_earlyedu', 'Year_sdg4_earlyedu',
            'Score_sdg4_earlyedu', 'Rating_sdg4_earlyedu', 'Value_sdg4_primary',
            'Year_sdg4_primary', 'Score_sdg4_primary', 'Rating_sdg4_primary',
            'Trend_sdg4_primary', 'Value_sdg4_second', 'Year_sdg4_second',
            'impute_sdg4_second', 'Score_sdg4_second', 'Rating_sdg4_second',
            'Trend_sdg4_second', 'Value_sdg4_literacy', 'Year_sdg4_literacy',
            'Score_sdg4_literacy', 'Rating_sdg4_literacy', 'Trend_sdg4_literacy',
            'Value_sdg4_tertiary', 'Year_sdg4_tertiary', 'Rating_sdg4_tertiary',
            'Trend_sdg4_tertiary', 'Value_sdg4_pisa', 'Year_sdg4_pisa',
            'Rating_sdg4_pisa', 'Trend_sdg4_pisa', 'Value_sdg4_socioec',
            'Year_sdg4_socioec', 'Rating_sdg4_socioec', 'Trend_sdg4_socioec',
            'Value_sdg4_science', 'Year_sdg4_science', 'Rating_sdg4_science',
        ],
        5:[
            'Goal_5_Rating', 'Goal_5_Trend', 'Value_sdg5_rratio', 'Year_sdg5_rratio',
            'Score_sdg5_rratio', 'Rating_sdg5_rratio', 'Trend_sdg5_rratio', 'Value_sdg5_vawage',
            'Year_sdg5_vawage', 'Score_sdg5_vawage', 'Rating_sdg5_vawage', 'Trend_sdg5_vawage', 'Value_sdg5_lfpart',
            'Year_sdg5_lfpart', 'Score_sdg5_lfpart', 'Rating_sdg5_lfpart', 'Trend_sdg5_lfpart', 'Value_sdg5_parl',
            'Year_sdg5_parl', 'Score_sdg5_parl', 'Rating_sdg5_parl', 'Trend_sdg5_parl', 'Value_sdg5_fgm', 'Year_sdg5_fgm',
            'Score_sdg5_fgm', 'Rating_sdg5_fgm', 'Trend_sdg5_fgm', 'Value_sdg5_cmarry', 'Year_sdg5_cmarry', 'Score_sdg5_cmarry',
            'Rating_sdg5_cmarry', 'Trend_sdg5_cmarry', 'Value_sdg5_vabirth', 'Year_sdg5_vabirth', 'Score_sdg5_vabirth',
            'Rating_sdg5_vabirth', 'Trend_sdg5_vabirth',
        ],
        6:[
            'Goal_6_Rating', 'Goal_6_Trend', 'Value_sdg6_safewater', 'Year_sdg6_safewater',
            'Score_sdg6_safewater', 'Rating_sdg6_safewater', 'Trend_sdg6_safewater', 'Value_sdg6_sanitation',
            'Year_sdg6_sanitation', 'Score_sdg6_sanitation', 'Rating_sdg6_sanitation', 'Trend_sdg6_sanitation',
            'Value_sdg6_freshwater', 'Year_sdg6_freshwater', 'Score_sdg6_freshwater', 'Rating_sdg6_freshwater',
            'Trend_sdg6_freshwater', 'Value_sdg6_ecosystems', 'Year_sdg6_ecosystems', 'Score_sdg6_ecosystems',
            'Rating_sdg6_ecosystems', 'Trend_sdg6_ecosystems', 'Value_sdg6_wateruse', 'Year_sdg6_wateruse',
            'Score_sdg6_wateruse', 'Rating_sdg6_wateruse', 'Trend_sdg6_wateruse', 'Value_sdg6_waterstress',
            'Year_sdg6_waterstress', 'Score_sdg6_waterstress', 'Rating_sdg6_waterstress', 'Trend_sdg6_waterstress',
            'Value_sdg6_quality', 'Year_sdg6_quality', 'Score_sdg6_quality', 'Rating_sdg6_quality', 'Trend_sdg6_quality',
            'Value_sdg6_wastewater', 'Year_sdg6_wastewater', 'Score_sdg6_wastewater', 'Rating_sdg6_wastewater',
            'Trend_sdg6_wastewater', 'Value_sdg6_river', 'Year_sdg6_river', 'Score_sdg6_river', 'Rating_sdg6_river',
            'Trend_sdg6_river', 'Value_sdg6_fisheries', 'Year_sdg6_fisheries', 'Score_sdg6_fisheries',
            'Rating_sdg6_fisheries', 'Trend_sdg6_fisheries',
        ],
        7:[
            'Goal_7_Rating', 'Goal_7_Trend', 'Value_sdg7_access', 'Year_sdg7_access',
            'Score_sdg7_access', 'Rating_sdg7_access', 'Trend_sdg7_access', 'Value_sdg7_electrify',
            'Year_sdg7_electrify', 'Score_sdg7_electrify', 'Rating_sdg7_electrify', 'Trend_sdg7_electrify',
            'Value_sdg7_renewcon', 'Year_sdg7_renewcon', 'Score_sdg7_renewcon', 'Rating_sdg7_renewcon',
            'Trend_sdg7_renewcon', 'Value_sdg7_afford', 'Year_sdg7_afford', 'Score_sdg7_afford',
            'Rating_sdg7_afford', 'Trend_sdg7_afford', 'Value_sdg7_cleancook', 'Year_sdg7_cleancook',
            'Score_sdg7_cleancook', 'Rating_sdg7_cleancook', 'Trend_sdg7_cleancook', 'Value_sdg7_nonrenewcon',
            'Year_sdg7_nonrenewcon', 'Score_sdg7_nonrenewcon', 'Rating_sdg7_nonrenewcon',
            'Trend_sdg7_nonrenewcon', 'Value_sdg7_biofuel', 'Year_sdg7_biofuel', 'Score_sdg7_biofuel',
            'Rating_sdg7_biofuel', 'Trend_sdg7_biofuel',
        ],
        8:[
            'Goal_8_Rating', 'Goal_8_Trend', 'Value_sdg8_adjgrowth', 'Year_sdg8_adjgrowth',
            'Score_sdg8_adjgrowth', 'Rating_sdg8_adjgrowth', 'Value_sdg8_slavery', 'Year_sdg8_slavery',
            'impute_sdg8_slavery', 'Score_sdg8_slavery', 'Rating_sdg8_slavery', 'Value_sdg8_accounts',
            'Year_sdg8_accounts', 'Score_sdg8_accounts', 'Rating_sdg8_accounts', 'Trend_sdg8_accounts',
            'Value_sdg8_unemp', 'Year_sdg8_unemp', 'Score_sdg8_unemp', 'Rating_sdg8_unemp',
            'Trend_sdg8_unemp',
        ],
        9:[
            'Goal_9_Rating', 'Goal_9_Trend', 'Value_sdg9_roads', 'Year_sdg9_roads',
            'Score_sdg9_roads', 'Rating_sdg9_roads', 'Value_sdg9_intuse', 'Year_sdg9_intuse',
            'Score_sdg9_intuse', 'Rating_sdg9_intuse', 'Trend_sdg9_intuse', 'Value_sdg9_mobuse',
            'Year_sdg9_mobuse', 'Score_sdg9_mobuse', 'Rating_sdg9_mobuse', 'Trend_sdg9_mobuse',
            'Value_sdg9_lpi', 'Year_sdg9_lpi', 'Score_sdg9_lpi', 'Rating_sdg9_lpi', 'Trend_sdg9_lpi',
            'Value_sdg9_uni', 'Year_sdg9_uni', 'impute_sdg9_uni', 'Score_sdg9_uni', 'Rating_sdg9_uni',
            'Value_sdg9_articles', 'Year_sdg9_articles', 'Score_sdg9_articles', 'Rating_sdg9_articles',
            'Trend_sdg9_articles', 'Value_sdg9_rdex', 'Year_sdg9_rdex', 'impute_sdg9_rdex', 'Score_sdg9_rdex',
            'Rating_sdg9_rdex', 'Trend_sdg9_rdex', 'Value_sdg9_rdres', 'Year_sdg9_rdres',
            'Rating_sdg9_rdres', 'Trend_sdg9_rdres', 'Value_sdg9_patents', 'Year_sdg9_patents',
            'Rating_sdg9_patents', 'Trend_sdg9_patents', 'Value_sdg9_netacc', 'Year_sdg9_netacc',
            'Rating_sdg9_netacc', 'Trend_sdg9_netacc', 'Value_sdg9_womensci', 'Year_sdg9_womensci',
            'Rating_sdg9_womensci', 'Trend_sdg9_womensci',
        ],
        10:[
            'Goal_10_Rating', 'Goal_10_Trend', 'Value_sdg10_gini', 'Year_sdg10_gini',
            'Score_sdg10_gini', 'Rating_sdg10_gini', 'Trend_sdg10_gini', 'Value_sdg10_palma',
            'Year_sdg10_palma', 'Score_sdg10_palma', 'Rating_sdg10_palma', 'Trend_sdg10_palma',
            'Value_sdg10_elder', 'Year_sdg10_elder', 'Rating_sdg10_elder', 'Trend_sdg10_elder',
        ],
        11:[
            'Goal_11_Rating', 'Goal_11_Trend', 'Value_sdg11_slums', 'Year_sdg11_slums',
            'impute_sdg11_slums', 'Score_sdg11_slums', 'Rating_sdg11_slums', 'Trend_sdg11_slums',
            'Value_sdg11_pm25', 'Year_sdg11_pm25', 'Score_sdg11_pm25', 'Rating_sdg11_pm25',
            'Trend_sdg11_pm25', 'Value_sdg11_pipedwat', 'Year_sdg11_pipedwat',
            'Score_sdg11_pipedwat', 'Rating_sdg11_pipedwat', 'Trend_sdg11_pipedwat',
            'Value_sdg11_transport', 'Year_sdg11_transport', 'Score_sdg11_transport',
            'Rating_sdg11_transport', 'Trend_sdg11_transport', 'Value_sdg11_rentover',
            'Year_sdg11_rentover', 'Rating_sdg11_rentover', 'Trend_sdg11_rentover',
            'Value_sdg11_walkable', 'Year_sdg11_walkable', 'Rating_sdg11_walkable',
        ],
        12:[
            'Goal_12_Rating', 'Goal_12_Trend', 'Value_sdg12_waste', 'Year_sdg12_waste',
            'impute_sdg12_waste', 'Score_sdg12_waste', 'Rating_sdg12_waste', 'Trend_sdg12_waste',
            'Value_sdg12_recycling', 'Year_sdg12_recycling', 'impute_sdg12_recycling',
            'Score_sdg12_recycling', 'Rating_sdg12_recycling', 'Trend_sdg12_recycling',
            'Value_sdg12_solidwaste', 'Year_sdg12_solidwaste', 'impute_sdg12_solidwaste',
            'Score_sdg12_solidwaste', 'Rating_sdg12_solidwaste', 'Trend_sdg12_solidwaste',
        ],
        13:[
            'Goal_13_Rating', 'Goal_13_Trend', 'Value_sdg13_emissions', 'Year_sdg13_emissions',
            'impute_sdg13_emissions', 'Score_sdg13_emissions', 'Rating_sdg13_emissions',
            'Trend_sdg13_emissions', 'Value_sdg13_forests', 'Year_sdg13_forests',
            'impute_sdg13_forests', 'Score_sdg13_forests', 'Rating_sdg13_forests',
            'Trend_sdg13_forests',
        ],
        14:[
            'Goal_14_Rating', 'Goal_14_Trend', 'Value_sdg14_overfishing', 'Year_sdg14_overfishing',
            'impute_sdg14_overfishing', 'Score_sdg14_overfishing', 'Rating_sdg14_overfishing',
            'Trend_sdg14_overfishing', 'Value_sdg14_mpa', 'Year_sdg14_mpa', 'impute_sdg14_mpa',
            'Score_sdg14_mpa', 'Rating_sdg14_mpa', 'Trend_sdg14_mpa',
        ],
        17:[
            'Goal_17_Rating', 'Goal_17_Trend', 'Value_sdg17_govex', 'Year_sdg17_govex',
            'Score_sdg17_govex', 'Rating_sdg17_govex', 'Trend_sdg17_govex', 'Value_sdg17_oda',
            'Year_sdg17_oda', 'Score_sdg17_oda', 'Rating_sdg17_oda', 'Trend_sdg17_oda',
            'Value_sdg17_fp', 'Year_sdg17_fp', 'impute_sdg17_fp', 'Score_sdg17_fp',
            'Rating_sdg17_fp', 'Trend_sdg17_fp',
        ]
    }

    
    # Get the list of columns based on the selected SDG number
    selected_columns = ['Country_Name'] + sdg_column_mapping.get(sdg_number, [])
    
    # Filter data based on country and selected columns
    selected_data = data[data['Name'] == country_name][selected_columns]
    return selected_data