tar.py

sdg_indicators_mapping = {
    0:["Maternal Mortality Ratio (MMR)","Under-5 Mortality Rate (U5MR)","Neonatal Mortality Rate (NMR)","Infant Mortality Rate (IMR)","Prevalence of HIV, TB and Malaria","Prevalence of Overweight and Obesity","Rate of New HIV Infections","Rate of Tuberculosis (TB) Incidence","Rate of Malaria Incidence","Healthcare Coverage", "Number of Healthcare Providers","Healthcare Expenditure","Healthcare Access","Healthcare Quality","Healthcare Equity","4.1.1 Proportion of children and young people (a) in grades 2/3; (b) at the end of primary; and (c) at the end of lower secondary achieving at least a minimum proficiency level in (i) reading and (ii) mathematics, by sex","4.2.2 Participation rate in organized learning (one year before the official primary entry age), by sex","4.3.1 Participation rate of youth and adults in formal and non-formal education and training in the previous 12 months, by sex""5.2.1 Proportion of ever-partnered women and girls aged 15 years and older subjected to physical, sexual or psychological violence by a current or former intimate partner in the previous 12 months, by form of violence and by age","5.2.2 Proportion of women and girls aged 15 years and older subjected to sexual violence by persons other than an intimate partner in the previous 12 months, by age and place of occurrence","5.5.1 Proportion of seats held by women in (a) national parliaments and (b) local governments","6.1.1 - Proportion of population using safely managed drinking water services","6.2.1 - Proportion of population using safely managed sanitation services","6.3.1 - Proportion of wastewater safely treated","6.4.2 - Level of water stress","6.B.1 - Proportion of local administrative units with established and operational policies and procedures for participation of local communities in water and sanitation management","7.1.1 - Proportion of population with access to electricity","7.2.1 - Renewable energy share in the total final energy consumption","7.3.1 - Energy intensity measured in terms of primary energy and GDP","7.B.1 - Investments in energy efficiency as a percentage of GDP and the amount of foreign direct investment in financial transfers and infrastructure","7.C.1 - Proportion of population with access to clean cooking fuels and technologies","8.1 - Sustain per capita economic growth in accordance with national circumstances and, in particular, at least 7 per cent gross domestic product growth per annum in the least developed countries","8.2 - Achieve higher levels of economic productivity through diversification, technological upgrading, and innovation, including through a focus on high-value added and labour-intensive sectors","8.4 - Improve progressively, through 2030, global resource efficiency in consumption and production and endeavour to decouple economic growth from environmental degradation, in accordance with the 10-year framework of programmes on sustainable consumption and production, with developed countries taking the lead","8.6 - By 2020, substantially reduce the proportion of youth not in employment, education or training","8.C - By 2030, substantially reduce the proportion of youth not in employment, education or training","9.1 - Develop quality, reliable, sustainable, and resilient infrastructure, including regional and transborder infrastructure, to support economic development and human well-being, with a focus on affordable and equitable access for all", "9.2 - Promote inclusive and sustainable industrialization and, by 2030, significantly raise industry's share of employment and gross domestic product, in line with national circumstances, and double its share in least developed countries","9.3 - Increase the access of small-scale industrial and other enterprises, in particular in developing countries, to financial services, including affordable credit, and their integration into value chains and markets","9.4 - By 2030, upgrade infrastructure and retrofit industries to make them sustainable, with increased resource-use efficiency and greater adoption of clean and environmentally sound technologies and industrial processes, with all countries taking action in accordance with their respective capabilities","9.5 - Enhance scientific research, upgrade the technological capabilities of industrial sectors in all countries, in particular developing countries, including, by 2030, encouraging innovation and substantially increasing the number of research and development workers per 1 million people and public and private research and development spending","9.A - Facilitate sustainable and resilient infrastructure development in developing countries through enhanced financial, technological, and technical support to African countries, least developed countries, landlocked developing countries, and small island developing States","9.B - Support domestic technology development, research, and innovation in developing countries, including by ensuring a conducive policy environment for, inter alia, industrial diversification and value addition to commodities","9.C - Significantly increase access to information and communications technology and strive to provide universal and affordable access to the Internet in least developed countries by 2020","10.1 - By 2030, progressively achieve and sustain income growth of the bottom 40% of the population at a rate higher than the national average","10.2 - By 2030, empower and promote the social, economic, and political inclusion of all, irrespective of age, sex, disability, race, ethnicity, origin, religion, or economic or other status","10.3 - Ensure equal opportunity and reduce inequalities of outcome, including by eliminating discriminatory laws, policies, and practices and promoting appropriate legislation, policies, and action in this regard","10.4 - Adopt policies, especially fiscal, wage, and social protection policies, and progressively achieve greater equality","10.5 - Improve the regulation and monitoring of global financial markets and institutions and strengthen the implementation of such regulations","10.6 - Ensure enhanced representation and voice for developing countries in decision-making in global international economic and financial institutions in order to deliver more effective, credible, accountable, and legitimate institutions","10.7 - Facilitate orderly, safe, regular, and responsible migration and mobility of people, including through the implementation of planned and well-managed migration policies","10.A - Implement the principle of special and differential treatment for developing countries, in particular least developed countries, in accordance with World Trade Organization agreements","10.B - Encourage official development assistance and financial flows, including foreign direct investment, to States where the need is greatest, in particular least developed countries, African countries, and small island developing States","10.C - By 2030, reduce to less than 3% the transaction costs of migrant remittances and eliminate remittance corridors with costs higher than 5%","11.1 - By 2030, ensure access for all to adequate, safe, and affordable housing and basic services and upgrade slums", "11.2 - By 2030, provide access to safe, affordable, accessible, and sustainable transport systems for all, improving road safety, notably by expanding public transport, with special attention to the needs of those in vulnerable situations, women, children, persons with disabilities, and older persons","11.3 - By 2030, enhance inclusive and sustainable urbanization and capacity for participatory, integrated, and sustainable human settlement planning and management in all countries","11.4 - Strengthen efforts to protect and safeguard the world's cultural and natural heritage", "11.5 - By 2030, significantly reduce the number of deaths and the number of people affected and substantially decrease the direct economic losses relative to global gross domestic product caused by disasters, including water-related disasters, with a focus on protecting the poor and people in vulnerable situations","11.6 - By 2030, reduce the adverse per capita environmental impact of cities, including by paying special attention to air quality and municipal and other waste management","11.7 - By 2030, provide universal access to safe, inclusive, and accessible, green, and public spaces, in particular for women and children, older persons, and persons with disabilities","11.A - Support positive economic, social, and environmental links between urban, peri-urban, and rural areas by strengthening national and regional development planning","11.B - By 2020, substantially increase the number of cities and human settlements adopting and implementing integrated policies and plans towards inclusion, resource efficiency, mitigation, and adaptation to climate change, resilience to disasters, and develop and implement, in line with the Sendai Framework for Disaster Risk Reduction 2015-2030, holistic disaster risk management at all levels","11.C - Support least developed countries, including through financial and technical assistance, in building sustainable and resilient buildings utilizing local materials","12.1 - Implement the 10-Year Framework of Programmes on Sustainable Consumption and Production Patterns, all countries taking action, with developed countries taking the lead, taking into account the development and capabilities of developing countries","12.2 - By 2030, achieve the sustainable management and efficient use of natural resources", "12.3 - By 2030, halve per capita global food waste at the retail and consumer levels and reduce food losses along production and supply chains, including post-harvest losses","12.4 - By 2020, achieve the environmentally sound management of chemicals and all wastes throughout their life cycle, in accordance with agreed international frameworks, and significantly reduce their release to air, water, and soil to minimize their adverse impacts on human health and the environment","12.5 - By 2030, substantially reduce waste generation through prevention, reduction, recycling, and reuse","12.6 - Encourage companies, especially large and transnational companies, to adopt sustainable practices and to integrate sustainability information into their reporting cycle","12.7 - Promote public procurement practices that are sustainable, in accordance with national policies and priorities","12.8 - By 2030, ensure that people everywhere have the relevant information and awareness for sustainable development and lifestyles in harmony with nature","12.A - Support developing countries to strengthen their scientific and technological capacity to move towards more sustainable patterns of consumption and production","12.B - Develop and implement tools to monitor sustainable development impacts for sustainable tourism that creates jobs and promotes local culture and products","13.1 - Strengthen resilience and adaptive capacity to climate-related hazards and natural disasters in all countries","13.2 - Integrate climate change measures into national policies, strategies, and planning","13.3 - Improve education, awareness-raising, and human and institutional capacity on climate change mitigation, adaptation, impact reduction, and early warning","13.A - Implement the commitment undertaken by developed-country parties to the United Nations Framework Convention on Climate Change to a goal of mobilizing jointly $100 billion annually by 2020 from all sources to address the needs of developing countries in the context of meaningful mitigation actions and transparency on implementation and fully operationalize the Green Climate Fund through its capitalization as soon as possible","13.B - Promote mechanisms for raising capacity for effective climate change-related planning and management in least developed countries and small island developing states, including focusing on women, youth, and local and marginalized communities","14.1 - By 2025, prevent and significantly reduce marine pollution of all kinds, in particular from land-based activities, including marine debris and nutrient pollution","14.2 - By 2020, sustainably manage and protect marine and coastal ecosystems to avoid significant adverse impacts, including by strengthening their resilience, and take action for their restoration in order to achieve healthy and productive oceans","14.3 - Minimize and address the impacts of ocean acidification, including through enhanced scientific cooperation at all levels","14.4 - By 2020, effectively regulate harvesting and end overfishing, illegal, unreported, and unregulated fishing, and restore fish stocks in the shortest time feasible","14.5 - By 2020, conserve at least 10 percent of coastal and marine areas, consistent with national and international law and based on the best available scientific information","14.6 - By 2020, prohibit certain forms of fisheries subsidies which contribute to overcapacity and overfishing, and eliminate subsidies that contribute to illegal, unreported, and unregulated fishing, and refrain from introducing new such subsidies, recognizing that appropriate and effective special and differential treatment for developing and least developed countries should be an integral part of the World Trade Organization fisheries subsidies negotiation","14.7 - By 2030, increase the economic benefits to small island developing states and least developed countries from the sustainable use of marine resources, including through sustainable management of fisheries, aquaculture, and tourism","14.A - Increase scientific knowledge, develop research capacity, and transfer marine technology in order to improve ocean health and to enhance the contribution of marine biodiversity to the development of developing countries, in particular, small island developing states and least developed countries","14.B - Provide access for small-scale artisanal fishers to marine resources and markets","14.C - Enhance the conservation and sustainable use of oceans and their resources by implementing international law as reflected in UNCLOS, which provides the legal framework for the conservation and sustainable use of oceans and their resources, as recalled in paragraph 158 of 'The Future We Want'","17.1 - Domestic resource mobilization","17.2 - Official development assistance (ODA) as a percentage of gross national income (GNI)","17.3 - Foreign direct investment (FDI), official development assistance, and remittances","17.4 - Debt service as a percentage of exports of goods and services"],
    3:["Maternal Mortality Ratio (MMR)","Under-5 Mortality Rate (U5MR)","Neonatal Mortality Rate (NMR)","Infant Mortality Rate (IMR)","Prevalence of HIV, TB and Malaria","Prevalence of Overweight and Obesity","Rate of New HIV Infections","Rate of Tuberculosis (TB) Incidence","Rate of Malaria Incidence","Healthcare Coverage", "Number of Healthcare Providers","Healthcare Expenditure","Healthcare Access","Healthcare Quality","Healthcare Equity"],
    4:["4.1.1 Proportion of children and young people (a) in grades 2/3; (b) at the end of primary; and (c) at the end of lower secondary achieving at least a minimum proficiency level in (i) reading and (ii) mathematics, by sex","4.2.2 Participation rate in organized learning (one year before the official primary entry age), by sex","4.3.1 Participation rate of youth and adults in formal and non-formal education and training in the previous 12 months, by sex"],
    5:["5.2.1 Proportion of ever-partnered women and girls aged 15 years and older subjected to physical, sexual or psychological violence by a current or former intimate partner in the previous 12 months, by form of violence and by age","5.2.2 Proportion of women and girls aged 15 years and older subjected to sexual violence by persons other than an intimate partner in the previous 12 months, by age and place of occurrence","5.5.1 Proportion of seats held by women in (a) national parliaments and (b) local governments"],
    6:["6.1.1 - Proportion of population using safely managed drinking water services","6.2.1 - Proportion of population using safely managed sanitation services","6.3.1 - Proportion of wastewater safely treated","6.4.2 - Level of water stress","6.B.1 - Proportion of local administrative units with established and operational policies and procedures for participation of local communities in water and sanitation management"],
    7:["7.1.1 - Proportion of population with access to electricity","7.2.1 - Renewable energy share in the total final energy consumption","7.3.1 - Energy intensity measured in terms of primary energy and GDP","7.B.1 - Investments in energy efficiency as a percentage of GDP and the amount of foreign direct investment in financial transfers and infrastructure","7.C.1 - Proportion of population with access to clean cooking fuels and technologies"],
    8:["8.1 - Sustain per capita economic growth in accordance with national circumstances and, in particular, at least 7 per cent gross domestic product growth per annum in the least developed countries","8.2 - Achieve higher levels of economic productivity through diversification, technological upgrading, and innovation, including through a focus on high-value added and labour-intensive sectors","8.4 - Improve progressively, through 2030, global resource efficiency in consumption and production and endeavour to decouple economic growth from environmental degradation, in accordance with the 10-year framework of programmes on sustainable consumption and production, with developed countries taking the lead","8.6 - By 2020, substantially reduce the proportion of youth not in employment, education or training","8.C - By 2030, substantially reduce the proportion of youth not in employment, education or training"],
    9:["9.1 - Develop quality, reliable, sustainable, and resilient infrastructure, including regional and transborder infrastructure, to support economic development and human well-being, with a focus on affordable and equitable access for all", "9.2 - Promote inclusive and sustainable industrialization and, by 2030, significantly raise industry's share of employment and gross domestic product, in line with national circumstances, and double its share in least developed countries","9.3 - Increase the access of small-scale industrial and other enterprises, in particular in developing countries, to financial services, including affordable credit, and their integration into value chains and markets","9.4 - By 2030, upgrade infrastructure and retrofit industries to make them sustainable, with increased resource-use efficiency and greater adoption of clean and environmentally sound technologies and industrial processes, with all countries taking action in accordance with their respective capabilities","9.5 - Enhance scientific research, upgrade the technological capabilities of industrial sectors in all countries, in particular developing countries, including, by 2030, encouraging innovation and substantially increasing the number of research and development workers per 1 million people and public and private research and development spending","9.A - Facilitate sustainable and resilient infrastructure development in developing countries through enhanced financial, technological, and technical support to African countries, least developed countries, landlocked developing countries, and small island developing States","9.B - Support domestic technology development, research, and innovation in developing countries, including by ensuring a conducive policy environment for, inter alia, industrial diversification and value addition to commodities","9.C - Significantly increase access to information and communications technology and strive to provide universal and affordable access to the Internet in least developed countries by 2020"],
    10:["10.1 - By 2030, progressively achieve and sustain income growth of the bottom 40% of the population at a rate higher than the national average","10.2 - By 2030, empower and promote the social, economic, and political inclusion of all, irrespective of age, sex, disability, race, ethnicity, origin, religion, or economic or other status","10.3 - Ensure equal opportunity and reduce inequalities of outcome, including by eliminating discriminatory laws, policies, and practices and promoting appropriate legislation, policies, and action in this regard","10.4 - Adopt policies, especially fiscal, wage, and social protection policies, and progressively achieve greater equality","10.5 - Improve the regulation and monitoring of global financial markets and institutions and strengthen the implementation of such regulations","10.6 - Ensure enhanced representation and voice for developing countries in decision-making in global international economic and financial institutions in order to deliver more effective, credible, accountable, and legitimate institutions","10.7 - Facilitate orderly, safe, regular, and responsible migration and mobility of people, including through the implementation of planned and well-managed migration policies","10.A - Implement the principle of special and differential treatment for developing countries, in particular least developed countries, in accordance with World Trade Organization agreements","10.B - Encourage official development assistance and financial flows, including foreign direct investment, to States where the need is greatest, in particular least developed countries, African countries, and small island developing States","10.C - By 2030, reduce to less than 3% the transaction costs of migrant remittances and eliminate remittance corridors with costs higher than 5%"],
    11:["11.1 - By 2030, ensure access for all to adequate, safe, and affordable housing and basic services and upgrade slums", "11.2 - By 2030, provide access to safe, affordable, accessible, and sustainable transport systems for all, improving road safety, notably by expanding public transport, with special attention to the needs of those in vulnerable situations, women, children, persons with disabilities, and older persons","11.3 - By 2030, enhance inclusive and sustainable urbanization and capacity for participatory, integrated, and sustainable human settlement planning and management in all countries","11.4 - Strengthen efforts to protect and safeguard the world's cultural and natural heritage", "11.5 - By 2030, significantly reduce the number of deaths and the number of people affected and substantially decrease the direct economic losses relative to global gross domestic product caused by disasters, including water-related disasters, with a focus on protecting the poor and people in vulnerable situations","11.6 - By 2030, reduce the adverse per capita environmental impact of cities, including by paying special attention to air quality and municipal and other waste management","11.7 - By 2030, provide universal access to safe, inclusive, and accessible, green, and public spaces, in particular for women and children, older persons, and persons with disabilities","11.A - Support positive economic, social, and environmental links between urban, peri-urban, and rural areas by strengthening national and regional development planning","11.B - By 2020, substantially increase the number of cities and human settlements adopting and implementing integrated policies and plans towards inclusion, resource efficiency, mitigation, and adaptation to climate change, resilience to disasters, and develop and implement, in line with the Sendai Framework for Disaster Risk Reduction 2015-2030, holistic disaster risk management at all levels","11.C - Support least developed countries, including through financial and technical assistance, in building sustainable and resilient buildings utilizing local materials"],
    12:["12.1 - Implement the 10-Year Framework of Programmes on Sustainable Consumption and Production Patterns, all countries taking action, with developed countries taking the lead, taking into account the development and capabilities of developing countries","12.2 - By 2030, achieve the sustainable management and efficient use of natural resources", "12.3 - By 2030, halve per capita global food waste at the retail and consumer levels and reduce food losses along production and supply chains, including post-harvest losses","12.4 - By 2020, achieve the environmentally sound management of chemicals and all wastes throughout their life cycle, in accordance with agreed international frameworks, and significantly reduce their release to air, water, and soil to minimize their adverse impacts on human health and the environment","12.5 - By 2030, substantially reduce waste generation through prevention, reduction, recycling, and reuse","12.6 - Encourage companies, especially large and transnational companies, to adopt sustainable practices and to integrate sustainability information into their reporting cycle","12.7 - Promote public procurement practices that are sustainable, in accordance with national policies and priorities","12.8 - By 2030, ensure that people everywhere have the relevant information and awareness for sustainable development and lifestyles in harmony with nature","12.A - Support developing countries to strengthen their scientific and technological capacity to move towards more sustainable patterns of consumption and production","12.B - Develop and implement tools to monitor sustainable development impacts for sustainable tourism that creates jobs and promotes local culture and products"],
    13:["13.1 - Strengthen resilience and adaptive capacity to climate-related hazards and natural disasters in all countries","13.2 - Integrate climate change measures into national policies, strategies, and planning","13.3 - Improve education, awareness-raising, and human and institutional capacity on climate change mitigation, adaptation, impact reduction, and early warning","13.A - Implement the commitment undertaken by developed-country parties to the United Nations Framework Convention on Climate Change to a goal of mobilizing jointly $100 billion annually by 2020 from all sources to address the needs of developing countries in the context of meaningful mitigation actions and transparency on implementation and fully operationalize the Green Climate Fund through its capitalization as soon as possible","13.B - Promote mechanisms for raising capacity for effective climate change-related planning and management in least developed countries and small island developing states, including focusing on women, youth, and local and marginalized communities"],
    14:["14.1 - By 2025, prevent and significantly reduce marine pollution of all kinds, in particular from land-based activities, including marine debris and nutrient pollution","14.2 - By 2020, sustainably manage and protect marine and coastal ecosystems to avoid significant adverse impacts, including by strengthening their resilience, and take action for their restoration in order to achieve healthy and productive oceans","14.3 - Minimize and address the impacts of ocean acidification, including through enhanced scientific cooperation at all levels","14.4 - By 2020, effectively regulate harvesting and end overfishing, illegal, unreported, and unregulated fishing, and restore fish stocks in the shortest time feasible","14.5 - By 2020, conserve at least 10 percent of coastal and marine areas, consistent with national and international law and based on the best available scientific information","14.6 - By 2020, prohibit certain forms of fisheries subsidies which contribute to overcapacity and overfishing, and eliminate subsidies that contribute to illegal, unreported, and unregulated fishing, and refrain from introducing new such subsidies, recognizing that appropriate and effective special and differential treatment for developing and least developed countries should be an integral part of the World Trade Organization fisheries subsidies negotiation","14.7 - By 2030, increase the economic benefits to small island developing states and least developed countries from the sustainable use of marine resources, including through sustainable management of fisheries, aquaculture, and tourism","14.A - Increase scientific knowledge, develop research capacity, and transfer marine technology in order to improve ocean health and to enhance the contribution of marine biodiversity to the development of developing countries, in particular, small island developing states and least developed countries","14.B - Provide access for small-scale artisanal fishers to marine resources and markets","14.C - Enhance the conservation and sustainable use of oceans and their resources by implementing international law as reflected in UNCLOS, which provides the legal framework for the conservation and sustainable use of oceans and their resources, as recalled in paragraph 158 of 'The Future We Want'"],
    17:["17.1 - Domestic resource mobilization","17.2 - Official development assistance (ODA) as a percentage of gross national income (GNI)","17.3 - Foreign direct investment (FDI), official development assistance, and remittances","17.4 - Debt service as a percentage of exports of goods and services"]

}

