Dataset Overview

The dataset provides a comprehensive look at HIV/AIDS adult prevalence rates, the number of people living with HIV, and annual deaths across different countries. It is based on publicly available data sources such as the CIA World Factbook, UNAIDS AIDS Info, and other global health organizations. The dataset primarily focuses on adult HIV prevalence (ages 15–49) and includes estimates from recent years (e.g., 2023–2024).

Data Science Applications

This dataset can be used for: - Epidemiological Analysis: Understanding the regional distribution of HIV/AIDS and identifying high-prevalence areas. - Predictive Modeling: Developing machine learning models to predict HIV prevalence trends or identify risk factors. - Resource Allocation: Informing policymakers about regions requiring urgent intervention or resource allocation. - Health Outcome Monitoring: Tracking progress in combating HIV/AIDS over time. - Social Determinants Research: Analyzing the relationship between socio-economic factors and HIV prevalence.

Column Descriptors

1. Country/Region: The geographical area being analyzed.
2. Adult Prevalence (%): Percentage of adults aged 15–49 living with HIV.
3. Number of People with HIV/AIDS: Absolute count of individuals living with HIV in the region.
4. Annual Deaths from HIV/AIDS: Number of deaths attributed to HIV/AIDS annually.
5. Year of Estimate: The year when the data was collected or estimated.

Ethically Mined Data

The dataset is ethically sourced from publicly available and credible platforms such as the CIA World Factbook, UNAIDS, and WHO. These organizations ensure transparency and ethical standards in data collection, protecting individual privacy while providing aggregate statistics for research purposes.

Acknowledgments

1. Data Source Platforms:
   • CIA World Factbook
   • UNAIDS AIDS Info
   • WHO Global Health Observatory
2. Dataset Visualization Image:
   • Created using DALL-E 3 for illustrative purposes.
3. Research Support:
   • Contributions from platforms like ResearchGate, NIMH, and others for insights into data science applications in HIV research.

This dataset serves as a valuable tool for researchers, policymakers, and public health professionals in addressing the global challenge of HIV/AIDS.

United States US: Prevalence of HIV: Total: % of Population Aged 15-49 data was reported at 0.500 % in 2014. This stayed constant from the previous number of 0.500 % for 2013. United States US: Prevalence of HIV: Total: % of Population Aged 15-49 data is updated yearly, averaging 0.500 % from Dec 2008 (Median) to 2014, with 7 observations. The data reached an all-time high of 0.500 % in 2014 and a record low of 0.500 % in 2014. United States US: Prevalence of HIV: Total: % of Population Aged 15-49 data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s USA – Table US.World Bank: Health Statistics. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.; ; UNAIDS estimates.; Weighted Average;

Source: The World Bank Last Updated: 10/26/2023 Database: World Development Indicators Series: Prevalence of HIV, total (% of population ages 15-49) Adults (ages 15+) and children (ages 0-14) newly infected with HIV Adults (ages 15-49) newly infected with HIV Antiretroviral therapy coverage (% of people living with HIV) Antiretroviral therapy coverage for PMTCT (% of pregnant women living with HIV) Children (0-14) living with HIV Children (ages 0-14) newly infected with HIV Incidence of HIV, ages 15-24 (per 1,000 uninfected population ages 15-24) Incidence of HIV, ages 15-49 (per 1,000 uninfected population ages 15-49) Incidence of HIV, all (per 1,000 uninfected population) Prevalence of HIV, female (% ages 15-24) Prevalence of HIV, male (% ages 15-24) Women's share of population ages 15+ living with HIV (%) Young people (ages 15-24) newly infected with HIV

https://datacatalog.worldbank.org/public-licenses#cc-by

Context

In the time of epidemics, what is the status of HIV AIDS across the world, where does each country stands, is it getting any better. The data set should be helpful to explore much more about above mentioned factors.

Content

The data set contains data on

1. No. of people living with HIV AIDS
2. No. of deaths due to HIV AIDS
3. No. of cases among adults (19-45)
4. Prevention of mother-to-child transmission estimates
5. ART (Anti Retro-viral Therapy) coverage among people living with HIV estimates
6. ART (Anti Retro-viral Therapy) coverage among children estimates

Acknowledgements / Data Source

• WHO : https://www.who.int/hiv/data/en/
• UNESCO : https://data.unicef.org/resources/dataset/hiv-aids-statistical-tables/

Collection methodology

https://github.com/imdevskp/hiv_aids_who_unesco_data_cleaning

Cover Photo

Photo by Anna Shvets from Pexels https://www.pexels.com/photo/red-ribbon-on-white-surface-3900425/

Similar Datasets

• COVID-19 - https://www.kaggle.com/imdevskp/corona-virus-report
• MERS - https://www.kaggle.com/imdevskp/mers-outbreak-dataset-20122019
• Ebola Western Africa 2014 Outbreak - https://www.kaggle.com/imdevskp/ebola-outbreak-20142016-complete-dataset
• H1N1 | Swine Flu 2009 Pandemic Dataset - https://www.kaggle.com/imdevskp/h1n1-swine-flu-2009-pandemic-dataset
• SARS 2003 Pandemic - https://www.kaggle.com/imdevskp/sars-outbreak-2003-complete-dataset
• HIV AIDS - https://www.kaggle.com/imdevskp/hiv-aids-dataset