def get_indicators(sdg_num):
    sdg_indicators_mapping
    return sdg_indicators_mapping.get(sdg_num, "Invalid SDG number")

sdg_progress_mapping ={3:15, 4:3, 5:3, 6:5, 7:5, 8:5 , 9:8, 10:10, 11:10, 12:10 , 13:5, 14:10 , 17:4}

sdg_input_mapping = {
    '3.1 Maternal Mortality Ratio (MMR)':[
                {"name": "Number of maternal deaths"},
                {"name": "Number of live births"}
            ],
    "3.2 Under-5 Mortality Rate (U5MR)":[
                {"name": "Number of under-5 deaths"},
                {"name": "Number of live births"}],
    "3.3 Neonatal Mortality Rate (NMR)":[
                {"name": "Number of neonatal deaths"},
                {"name": "Number of live births"}],
    "3.4 Infant Mortality Rate (IMR)":[
                {"name": "Number of infant deaths"},
                {"name": "Number of live births"}],
    "3.5 Prevalence of HIV, TB and Malaria":[{"name": "Number of people living with HIV, TB and Malaria"},
                {"name": "Total population"}
            ],
    "3.6 Prevalence of Overweight and Obesity":[
                {"name": "Number of overweight and obese individuals"},
                {"name": "Total population"}],
    "3.7 Rate of New HIV Infections":[{"name": "Number of new HIV infections"},
                {"name": "Total population"}],
    "3.8 Rate of Tuberculosis (TB) Incidence":[
                {"name": "Number of TB cases"},
                {"name": "Total population"}],
    "3.9 Rate of Malaria Incidence":[{"name": "Number of malaria cases"},
                {"name": "Total population"}],
    "3.10 Healthcare Coverage":[
                {"name": "Number of people with access to essential health services"},
                {"name": "Total population"}],
    "3.11 Number of Healthcare Providers":[ {"name": "Number of doctors"},
                {"name": "Number of nurses"},
                {"name": "Number of midwives"},
                {"name": "Total population"}],
    "3.12 Healthcare Expenditure":[ {"name": "Total healthcare expenditure"},
                {"name": "GDP"}],
    "3.13 Healthcare Access":[
                {"name": "Number of people with access to essential health services"},
                {"name": "Total population"}],
    "3.14 Healthcare Quality":[
                {"name": "Number of healthcare facilities meeting minimum standards"},
                {"name": "Total number of healthcare facilities"}],
    "3.15 Healthcare Equity":[
                {"name": "Number of disadvantaged populations with access to essential health services"},
                {"name": "Total number of disadvantaged populations"}],
    "4.1.1 Proportion of children and young people (a) in grades 2/3; (b) at the end of primary; and (c) at the end of lower secondary achieving at least a minimum proficiency level in (i) reading and (ii) mathematics, by sex":[   {"name": "Number of children achieving minimum proficiency in reading and math"}, 
                    {"name": "Total number of children"}],
    "4.2.2 Participation rate in organized learning (one year before the official primary entry age), by sex":[
                    {"name": "Number of children in organized learning before primary"},
                    {"name": "Total number of children"}],
    "4.3.1 Participation rate of youth and adults in formal and non-formal education and training in the previous 12 months, by sex":[
                    {"name": "Number of youth and adults in education or training"},
                    {"name": "Total number of youth and adults"}],
    "5.2.1 Proportion of ever-partnered women and girls aged 15 years and older subjected to physical, sexual or psychological violence by a current or former intimate partner in the previous 12 months, by form of violence and by age":[
            {"name": "Number of women/girls subjected to intimate partner violence"},
            {"name": "Total number of women/girls with current or former partner"}],
    "5.2.2 Proportion of women and girls aged 15 years and older subjected to sexual violence by persons other than an intimate partner in the previous 12 months, by age and place of occurrence":[{"name": "Number of women/girls subjected to non-partner sexual violence"},
            {"name": "Total number of women/girls"}],
    "5.5.1 Proportion of seats held by women in (a) national parliaments and (b) local governments":[
            {"name": "Number of seats held by women"},
            {"name": "Total number of seats"}],
    "6.1.1 - Proportion of population using safely managed drinking water services":[
                {"name": "Number of people using safely managed drinking water services"},
                {"name": "Total population"}],
    "6.2.1 - Proportion of population using safely managed sanitation services":[
                {"name": "Number of people using safely managed sanitation services"},
                {"name": "Total population"}],
    "6.3.1 - Proportion of wastewater safely treated":[
                {"name": "Volume of wastewater safely treated"},
                {"name": "Total volume of wastewater"}],
    "6.4.2 - Level of water stress":[
                {"name": "Annual total water withdrawal"},
                {"name": "Total renewable freshwater resources"}],
    "6.B.1 - Proportion of local administrative units with established and operational policies and procedures for participation of local communities in water and sanitation management":[ {"name": "Number of local administrative units with established and operational policies and procedures for participation of local communities in water and sanitation management"},
                {"name": "Total number of local administrative units"}],
    "7.1.1 - Proportion of population with access to electricity":[
                {"name": "Number of people with access to electricity"},
                {"name": "Total population"}],
    "7.2.1 - Renewable energy share in the total final energy consumption":[
                {"name": "Final energy consumption from renewables"},
                {"name": "Total final energy consumption"}],
    "7.3.1 - Energy intensity measured in terms of primary energy and GDP":[
                {"name": "Primary energy use"},
                {"name": "GDP"}],
    "7.B.1 - Investments in energy efficiency as a percentage of GDP and the amount of foreign direct investment in financial transfers and infrastructure":[ {"name": "Investments in energy efficiency"},
                {"name": "GDP"}],
    "7.C.1 - Proportion of population with access to clean cooking fuels and technologies":[{"name": "Number of people with access to clean cooking fuels and technologies"},
                {"name": "Total population"}],
    "8.1 - Sustain per capita economic growth in accordance with national circumstances and, in particular, at least 7 per cent gross domestic product growth per annum in the least developed countries":[{"name": "GDP at time t"},
                {"name": "GDP at time t-1"}],
    "8.2 - Achieve higher levels of economic productivity through diversification, technological upgrading, and innovation, including through a focus on high-value added and labour-intensive sectors":[
                {"name": "Value added"},
                {"name": "Total employment"}],
    "8.4 - Improve progressively, through 2030, global resource efficiency in consumption and production and endeavour to decouple economic growth from environmental degradation, in accordance with the 10-year framework of programmes on sustainable consumption and production, with developed countries taking the lead":[
                {"name": "Value of resource output"},
                {"name": "Total input of resources"}
            ],
    "8.6 - By 2020, substantially reduce the proportion of youth not in employment, education or training":[
                {"name": "Proportion at time t"},
                {"name": "Proportion at time t-1"}],
    "8.C - By 2030, substantially reduce the proportion of youth not in employment, education or training":[
                {"name": "Proportion at time t"},
                {"name": "Proportion at time t-1"}],
    "9.1 - Develop quality, reliable, sustainable, and resilient infrastructure, including regional and transborder infrastructure, to support economic development and human well-being, with a focus on affordable and equitable access for all":[{"name": "Quality of infrastructure"},
                {"name": "Reliability of infrastructure"},
                {"name": "Sustainability of infrastructure"},
                {"name": "Resilience of infrastructure"}],
    "9.2 - Promote inclusive and sustainable industrialization and, by 2030, significantly raise industry's share of employment and gross domestic product, in line with national circumstances, and double its share in least developed countries":[ {"name": "Share of industry in GDP"},
                {"name": "Share of industry in employment"}],
    "9.3 - Increase the access of small-scale industrial and other enterprises, in particular in developing countries, to financial services, including affordable credit, and their integration into value chains and markets":[{"name": "Number of small-scale enterprises with access to affordable credit"},
                {"name": "Number of enterprises integrated into value chains and markets"}],
    "9.4 - By 2030, upgrade infrastructure and retrofit industries to make them sustainable, with increased resource-use efficiency and greater adoption of clean and environmentally sound technologies and industrial processes, with all countries taking action in accordance with their respective capabilities":[ {"name": "Infrastructure upgrade progress"},
                {"name": "Industry retrofit progress"},
                {"name": "Resource-use efficiency"},
                {"name": "Technology adoption"}],
    "9.5 - Enhance scientific research, upgrade the technological capabilities of industrial sectors in all countries, in particular developing countries, including, by 2030, encouraging innovation and substantially increasing the number of research and development workers per 1 million people and public and private research and development spending":[{"name": "Number of research and development workers per 1 million people"},
                {"name": "Total research and development spending"}],
     "9.A - Facilitate sustainable and resilient infrastructure development in developing countries through enhanced financial, technological, and technical support to African countries, least developed countries, landlocked developing countries, and small island developing States":[ {"name": "Financial support to developing countries"},
                {"name": "Technological support to developing countries"},
                {"name": "Technical support to developing countries"}],
    "9.B - Support domestic technology development, research, and innovation in developing countries, including by ensuring a conducive policy environment for, inter alia, industrial diversification and value addition to commodities":[{"name": "Support for technology development in developing countries"},
                {"name": "Research and innovation support in developing countries"},
                {"name": "Policy environment support in developing countries"}],
    "9.C - Significantly increase access to information and communications technology and strive to provide universal and affordable access to the Internet in least developed countries by 2020":[{"name": "Access to information and communications technology (ICT)"},
                {"name": "Universal and affordable Internet access in least developed countries"}],
    "10.1 - By 2030, progressively achieve and sustain income growth of the bottom 40% of the population at a rate higher than the national average":[ {"name": "Income growth of the bottom 40%"},
                {"name": "National income growth"}],
    "10.2 - By 2030, empower and promote the social, economic, and political inclusion of all, irrespective of age, sex, disability, race, ethnicity, origin, religion, or economic or other status":[{"name": "Economic inclusion"},
                {"name": "Social inclusion"},
                {"name": "Political inclusion"}],
    "10.3 - Ensure equal opportunity and reduce inequalities of outcome, including by eliminating discriminatory laws, policies, and practices and promoting appropriate legislation, policies, and action in this regard":[{"name": "Opportunity equality"},
                {"name": "Outcome equality"}],
    "10.4 - Adopt policies, especially fiscal, wage, and social protection policies, and progressively achieve greater equality":[{"name": "Fiscal policy equality"},
                {"name": "Wage policy equality"},
                {"name": "Social protection policy equality"}],
    "10.5 - Improve the regulation and monitoring of global financial markets and institutions and strengthen the implementation of such regulations":[{"name": "Effectiveness of financial market regulation"},
                {"name": "Effectiveness of financial institution regulation"}],
    "10.6 - Ensure enhanced representation and voice for developing countries in decision-making in global international economic and financial institutions in order to deliver more effective, credible, accountable, and legitimate institutions":[{"name": "Representation in decision-making"},
                {"name": "Voice in decision-making"}],
    "10.7 - Facilitate orderly, safe, regular, and responsible migration and mobility of people, including through the implementation of planned and well-managed migration policies":[{"name": "Effectiveness of planned migration policies"},
                {"name": "Effectiveness of managed migration policies"}],
    "10.A - Implement the principle of special and differential treatment for developing countries, in particular least developed countries, in accordance with World Trade Organization agreements":[  {"name": "Implementation of special treatment"},
                {"name": "Implementation of differential treatment"}],
    "10.B - Encourage official development assistance and financial flows, including foreign direct investment, to States where the need is greatest, in particular least developed countries, African countries, and small island developing States":[  {"name": "Official development assistance to neediest states"},
                {"name": "Foreign direct investment to neediest states"}],
    "10.C - By 2030, reduce to less than 3% the transaction costs of migrant remittances and eliminate remittance corridors with costs higher than 5%":[  {"name": "Transaction costs of migrant remittances"},
                {"name": "Elimination of costly remittance corridors"}],
    "11.1 - By 2030, ensure access for all to adequate, safe, and affordable housing and basic services and upgrade slums":[{"name": "Access to housing"},
                {"name": "Access to basic services"},
                {"name": "Slum upgrade progress"}],
    "11.2 - By 2030, provide access to safe, affordable, accessible, and sustainable transport systems for all, improving road safety, notably by expanding public transport, with special attention to the needs of those in vulnerable situations, women, children, persons with disabilities, and older persons":[{"name": "Access to transport"},
                {"name": "Affordability of transport"},
                {"name": "Accessibility of transport"},
                {"name": "Sustainability of transport"},
                {"name": "Road safety improvement"}],
    "11.3 - By 2030, enhance inclusive and sustainable urbanization and capacity for participatory, integrated, and sustainable human settlement planning and management in all countries":[  {"name": "Inclusive urbanization"},
                {"name": "Sustainable settlement planning"},
                {"name": "Integrated settlement management"}],
    "11.4 - Strengthen efforts to protect and safeguard the world's cultural and natural heritage":[ {"name": "Cultural heritage protection"},
                {"name": "Natural heritage protection"}
            ],
    "11.5 - By 2030, significantly reduce the number of deaths and the number of people affected and substantially decrease the direct economic losses relative to global gross domestic product caused by disasters, including water-related disasters, with a focus on protecting the poor and people in vulnerable situations":[
                {"name": "Reduction in deaths caused by disasters"},
                {"name": "Reduction in people affected by disasters"},
                {"name": "Decrease in economic losses relative to global GDP caused by disasters"}],
    "11.6 - By 2030, reduce the adverse per capita environmental impact of cities, including by paying special attention to air quality and municipal and other waste management":[ {"name": "Reduction in per capita environmental impact of cities"},
                {"name": "Air quality improvement in cities"},
                {"name": "Waste management improvement in cities"}],
    "11.7 - By 2030, provide universal access to safe, inclusive, and accessible, green, and public spaces, in particular for women and children, older persons, and persons with disabilities":[{"name": "Universal access to safe and inclusive public spaces"},
                {"name": "Availability of green public spaces"}],
    "11.A - Support positive economic, social, and environmental links between urban, peri-urban, and rural areas by strengthening national and regional development planning":[{"name": "Strengthening economic linkages"},
                {"name": "Strengthening social linkages"},
                {"name": "Strengthening environmental linkages"}],
    "11.B - By 2020, substantially increase the number of cities and human settlements adopting and implementing integrated policies and plans towards inclusion, resource efficiency, mitigation, and adaptation to climate change, resilience to disasters, and develop and implement, in line with the Sendai Framework for Disaster Risk Reduction 2015-2030, holistic disaster risk management at all levels":[ {"name": "Number of cities adopting integrated policies"},
                {"name": "Number of cities implementing integrated plans"},
                {"name": "Level of integration of disaster risk management"}],
    "11.C - Support least developed countries, including through financial and technical assistance, in building sustainable and resilient buildings utilizing local materials":[{"name": "Financial assistance to least developed countries"},
                {"name": "Technical assistance to least developed countries"},
                {"name": "Utilization of sustainable and resilient buildings using local materials"}
            ],
    "12.1 - Implement the 10-Year Framework of Programmes on Sustainable Consumption and Production Patterns, all countries taking action, with developed countries taking the lead, taking into account the development and capabilities of developing countries":[ {"name": "Progress in implementing the 10-Year Framework of Programmes"},
                {"name": "Leadership of developed countries"}],
    "12.2 - By 2030, achieve the sustainable management and efficient use of natural resources":[{"name": "Sustainability of natural resource management"},
                {"name": "Efficiency in natural resource use"}],
    "12.3 - By 2030, halve per capita global food waste at the retail and consumer levels and reduce food losses along production and supply chains, including post-harvest losses":[{"name": "Reduction in food waste at retail and consumer levels"},
                {"name": "Reduction in food losses along production and supply chains"}],
    "12.4 - By 2020, achieve the environmentally sound management of chemicals and all wastes throughout their life cycle, in accordance with agreed international frameworks, and significantly reduce their release to air, water, and soil to minimize their adverse impacts on human health and the environment":[{"name": "Management of chemicals and wastes according to international frameworks"},
                {"name": "Reduction in releases to air, water, and soil"}],
    "12.5 - By 2030, substantially reduce waste generation through prevention, reduction, recycling, and reuse":[ {"name": "Reduction in waste generation"},
                {"name": "Increase in recycling and reuse"}],
    "12.6 - Encourage companies, especially large and transnational companies, to adopt sustainable practices and to integrate sustainability information into their reporting cycle":[ {"name": "Adoption of sustainable practices by companies"},
                {"name": "Integration of sustainability information into reporting by companies"}],
    "12.7 - Promote public procurement practices that are sustainable, in accordance with national policies and priorities":[ {"name": "Promotion of sustainable procurement practices"},
                {"name": "Alignment with national policies and priorities"}],
    "12.8 - By 2030, ensure that people everywhere have the relevant information and awareness for sustainable development and lifestyles in harmony with nature":[{"name": "Availability of relevant information for sustainable development"},
                {"name": "Awareness for sustainable development and lifestyles in harmony with nature"}
           ],
    "12.A - Support developing countries to strengthen their scientific and technological capacity to move towards more sustainable patterns of consumption and production":[{"name": "Strengthening of scientific and technological capacity in developing countries"},
                {"name": "Transition to sustainable consumption and production patterns in developing countries"}],
    "12.B - Develop and implement tools to monitor sustainable development impacts for sustainable tourism that creates jobs and promotes local culture and products":[{"name": "Development and implementation of impact monitoring tools for sustainable tourism"},
                {"name": "Job creation and promotion of local culture and products through sustainable tourism"}],
    "13.1 - Strengthen resilience and adaptive capacity to climate-related hazards and natural disasters in all countries":[ {"name": "Strengthening resilience to climate-related hazards"},
                {"name": "Enhancing adaptive capacity to natural disasters"}],
    "13.2 - Integrate climate change measures into national policies, strategies, and planning":[ {"name": "Integration into national policies"},
                {"name": "Integration into national strategies"},
                {"name": "Integration into national planning"}],
    "13.3 - Improve education, awareness-raising, and human and institutional capacity on climate change mitigation, adaptation, impact reduction, and early warning":[{"name": "Improvement in education on climate change"},
                {"name": "Awareness-raising on climate change"},
                {"name": "Capacity improvement for climate change mitigation and adaptation"}],
    "13.A - Implement the commitment undertaken by developed-country parties to the United Nations Framework Convention on Climate Change to a goal of mobilizing jointly $100 billion annually by 2020 from all sources to address the needs of developing countries in the context of meaningful mitigation actions and transparency on implementation and fully operationalize the Green Climate Fund through its capitalization as soon as possible":[{"name": "Mobilization of $100 billion annually by 2020 for climate finance"},
                {"name": "Transparency in the implementation of climate finance commitments"},
                {"name": "Full operationalization of the Green Climate Fund"}],
    "13.B - Promote mechanisms for raising capacity for effective climate change-related planning and management in least developed countries and small island developing states, including focusing on women, youth, and local and marginalized communities":[{"name": "Capacity building for climate change planning in least developed countries"},
                {"name": "Capacity building for climate change planning in small island developing states"},
                {"name": "Focus on women, youth, and local/marginalized communities in capacity building efforts"}
          ],
    "14.1 - By 2025, prevent and significantly reduce marine pollution of all kinds, in particular from land-based activities, including marine debris and nutrient pollution":[{"name": "Reduction in marine pollution from land-based activities"},
                {"name": "Reduction in marine debris"},
                {"name": "Reduction in nutrient pollution"}],
    "14.2 - By 2020, sustainably manage and protect marine and coastal ecosystems to avoid significant adverse impacts, including by strengthening their resilience, and take action for their restoration in order to achieve healthy and productive oceans":[{"name": "Sustainable management of marine and coastal ecosystems"},
                {"name": "Protection of marine and coastal ecosystems"},
                {"name": "Strengthening resilience of marine and coastal ecosystems"},
                {"name": "Action for ecosystem restoration in oceans"}],
    "14.3 - Minimize and address the impacts of ocean acidification, including through enhanced scientific cooperation at all levels":[ {"name": "Minimization of ocean acidification impacts"},
                {"name": "Enhanced scientific cooperation for ocean acidification"}],
    "14.4 - By 2020, effectively regulate harvesting and end overfishing, illegal, unreported, and unregulated fishing, and restore fish stocks in the shortest time feasible":[{"name": "Effective regulation of harvesting and end of overfishing"},
                {"name": "Control of illegal, unreported, and unregulated fishing"},
                {"name": "Feasible time for fish stock restoration"}],
    "14.5 - By 2020, conserve at least 10 percent of coastal and marine areas, consistent with national and international law and based on the best available scientific information":[ {"name": "Conservation of coastal and marine areas"},
                {"name": "Compliance with national and international laws and agreements"},
                {"name": "Utilization of scientific information for conservation decisions"}],
    "14.6 - By 2020, prohibit certain forms of fisheries subsidies which contribute to overcapacity and overfishing, and eliminate subsidies that contribute to illegal, unreported, and unregulated fishing, and refrain from introducing new such subsidies, recognizing that appropriate and effective special and differential treatment for developing and least developed countries should be an integral part of the World Trade Organization fisheries subsidies negotiation":[ {"name": "Prohibition of certain harmful fisheries subsidies"},
                {"name": "Elimination of subsidies contributing to illegal fishing"},
                {"name": "Avoidance of introducing new harmful subsidies"}],
    "14.7 - By 2030, increase the economic benefits to small island developing states and least developed countries from the sustainable use of marine resources, including through sustainable management of fisheries, aquaculture, and tourism":[{"name": "Economic benefits to small island developing states from marine resources"},
                {"name": "Economic benefits to least developed countries from marine resources"},
                {"name": "Sustainable resource management in fisheries, aquaculture, and tourism"}],
    "14.A - Increase scientific knowledge, develop research capacity, and transfer marine technology in order to improve ocean health and to enhance the contribution of marine biodiversity to the development of developing countries, in particular, small island developing states and least developed countries":[{"name": "Increase in scientific knowledge related to ocean health"},
                {"name": "Development of research capacity in marine science"},
                {"name": "Transfer of marine technology to developing countries"}],
    "14.B - Provide access for small-scale artisanal fishers to marine resources and markets":[ {"name": "Access for small-scale artisanal fishers to marine resources"},
                {"name": "Access for small-scale artisanal fishers to markets"}],
    "14.C - Enhance the conservation and sustainable use of oceans and their resources by implementing international law as reflected in UNCLOS, which provides the legal framework for the conservation and sustainable use of oceans and their resources, as recalled in paragraph 158 of 'The Future We Want'":[{"name": "Implementation of international law under UNCLOS"},
                {"name": "Adherence to the legal framework for oceans conservation and sustainable use"}
           ],
    "17.1 - Domestic resource mobilization":[{"name": "Total domestic revenue"},
                {"name": "GDP"}],
    "17.2 - Official development assistance (ODA) as a percentage of gross national income (GNI)":[  {"name": "ODA (Official Development Assistance)"},
                {"name": "GNI (Gross National Income)"}],
    "17.3 - Foreign direct investment (FDI), official development assistance, and remittances":[{"name": "Foreign Direct Investment (FDI)"},
                {"name": "Official Development Assistance (ODA)"},
                {"name": "Remittances"}],
    "17.4 - Debt service as a percentage of exports of goods and services":[{"name": "Debt service payments"},
                {"name": "Exports of goods and services"}]

}


sdg_formula_mapping = {
    'Maternal Mortality Ratio (MMR)':"MMR = (Number of maternal deaths / 100,000 live births) x (100,000 / Number of live births)",
    "Under-5 Mortality Rate (U5MR)":"U5MR = (Number of under-5 deaths / 1,000 live births) x (1,000 / Number of live births)",
    "Neonatal Mortality Rate (NMR)":"NMR = (Number of neonatal deaths / 1,000 live births) x (1,000 / Number of live births)",
    "Infant Mortality Rate (IMR)":"IMR = (Number of infant deaths / 1,000 live births) x (1,000 / Number of live births)",
    "Prevalence of HIV, TB and Malaria":"Prevalence = (Number of people living with HIV, TB and Malaria / Total population) x 100",
    "Prevalence of Overweight and Obesity":"Prevalence = (Number of overweight and obese individuals / Total population) x 100",
    "Rate of New HIV Infections":"Rate = (Number of new HIV infections / Total population) x 100",
    "Rate of Tuberculosis (TB) Incidence":"Rate = (Number of TB cases / Total population) x 100",
    "Rate of Malaria Incidence":"Rate = (Number of malaria cases / Total population) x 100",
    "Healthcare Coverage": "Coverage = (Number of people with access to essential health services / Total population) x 100",
    "Number of Healthcare Providers":"Number of Healthcare Providers = (Number of doctors, nurses, and midwives / 100,000 population) x 100",
    "Healthcare Expenditure":"Healthcare Expenditure = (Total healthcare expenditure / GDP) x 100",
    "Healthcare Access":"Access = (Number of people with access to essential health services / Total population) x 100",
    "Healthcare Quality":"Quality = (Number of healthcare facilities meeting minimum standards / Total number of healthcare facilities) x 100",
    "Healthcare Equity":"Equity = (Number of disadvantaged populations with access to essential health services / Total number of disadvantaged populations) x 100",
    "4.1.1 Proportion of children and young people (a) in grades 2/3; (b) at the end of primary; and (c) at the end of lower secondary achieving at least a minimum proficiency level in (i) reading and (ii) mathematics, by sex":"(Number of children achieving minimum proficiency in reading and math / Total number of children) x 100",
    "4.2.2 Participation rate in organized learning (one year before the official primary entry age), by sex":"(Number of children participating in organized learning before primary / Total number of children) x 100",
    "4.3.1 Participation rate of youth and adults in formal and non-formal education and training in the previous 12 months, by sex":"(Number of youth and adults participating in education or training / Total number of youth and adults) x 100",
    "5.2.1 Proportion of ever-partnered women and girls aged 15 years and older subjected to physical, sexual or psychological violence by a current or former intimate partner in the previous 12 months, by form of violence and by age":"(Number of women/girls subjected to intimate partner violence / Total number of women/girls with current or former partner) x 100",
    "5.2.2 Proportion of women and girls aged 15 years and older subjected to sexual violence by persons other than an intimate partner in the previous 12 months, by age and place of occurrence":"(Number of women/girls subjected to non-partner sexual violence / Total number of women/girls) x 100",
    "5.5.1 Proportion of seats held by women in (a) national parliaments and (b) local governments":"(Number of seats held by women / Total number of seats) x 100",
    "6.1.1 - Proportion of population using safely managed drinking water services":"Proportion = (Number of people using safely managed drinking water services / Total population) x 100",
    "6.2.1 - Proportion of population using safely managed sanitation services":"Proportion = (Number of people using safely managed sanitation services / Total population) x 100",
    "6.3.1 - Proportion of wastewater safely treated":"Proportion = (Volume of wastewater safely treated / Total volume of wastewater) x 100",
    "6.4.2 - Level of water stress":"Level of water stress = (Annual total water withdrawal as a percentage of total renewable freshwater resources)",
    "6.B.1 - Proportion of local administrative units with established and operational policies and procedures for participation of local communities in water and sanitation management":"Proportion = (Number of local administrative units with established and operational policies and procedures for participation of local communities in water and sanitation management / Total number of local administrative units) x 100",
    "7.1.1 - Proportion of population with access to electricity":"Proportion = (Number of people with access to electricity / Total population) x 100",
    "7.2.1 - Renewable energy share in the total final energy consumption":"Share of renewables = (Final energy consumption from renewables / Total final energy consumption) x 100",
    "7.3.1 - Energy intensity measured in terms of primary energy and GDP":"Energy intensity = (Primary energy use / GDP)",
    "7.B.1 - Investments in energy efficiency as a percentage of GDP and the amount of foreign direct investment in financial transfers and infrastructure":"Investments in energy efficiency = (Investments in energy efficiency / GDP)",
    "7.C.1 - Proportion of population with access to clean cooking fuels and technologies":"Proportion = (Number of people with access to clean cooking fuels and technologies / Total population) x 100",
    "8.1 - Sustain per capita economic growth in accordance with national circumstances and, in particular, at least 7 per cent gross domestic product growth per annum in the least developed countries":"Growth rate = ((GDP at time t / GDP at time t-1) - 1) x 100",
    "8.2 - Achieve higher levels of economic productivity through diversification, technological upgrading, and innovation, including through a focus on high-value added and labour-intensive sectors":"Economic productivity = (Value added / Total employment)",
    "8.4 - Improve progressively, through 2030, global resource efficiency in consumption and production and endeavour to decouple economic growth from environmental degradation, in accordance with the 10-year framework of programmes on sustainable consumption and production, with developed countries taking the lead":"Resource efficiency = (Value of resource output / Total input of resources)",
    "8.6 - By 2020, substantially reduce the proportion of youth not in employment, education or training":"Proportion reduction = ((Proportion at time t - Proportion at time t-1) / Proportion at time t-1) x 100",
    "8.C - By 2030, substantially reduce the proportion of youth not in employment, education or training":"Proportion reduction = ((Proportion at time t - Proportion at time t-1) / Proportion at time t-1) x 100",
    "9.1 - Develop quality, reliable, sustainable, and resilient infrastructure, including regional and transborder infrastructure, to support economic development and human well-being, with a focus on affordable and equitable access for all":"Infrastructure Development Index = (Sum of quality + reliability + sustainability + resilience) / 4",
    "9.2 - Promote inclusive and sustainable industrialization and, by 2030, significantly raise industry's share of employment and gross domestic product, in line with national circumstances, and double its share in least developed countries": "Industrialization Index = (Share of industry in GDP + Share of industry in employment) / 2",
    "9.3 - Increase the access of small-scale industrial and other enterprises, in particular in developing countries, to financial services, including affordable credit, and their integration into value chains and markets":"Access to Finance Index = (Number of small-scale enterprises with access to affordable credit + Number of enterprises integrated into value chains and markets) / 2",
    "9.4 - By 2030, upgrade infrastructure and retrofit industries to make them sustainable, with increased resource-use efficiency and greater adoption of clean and environmentally sound technologies and industrial processes, with all countries taking action in accordance with their respective capabilities":"Sustainability Enhancement Index = (Infrastructure upgrade progress + Industry retrofit progress + Resource-use efficiency + Technology adoption) / 4",
    "9.5 - Enhance scientific research, upgrade the technological capabilities of industrial sectors in all countries, in particular developing countries, including, by 2030, encouraging innovation and substantially increasing the number of research and development workers per 1 million people and public and private research and development spending":"Technology and Innovation Index = (Number of research and development workers per 1 million people + Total research and development spending) / 2",
    "9.A - Facilitate sustainable and resilient infrastructure development in developing countries through enhanced financial, technological, and technical support to African countries, least developed countries, landlocked developing countries, and small island developing States":"Support Index = (Financial support + Technological support + Technical support) / 3",
    "9.B - Support domestic technology development, research, and innovation in developing countries, including by ensuring a conducive policy environment for, inter alia, industrial diversification and value addition to commodities":"Domestic Technology Support Index = (Support for technology development + Research and innovation support + Policy environment support) / 3",
    "9.C - Significantly increase access to information and communications technology and strive to provide universal and affordable access to the Internet in least developed countries by 2020":"ICT Access and Internet Availability Index = (Access to ICT + Universal and affordable Internet access) / 2",
    "10.1 - By 2030, progressively achieve and sustain income growth of the bottom 40% of the population at a rate higher than the national average":"Income Growth of Bottom 40% Index = ((Income growth of the bottom 40% / National income growth) - 1) x 100",
    "10.2 - By 2030, empower and promote the social, economic, and political inclusion of all, irrespective of age, sex, disability, race, ethnicity, origin, religion, or economic or other status":"Inclusion Index = (Economic inclusion + Social inclusion + Political inclusion) / 3",
    "10.3 - Ensure equal opportunity and reduce inequalities of outcome, including by eliminating discriminatory laws, policies, and practices and promoting appropriate legislation, policies, and action in this regard":"Equal Opportunity Index = (Opportunity equality + Outcome equality) / 2",
    "10.4 - Adopt policies, especially fiscal, wage, and social protection policies, and progressively achieve greater equality":"Equality Policy Adoption Index = (Fiscal policy equality + Wage policy equality + Social protection policy equality) / 3",
    "10.5 - Improve the regulation and monitoring of global financial markets and institutions and strengthen the implementation of such regulations":"Regulation and Monitoring Effectiveness Index = (Effectiveness of financial market regulation + Effectiveness of financial institution regulation) / 2",
    "10.6 - Ensure enhanced representation and voice for developing countries in decision-making in global international economic and financial institutions in order to deliver more effective, credible, accountable, and legitimate institutions":"Representation and Voice Index = (Representation in decision-making + Voice in decision-making) / 2",
    "10.7 - Facilitate orderly, safe, regular, and responsible migration and mobility of people, including through the implementation of planned and well-managed migration policies":"Migration Policy Effectiveness Index = (Effectiveness of planned migration policies + Effectiveness of managed migration policies) / 2",
    "10.A - Implement the principle of special and differential treatment for developing countries, in particular least developed countries, in accordance with World Trade Organization agreements":"Special and Differential Treatment Implementation Index = (Implementation of special treatment + Implementation of differential treatment) / 2",
    "10.B - Encourage official development assistance and financial flows, including foreign direct investment, to States where the need is greatest, in particular least developed countries, African countries, and small island developing States":"Financial Flows to Neediest States Index = (Official development assistance to neediest states + Foreign direct investment to neediest states) / 2",
    "10.C - By 2030, reduce to less than 3% the transaction costs of migrant remittances and eliminate remittance corridors with costs higher than 5%":"Remittance Transaction Costs Index = (Transaction costs of migrant remittances + Elimination of costly remittance corridors) / 2",
    "11.1 - By 2030, ensure access for all to adequate, safe, and affordable housing and basic services and upgrade slums":"Housing and Basic Services Access Index = (Access to housing + Access to basic services + Slum upgrade progress) / 3",
    "11.2 - By 2030, provide access to safe, affordable, accessible, and sustainable transport systems for all, improving road safety, notably by expanding public transport, with special attention to the needs of those in vulnerable situations, women, children, persons with disabilities, and older persons":"Transport Access and Safety Index = (Access to transport + Affordability of transport + Accessibility of transport + Sustainability of transport + Road safety improvement) / 5",
    "11.3 - By 2030, enhance inclusive and sustainable urbanization and capacity for participatory, integrated, and sustainable human settlement planning and management in all countries":"Urbanization and Settlement Planning Index = (Inclusive urbanization + Sustainable settlement planning + Integrated settlement management) / 3",
    "11.4 - Strengthen efforts to protect and safeguard the world's cultural and natural heritage":"Heritage Protection and Safeguard Index = (Cultural heritage protection + Natural heritage protection) / 2",
    "11.5 - By 2030, significantly reduce the number of deaths and the number of people affected and substantially decrease the direct economic losses relative to global gross domestic product caused by disasters, including water-related disasters, with a focus on protecting the poor and people in vulnerable situations":"Disaster Resilience Index = (Reduction in deaths + Reduction in affected people + Decrease in economic losses relative to global GDP) / 3",
    "11.6 - By 2030, reduce the adverse per capita environmental impact of cities, including by paying special attention to air quality and municipal and other waste management":"Environmental Impact Reduction Index = (Reduction in per capita environmental impact + Air quality improvement + Waste management improvement) / 3",
    "11.7 - By 2030, provide universal access to safe, inclusive, and accessible, green, and public spaces, in particular for women and children, older persons, and persons with disabilities":"Public Space Access Index = (Universal access to safe and inclusive public spaces + Green public space availability) / 2",
    "11.A - Support positive economic, social, and environmental links between urban, peri-urban, and rural areas by strengthening national and regional development planning":"Economic, Social, and Environmental Linkages Strengthening Index = (Economic linkages strengthening + Social linkages strengthening + Environmental linkages strengthening) / 3",
    "11.B - By 2020, substantially increase the number of cities and human settlements adopting and implementing integrated policies and plans towards inclusion, resource efficiency, mitigation, and adaptation to climate change, resilience to disasters, and develop and implement, in line with the Sendai Framework for Disaster Risk Reduction 2015-2030, holistic disaster risk management at all levels":"Integrated Policies and Plans Adoption Index = (Number of cities adopting integrated policies + Number of cities implementing integrated plans + Disaster risk management level of integration) / 3",
    "11.C - Support least developed countries, including through financial and technical assistance, in building sustainable and resilient buildings utilizing local materials":"Support for Sustainable and Resilient Building Index = (Financial assistance to least developed countries + Technical assistance to least developed countries + Sustainable building utilization) / 3",
    "12.1 - Implement the 10-Year Framework of Programmes on Sustainable Consumption and Production Patterns, all countries taking action, with developed countries taking the lead, taking into account the development and capabilities of developing countries":"Sustainable Consumption and Production Index = (Progress in implementing 10-Year Framework + Developed countries' leadership) / 2",
    "12.2 - By 2030, achieve the sustainable management and efficient use of natural resources":"Natural Resource Management Index = (Sustainability of natural resource management + Efficiency in natural resource use) / 2",
    "12.3 - By 2030, halve per capita global food waste at the retail and consumer levels and reduce food losses along production and supply chains, including post-harvest losses":"Food Waste Reduction Index = (Reduction in food waste at retail and consumer levels + Reduction in food losses along production and supply chains) / 2",
    "12.4 - By 2020, achieve the environmentally sound management of chemicals and all wastes throughout their life cycle, in accordance with agreed international frameworks, and significantly reduce their release to air, water, and soil to minimize their adverse impacts on human health and the environment":"Chemical and Waste Management Index = (Management of chemicals and wastes according to international frameworks + Reduction in releases to air, water, and soil) / 2",
    "12.5 - By 2030, substantially reduce waste generation through prevention, reduction, recycling, and reuse":"Waste Reduction and Recycling Index = (Reduction in waste generation + Increase in recycling and reuse) / 2",
    "12.6 - Encourage companies, especially large and transnational companies, to adopt sustainable practices and to integrate sustainability information into their reporting cycle":"Corporate Sustainability Adoption Index = (Adoption of sustainable practices by companies + Integration of sustainability information into reporting) / 2",
    "12.7 - Promote public procurement practices that are sustainable, in accordance with national policies and priorities":"Sustainable Public Procurement Index = (Promotion of sustainable procurement practices + Alignment with national policies and priorities) / 2",
    "12.8 - By 2030, ensure that people everywhere have the relevant information and awareness for sustainable development and lifestyles in harmony with nature":"Sustainable Development Awareness Index = (Relevant information availability + Awareness for sustainable development and lifestyles) / 2",
    "12.A - Support developing countries to strengthen their scientific and technological capacity to move towards more sustainable patterns of consumption and production":"Scientific and Technological Capacity Index = (Strengthening of scientific and technological capacity + Transition to sustainable consumption and production patterns) / 2",
    "12.B - Develop and implement tools to monitor sustainable development impacts for sustainable tourism that creates jobs and promotes local culture and products":"Sustainable Tourism Impact Monitoring Index = (Development and implementation of impact monitoring tools + Job creation and promotion of local culture and products) / 2",
    "13.1 - Strengthen resilience and adaptive capacity to climate-related hazards and natural disasters in all countries":"Resilience and Adaptive Capacity Index = (Strengthening resilience to climate-related hazards + Enhancing adaptive capacity to natural disasters) / 2",
    "13.2 - Integrate climate change measures into national policies, strategies, and planning":"Integration of Climate Change Measures Index = (Integration into national policies + Integration into national strategies + Integration into national planning) / 3",
    "13.3 - Improve education, awareness-raising, and human and institutional capacity on climate change mitigation, adaptation, impact reduction, and early warning":"Climate Change Education and Capacity Index = (Improvement in education + Awareness-raising + Capacity improvement) / 3",
    "13.A - Implement the commitment undertaken by developed-country parties to the United Nations Framework Convention on Climate Change to a goal of mobilizing jointly $100 billion annually by 2020 from all sources to address the needs of developing countries in the context of meaningful mitigation actions and transparency on implementation and fully operationalize the Green Climate Fund through its capitalization as soon as possible":"Climate Finance Commitment Implementation Index = (Mobilization of $100 billion annually by 2020 + Transparency in implementation + Full operationalization of the Green Climate Fund) / 3",
    "13.B - Promote mechanisms for raising capacity for effective climate change-related planning and management in least developed countries and small island developing states, including focusing on women, youth, and local and marginalized communities":"Capacity Building for Climate Change Planning Index = (Capacity building in least developed countries + Capacity building in small island developing states + Focus on women, youth, and local/marginalized communities) / 3",
    "14.1 - By 2025, prevent and significantly reduce marine pollution of all kinds, in particular from land-based activities, including marine debris and nutrient pollution":"Marine Pollution Reduction Index = (Reduction in marine pollution from land-based activities + Reduction in marine debris + Reduction in nutrient pollution) / 3",
    "14.2 - By 2020, sustainably manage and protect marine and coastal ecosystems to avoid significant adverse impacts, including by strengthening their resilience, and take action for their restoration in order to achieve healthy and productive oceans":"Marine Ecosystem Management and Protection Index = (Sustainable management of marine and coastal ecosystems + Protection of marine and coastal ecosystems + Resilience strengthening + Ecosystem restoration action) / 4",
    "14.3 - Minimize and address the impacts of ocean acidification, including through enhanced scientific cooperation at all levels":"Ocean Acidification Impact Mitigation Index = (Minimization of ocean acidification impacts + Enhanced scientific cooperation) / 2",
    "14.4 - By 2020, effectively regulate harvesting and end overfishing, illegal, unreported, and unregulated fishing, and restore fish stocks in the shortest time feasible":"Fisheries Regulation and Restoration Index = (Effective regulation of harvesting and end of overfishing + Control of illegal, unreported, and unregulated fishing + Fish stock restoration timeframe) / 3",
    "14.5 - By 2020, conserve at least 10 percent of coastal and marine areas, consistent with national and international law and based on the best available scientific information":"Marine Conservation Index = (Conservation of coastal and marine areas + Compliance with laws and international agreements + Scientific information utilization) / 3",
    "14.6 - By 2020, prohibit certain forms of fisheries subsidies which contribute to overcapacity and overfishing, and eliminate subsidies that contribute to illegal, unreported, and unregulated fishing, and refrain from introducing new such subsidies, recognizing that appropriate and effective special and differential treatment for developing and least developed countries should be an integral part of the World Trade Organization fisheries subsidies negotiation":"Fisheries Subsidies Elimination Index = (Prohibition of harmful subsidies + Elimination of subsidies contributing to illegal fishing + Non-introduction of new harmful subsidies) / 3",
    "14.7 - By 2030, increase the economic benefits to small island developing states and least developed countries from the sustainable use of marine resources, including through sustainable management of fisheries, aquaculture, and tourism":"Economic Benefits Increase Index = (Economic benefits to small island developing states + Economic benefits to least developed countries + Sustainable resource management in fisheries, aquaculture, and tourism) / 3",
    "14.A - Increase scientific knowledge, develop research capacity, and transfer marine technology in order to improve ocean health and to enhance the contribution of marine biodiversity to the development of developing countries, in particular, small island developing states and least developed countries":"Marine Technology and Research Capacity Index = (Increase in scientific knowledge + Development of research capacity + Marine technology transfer) / 3",
    "14.B - Provide access for small-scale artisanal fishers to marine resources and markets":"Access for Artisanal Fishers Index = (Access to marine resources + Access to markets) / 2",
    "14.C - Enhance the conservation and sustainable use of oceans and their resources by implementing international law as reflected in UNCLOS, which provides the legal framework for the conservation and sustainable use of oceans and their resources, as recalled in paragraph 158 of 'The Future We Want'":"Oceans Conservation and Sustainable Use Index = (Implementation of international law under UNCLOS + Legal framework adherence) / 2",
    "17.1 - Domestic resource mobilization":"Domestic Resource Mobilization Index = (Total domestic revenue / GDP) x 100",
    "17.2 - Official development assistance (ODA) as a percentage of gross national income (GNI)":"ODA as Percentage of GNI = (ODA / GNI) x 100",
    "17.3 - Foreign direct investment (FDI), official development assistance, and remittances":"Foreign Direct Investment (FDI) + Official Development Assistance (ODA) + Remittances",
    "17.4 - Debt service as a percentage of exports of goods and services":"Debt Service as Percentage of Exports = (Debt service payments / Exports of goods and services) x 100"
}