Cuba CU: Prevalence of HIV: Total: % of Population Aged 15-49 data was reported at 0.600 % in 2022. This stayed constant from the previous number of 0.600 % for 2021. Cuba CU: Prevalence of HIV: Total: % of Population Aged 15-49 data is updated yearly, averaging 0.200 % from Dec 1990 (Median) to 2022, with 33 observations. The data reached an all-time high of 0.600 % in 2022 and a record low of 0.100 % in 2003. Cuba CU: Prevalence of HIV: Total: % of Population Aged 15-49 data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Cuba – Table CU.World Bank.WDI: Social: Health Statistics. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.;UNAIDS estimates.;Weighted average;

Trinidad and Tobago TT: Prevalence of HIV: Total: % of Population Aged 15-49 data was reported at 1.200 % in 2016. This stayed constant from the previous number of 1.200 % for 2015. Trinidad and Tobago TT: Prevalence of HIV: Total: % of Population Aged 15-49 data is updated yearly, averaging 1.100 % from Dec 1990 (Median) to 2016, with 27 observations. The data reached an all-time high of 1.200 % in 2016 and a record low of 0.100 % in 1990. Trinidad and Tobago TT: Prevalence of HIV: Total: % of Population Aged 15-49 data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Trinidad and Tobago – Table TT.World Bank: Health Statistics. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.; ; UNAIDS estimates.; Weighted Average;