sdg_formulas_mapping = {
    'Maternal Mortality Ratio (MMR)': lambda input_first, input_2nd: (input_first / 100000) * (100000 / input_2nd),
    "Under-5 Mortality Rate (U5MR)": lambda input_first, input_2nd: (input_first / 1000) * (1000 / input_2nd),
    "Neonatal Mortality Rate (NMR)": lambda input_first, input_2nd: (input_first / 1000) * (1000 / input_2nd),
    "Infant Mortality Rate (IMR)": lambda input_first, input_2nd: (input_first / 1000) * (1000 / input_2nd),
    "Prevalence of HIV, TB and Malaria": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "Prevalence of Overweight and Obesity": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "Rate of New HIV Infections": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "Rate of Tuberculosis (TB) Incidence": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "Rate of Malaria Incidence": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "Healthcare Coverage": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "Number of Healthcare Providers": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd / 100000) * 100,
    "Healthcare Expenditure": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "Healthcare Access": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "Healthcare Quality": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "Healthcare Equity": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "4.1.1 Proportion of children and young people (a) in grades 2/3; (b) at the end of primary; and (c) at the end of lower secondary achieving at least a minimum proficiency level in (i) reading and (ii) mathematics, by sex": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "4.2.2 Participation rate in organized learning (one year before the official primary entry age), by sex": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "4.3.1 Participation rate of youth and adults in formal and non-formal education and training in the previous 12 months, by sex": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "5.2.1 Proportion of ever-partnered women and girls aged 15 years and older subjected to physical, sexual or psychological violence by a current or former intimate partner in the previous 12 months, by form of violence and by age": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "5.2.2 Proportion of women and girls aged 15 years and older subjected to sexual violence by persons other than an intimate partner in the previous 12 months, by age and place of occurrence": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "5.5.1 Proportion of seats held by women in (a) national parliaments and (b) local governments": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "6.1.1 - Proportion of population using safely managed drinking water services": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "6.2.1 - Proportion of population using safely managed sanitation services": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "6.3.1 - Proportion of wastewater safely treated": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "6.4.2 - Level of water stress": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "6.B.1 - Proportion of local administrative units with established and operational policies and procedures for participation of local communities in water and sanitation management": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "7.1.1 - Proportion of population with access to electricity": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "7.2.1 - Renewable energy share in the total final energy consumption": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "7.3.1 - Energy intensity measured in terms of primary energy and GDP": lambda input_first, input_2nd: input_first / input_2nd,
    "7.B.1 - Investments in energy efficiency as a percentage of GDP and the amount of foreign direct investment in financial transfers and infrastructure": lambda input_first, input_2nd: (input_first / input_2nd),
    "7.C.1 - Proportion of population with access to clean cooking fuels and technologies": lambda input_first, input_2nd: (input_first / input_2nd) * 100,

    "8.1 - Sustain per capita economic growth in accordance with national circumstances and, in particular, at least 7 per cent gross domestic product growth per annum in the least developed countries": lambda input_first, input_2nd: ((input_first/ input_2nd) - 1) * 100,
    "8.2 - Achieve higher levels of economic productivity through diversification, technological upgrading, and innovation, including through a focus on high-value added and labour-intensive sectors": lambda input_first, input_2nd: input_first /  input_2nd,
    "8.4 - Improve progressively, through 2030, global resource efficiency in consumption and production and endeavour to decouple economic growth from environmental degradation, in accordance with the 10-year framework of programmes on sustainable consumption and production, with developed countries taking the lead": lambda input_first, input_2nd: (input_first /  input_2nd),
    "8.6 - By 2020, substantially reduce the proportion of youth not in employment, education or training": lambda input_first, input_2nd: ((input_first- input_2nd) / input_2nd) * 100,
    "8.C - By 2030, substantially reduce the proportion of youth not in employment, education or training": lambda input_first, input_2nd: ((input_first - input_2nd) / input_2nd) * 100,
    "9.1 - Develop quality, reliable, sustainable, and resilient infrastructure, including regional and transborder infrastructure, to support economic development and human well-being, with a focus on affordable and equitable access for all": lambda input_first, input_2nd, input_3rd, input_4th: (input_first + input_2nd + input_3rd + input_4th) / 4,
    "9.2 - Promote inclusive and sustainable industrialization and, by 2030, significantly raise industry's share of employment and gross domestic product, in line with national circumstances, and double its share in least developed countries": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "9.3 - Increase the access of small-scale industrial and other enterprises, in particular in developing countries, to financial services, including affordable credit, and their integration into value chains and markets": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "9.4 - By 2030, upgrade infrastructure and retrofit industries to make them sustainable, with increased resource-use efficiency and greater adoption of clean and environmentally sound technologies and industrial processes, with all countries taking action in accordance with their respective capabilities": lambda input_first, input_2nd, input_3rd, input_4th: (input_first + input_2nd + input_3rd + input_4th) / 4,
    "9.5 - Enhance scientific research, upgrade the technological capabilities of industrial sectors in all countries, in particular developing countries, including, by 2030, encouraging innovation and substantially increasing the number of research and development workers per 1 million people and public and private research and development spending": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "9.A - Facilitate sustainable and resilient infrastructure development in developing countries through enhanced financial, technological, and technical support to African countries, least developed countries, landlocked developing countries, and small island developing States": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "9.B - Support domestic technology development, research, and innovation in developing countries, including by ensuring a conducive policy environment for, inter alia, industrial diversification and value addition to commodities": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "9.C - Significantly increase access to information and communications technology and strive to provide universal and affordable access to the Internet in least developed countries by 2020": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "10.1 - By 2030, progressively achieve and sustain income growth of the bottom 40% of the population at a rate higher than the national average": lambda input_first, input_2nd: ((input_first/ input_2nd) - 1) * 100,
    "10.2 - By 2030, empower and promote the social, economic, and political inclusion of all, irrespective of age, sex, disability, race, ethnicity, origin, religion, or economic or other status": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "10.3 - Ensure equal opportunity and reduce inequalities of outcome, including by eliminating discriminatory laws, policies, and practices and promoting appropriate legislation, policies, and action in this regard": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "10.4 - Adopt policies, especially fiscal, wage, and social protection policies, and progressively achieve greater equality": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "10.5 - Improve the regulation and monitoring of global financial markets and institutions and strengthen the implementation of such regulations": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "10.6 - Ensure enhanced representation and voice for developing countries in decision-making in global international economic and financial institutions in order to deliver more effective, credible, accountable, and legitimate institutions": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "10.7 - Facilitate orderly, safe, regular, and responsible migration and mobility of people, including through the implementation of planned and well-managed migration policies": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "10.A - Implement the principle of special and differential treatment for developing countries, in particular least developed countries, in accordance with World Trade Organization agreements": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "10.B - Encourage official development assistance and financial flows, including foreign direct investment, to States where the need is greatest, in particular least developed countries, African countries, and small island developing States": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "10.C - By 2030, reduce to less than 3% the transaction costs of migrant remittances and eliminate remittance corridors with costs higher than 5%": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "11.1 - By 2030, ensure access for all to adequate, safe, and affordable housing and basic services and upgrade slums": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "11.2 - By 2030, provide access to safe, affordable, accessible, and sustainable transport systems for all, improving road safety, notably by expanding public transport, with special attention to the needs of those in vulnerable situations, women, children, persons with disabilities, and older persons": lambda input_first, input_2nd, input_3rd, input_4th, input_5th: (input_first + input_2nd + input_3rd + input_4th + input_5th) / 5,
    "11.3 - By 2030, enhance inclusive and sustainable urbanization and capacity for participatory, integrated, and sustainable human settlement planning and management in all countries": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "11.4 - Strengthen efforts to protect and safeguard the world's cultural and natural heritage": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "11.5 - By 2030, significantly reduce the number of deaths and the number of people affected and substantially decrease the direct economic losses relative to global gross domestic product caused by disasters, including water-related disasters, with a focus on protecting the poor and people in vulnerable situations": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "11.6 - By 2030, reduce the adverse per capita environmental impact of cities, including by paying special attention to air quality and municipal and other waste management": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "11.7 - By 2030, provide universal access to safe, inclusive, and accessible, green, and public spaces, in particular for women and children, older persons, and persons with disabilities": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "11.A - Support positive economic, social, and environmental links between urban, peri-urban, and rural areas by strengthening national and regional development planning": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "11.B - By 2020, substantially increase the number of cities and human settlements adopting and implementing integrated policies and plans towards inclusion, resource efficiency, mitigation, and adaptation to climate change, resilience to disasters, and develop and implement, in line with the Sendai Framework for Disaster Risk Reduction 2015-2030, holistic disaster risk management at all levels": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "11.C - Support least developed countries, including through financial and technical assistance, in building sustainable and resilient buildings utilizing local materials": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "12.1 - Implement the 10-Year Framework of Programmes on Sustainable Consumption and Production Patterns, all countries taking action, with developed countries taking the lead, taking into account the development and capabilities of developing countries": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "12.2 - By 2030, achieve the sustainable management and efficient use of natural resources": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "12.3 - By 2030, halve per capita global food waste at the retail and consumer levels and reduce food losses along production and supply chains, including post-harvest losses": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "12.4 - By 2020, achieve the environmentally sound management of chemicals and all wastes throughout their life cycle, in accordance with agreed international frameworks, and significantly reduce their release to air, water, and soil to minimize their adverse impacts on human health and the environment": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "12.5 - By 2030, substantially reduce waste generation through prevention, reduction, recycling, and reuse": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "12.6 - Encourage companies, especially large and transnational companies, to adopt sustainable practices and to integrate sustainability information into their reporting cycle": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "12.7 - Promote public procurement practices that are sustainable, in accordance with national policies and priorities": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "12.8 - By 2030, ensure that people everywhere have the relevant information and awareness for sustainable development and lifestyles in harmony with nature": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "12.A - Support developing countries to strengthen their scientific and technological capacity to move towards more sustainable patterns of consumption and production": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "12.B - Develop and implement tools to monitor sustainable development impacts for sustainable tourism that creates jobs and promotes local culture and products": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "13.1 - Strengthen resilience and adaptive capacity to climate-related hazards and natural disasters in all countries": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "13.2 - Integrate climate change measures into national policies, strategies, and planning": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "13.3 - Improve education, awareness-raising, and human and institutional capacity on climate change mitigation, adaptation, impact reduction, and early warning": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "13.A - Implement the commitment undertaken by developed-country parties to the United Nations Framework Convention on Climate Change to a goal of mobilizing jointly $100 billion annually by 2020 from all sources to address the needs of developing countries in the context of meaningful mitigation actions and transparency on implementation and fully operationalize the Green Climate Fund through its capitalization as soon as possible": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "13.B - Promote mechanisms for raising capacity for effective climate change-related planning and management in least developed countries and small island developing states, including focusing on women, youth, and local and marginalized communities": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "14.1 - By 2025, prevent and significantly reduce marine pollution of all kinds, in particular from land-based activities, including marine debris and nutrient pollution": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "14.2 - By 2020, sustainably manage and protect marine and coastal ecosystems to avoid significant adverse impacts, including by strengthening their resilience, and take action for their restoration in order to achieve healthy and productive oceans": lambda input_first, input_2nd, input_3rd, input_4th: (input_first + input_2nd + input_3rd + input_4th) / 4,
    "14.3 - Minimize and address the impacts of ocean acidification, including through enhanced scientific cooperation at all levels": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "14.4 - By 2020, effectively regulate harvesting and end overfishing, illegal, unreported, and unregulated fishing, and restore fish stocks in the shortest time feasible": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "14.5 - By 2020, conserve at least 10 percent of coastal and marine areas, consistent with national and international law and based on the best available scientific information": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "14.6 - By 2020, prohibit certain forms of fisheries subsidies which contribute to overcapacity and overfishing, and eliminate subsidies that contribute to illegal, unreported, and unregulated fishing, and refrain from introducing new such subsidies, recognizing that appropriate and effective special and differential treatment for developing and least developed countries should be an integral part of the World Trade Organization fisheries subsidies negotiation": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "14.7 - By 2030, increase the economic benefits to small island developing states and least developed countries from the sustainable use of marine resources, including through sustainable management of fisheries, aquaculture, and tourism": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "14.A - Increase scientific knowledge, develop research capacity, and transfer marine technology in order to improve ocean health and to enhance the contribution of marine biodiversity to the development of developing countries, in particular, small island developing states and least developed countries": lambda input_first, input_2nd, input_3rd: (input_first + input_2nd + input_3rd) / 3,
    "14.B - Provide access for small-scale artisanal fishers to marine resources and markets": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "14.C - Enhance the conservation and sustainable use of oceans and their resources by implementing international law as reflected in UNCLOS, which provides the legal framework for the conservation and sustainable use of oceans and their resources, as recalled in paragraph 158 of 'The Future We Want'": lambda input_first, input_2nd: (input_first + input_2nd) / 2,
    "17.1 - Domestic resource mobilization": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "17.2 - Official development assistance (ODA) as a percentage of gross national income (GNI)": lambda input_first, input_2nd: (input_first / input_2nd) * 100,
    "17.3 - Foreign direct investment (FDI), official development assistance, and remittances": lambda input_first, input_2nd, input_3rd: input_first + input_2nd + input_3rd,
    "17.4 - Debt service as a percentage of exports of goods and services": lambda input_first, input_2nd: (input_first / input_2nd) * 100,

}