AM: Incidence of HIV: per 1,000 Uninfected Population data was reported at 0.190 Ratio in 2022. This stayed constant from the previous number of 0.190 Ratio for 2021. AM: Incidence of HIV: per 1,000 Uninfected Population data is updated yearly, averaging 0.070 Ratio from Dec 1990 (Median) to 2022, with 33 observations. The data reached an all-time high of 0.190 Ratio in 2022 and a record low of 0.010 Ratio in 1999. AM: Incidence of HIV: per 1,000 Uninfected Population data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Armenia – Table AM.World Bank.WDI: Social: Health Statistics. Number of new HIV infections among uninfected populations expressed per 1,000 uninfected population in the year before the period.;UNAIDS estimates.;Weighted average;This is the Sustainable Development Goal indicator 3.3.1 [https://unstats.un.org/sdgs/metadata/].

HIV prevalence of World remained constant at 0.7 % over the last 3 years. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.

This dataset provides detailed insights into the prevalence of HIV/AIDS among adults (ages 15–49) across various countries and regions. The data is primarily sourced from the CIA World Factbook and the UNAIDS AIDSinfo platform and reflects the most recent available estimates as of 2022–2024.

What’s Included:

Country/Region – The name of each nation or area.

Adult Prevalence of HIV/AIDS (%) – The percentage of adults estimated to be living with HIV.

Number of People with HIV/AIDS – Estimated count of people infected in each country.

Annual Deaths from HIV/AIDS – Estimated number of HIV/AIDS-related deaths per year.

Year of Estimate – The year the data was reported or estimated.

Key Highlights:

Global Prevalence: Around 0.7% of the global population was living with HIV in 2022, affecting nearly 39 million people.

Hotspots: The epidemic is most severe in Southern Africa, with countries like Eswatini, Botswana, Lesotho, and Zimbabwe reporting adult prevalence rates above 20%.

High Burden Countries:

South Africa: 17.3% prevalence, approximately 9.2 million infected

Tanzania: approximately 7.49 million

Mozambique: approximately 2.48 million

Nigeria: approximately 2.45 million (1.3% prevalence)

Notes:

Data may vary in accuracy and is subject to ongoing updates and verification.

Some entries include a dash ("-") where data was not published or available.

Countries with over 1% adult prevalence are categorized under Generalized HIV Epidemics (GHEs) by UNAIDS.

The average for 2022 based on 135 countries was 1.66 percent. The highest value was in Swaziland: 25.9 percent and the lowest value was in Afghanistan: 0.1 percent. The indicator is available from 1990 to 2022. Below is a chart for all countries where data are available.

Among all countries worldwide those in sub-Saharan Africa have the highest rates of HIV. The countries with the highest rates of HIV include Eswatini, South Africa, and Lesotho. In 2024, Eswatini had the highest prevalence of HIV with a rate of around ** percent. Other countries, such as Zimbabwe, have significantly decreased their HIV prevalence. Community-based HIV services are considered crucial to the prevention and treatment of HIV. HIV Worldwide The human immunodeficiency virus (HIV) is a viral infection that is transmitted via exposure to infected semen, blood, vaginal and anal fluids, and breast milk. HIV destroys the human immune system, rendering the host unable to fight off secondary infections. Globally, the number of people living with HIV has generally increased over the past two decades. However, the number of HIV-related deaths has decreased significantly in recent years. Despite being a serious illness that affects millions of people, medication exists that effectively manages the progression of the virus in the body. These medications are called antiretroviral drugs. HIV Treatment Generally, global access to antiretroviral treatment has increased. However, despite being available worldwide, not all adults have access to antiretroviral drugs. There are many different antiretroviral drugs available on the market. As of 2024, ********, an antiretroviral marketed by Gilead, was the leading HIV treatment based on revenue.

Sweden SE: Prevalence of HIV: Female: % Aged 15-24 data was reported at 0.100 % in 2016. This stayed constant from the previous number of 0.100 % for 2015. Sweden SE: Prevalence of HIV: Female: % Aged 15-24 data is updated yearly, averaging 0.100 % from Dec 1990 (Median) to 2016, with 27 observations. The data reached an all-time high of 0.100 % in 2016 and a record low of 0.100 % in 2016. Sweden SE: Prevalence of HIV: Female: % Aged 15-24 data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Sweden – Table SE.World Bank: Health Statistics. Prevalence of HIV, female is the percentage of females who are infected with HIV. Youth rates are as a percentage of the relevant age group.; ; UNAIDS estimates.; Weighted average; In many developing countries most new infections occur in young adults, with young women especially vulnerable.

HIV prevalence among population aged 15-49 of Lao People’s Democratic Republic remained constant at 0.4 % over the last 3 years. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.

HIV prevalence among population aged 15-49 of Chile soared by 16.67% from 0.6 % in 2023 to 0.7 % in 2024. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.

HIV prevalence among population aged 15-49 of Denmark remained constant at 0.1 % over the last 10 years. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.

HIV prevalence among population aged 15-49 of Venezuela (Bolivarian Republic of) remained constant at 0.5 % over the last 10 years. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.

Prevalence of HIV among women of Viet Nam remained constant at 0.1 % over the last 10 years. Prevalence of HIV is the percentage of people who are infected with HIV. Youth rates are as a percentage of the relevant age group.

Prevalence of HIV among men of Lao People’s Democratic Republic remained stable at 0.2 % over the last 10 years. Prevalence of HIV is the percentage of people who are infected with HIV. Youth rates are as a percentage of the relevant age group.

HIV prevalence of Argentina remained constant at 0.4 % over the last 10 years. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.

Introduction

• HIV (human immunodeficiency virus) is a virus that attacks the body's immune system. If HIV is not treated, it can lead to AIDS (acquired immunodeficiency syndrome) which currently has no cure. Once people get HIV, they have it for life. But with proper medical care, HIV can be controlled. Symptoms: Influenza-like illness; Fatigue… Treatments: Management of HIV/AIDS Type of infectious agent: Virus (Human Immunodeficiency Virus) • AIDS (acquired immune deficiency syndrome) is the name used to describe a number of potentially life-threatening infections and illnesses that happen when one’s immune system has been severely damaged by the HIV virus. While AIDS cannot be transmitted from 1 person to another, the HIV virus can.

Dataset

The data set contains data of the following:- 1. The top causes of deaths in the world 2. Total number of deaths due to HIV/AIDS 3. ART (Anti Retro-viral Therapy) coverage among people living with HIV 4. Knowledge among young citizens (15-24years) about HIV/AIDS 5. Population of HIV/AIDS patients living with TB and their death rate 6. Life expectancy rate among HIV/AIDS patients 7. HIV/AIDS Patients in different age groups 8. Women population living with HIV 9. Young women in India having the knowledge of HIV/AIDS 10. HIV/AIDS deaths in Indian states

Data was scrapped from the official website of UNICEF -https://data.unicef.org/ and https://data.gov.in/

Ask Phase

• Data gives the trend of increasing no. of HIV/AIDS patients across the world • The information available for each country is percentage of total Global AIDS patients • Time period traced is 2000-2019 • Key Questions to answer:  Which countries and regions are affected the most?  How are the different age groups affected?  How much is the ART (Anti Retro-viral Therapy) coverage among the patients and what is the life expectancy rate?  What percentage of the population is aware of the prevention and causes of HIV/AIDS

Prepare phase.

• By tabulating and filtering the data the required data was obtained to bring out observations. • Data was formatted to the desired format to perform further calculations. • Sorting of data region wise. • Columns with inconsistent and empty cells were deleted. • The data of India was extracted for further analysis • Duplicate entries and undesired data was removed

Process phase

For cleaning the dataset for further analysis MS Excel was used due to small data. • Used sumifs() functions to aggregate the data region wise • Used sumif() to segregate the no. of patients within different age groups • Used sumifs() to find the total number of TB patients among HIV deaths. • Used countif() to find the percentage of male and female patients. • Sorted data to find the top and bottom nation with most and least HIV/AIDS patients

Analyze phase

• Formed the following pivot tables to answer key target questions  Year v/s number of death rates  Country v/s death numbers to bring out nation wise deaths  Causes of death v/s the number of deaths to bring at which position AIDS causes causality  Year v/s percentage of life expectancy to observe the pattern of no. of survivors

Visualization phase

The data was visualized using Tableau.

Presentaion

The final presentation was prepared by accumulating all observations and inferences which is linked below https://docs.google.com/presentation/d/1NEX10Vz5u5Va3CrTLVbvsUHZjO-fn8EOeiOHkP03T3Q/edit?usp=sharing