Effect of suicide rates on life expectancy dataset

Abstract
In 2015, approximately 55 million people died worldwide, of which 8 million committed suicide. In the USA, one of the main causes of death is the aforementioned suicide, therefore, this experiment is dealing with the question of how much suicide rates affects the statistics of average life expectancy.
The experiment takes two datasets, one with the number of suicides and life expectancy in the second one and combine data into one dataset. Subsequently, I try to find any patterns and correlations among the variables and perform statistical test using simple regression to confirm my assumptions.

Data

The experiment uses two datasets - WHO Suicide Statistics[1] and WHO Life Expectancy[2], which were firstly appropriately preprocessed. The final merged dataset to the experiment has 13 variables, where country and year are used as index: Country, Year, Suicides number, Life expectancy, Adult Mortality, which is probability of dying between 15 and 60 years per 1000 population, Infant deaths, which is number of Infant Deaths per 1000 population, Alcohol, which is alcohol, recorded per capita (15+) consumption, Under-five deaths, which is number of under-five deaths per 1000 population, HIV/AIDS, which is deaths per 1 000 live births HIV/AIDS, GDP, which is Gross Domestic Product per capita, Population, Income composition of resources, which is Human Development Index in terms of income composition of resources, and Schooling, which is number of years of schooling.

LICENSE

THE EXPERIMENT USES TWO DATASET - WHO SUICIDE STATISTICS AND WHO LIFE EXPECTANCY, WHICH WERE COLLEECTED FROM WHO AND UNITED NATIONS WEBSITE. THEREFORE, ALL DATASETS ARE UNDER THE LICENSE ATTRIBUTION-NONCOMMERCIAL-SHAREALIKE 3.0 IGO (https://creativecommons.org/licenses/by-nc-sa/3.0/igo/).

[1] https://www.kaggle.com/szamil/who-suicide-statistics

[2] https://www.kaggle.com/kumarajarshi/life-expectancy-who

Over *** thousand deaths due to suicides were recorded in India in 2022. Furthermore, majority of suicides were reported in the state of Tamil Nadu, followed by Rajasthan. The number of suicides that year had increased from the previous year. Some of the causes for suicides in the country were due to professional problems, abuse, violence, family problems, financial loss, sense of isolation and mental disorders. Depressive disorders and suicide As of 2015, over ****** million people worldwide suffered from some kind of depressive disorder. Furthermore, over ** percent of the total population in India suffer from different forms of mental disorders as of 2017. There exists a positive correlation between the number of suicide mortality rates and people with select mental disorders as opposed to those without. Risk factors for mental disorders Every ******* person in India suffers from some form of mental disorder. Today, depressive disorders are regarded as the leading contributor not only to disease burden and morbidity worldwide, but even suicide if not addressed. In 2022, the leading cause for suicide deaths in India was due to family problems. The second leading cause was due to illness. Some of the risk factors, relative to developing mental disorders including depressive and anxiety disorders, include bullying victimization, poverty, unemployment, childhood sexual abuse and intimate partner violence.

BackgroundAbout 1 million people worldwide commit suicide each year, and college students with suicidal ideation are at high risk of suicide. The prevalence of suicidal ideation in college students has been estimated extensively, but quantitative syntheses of overall prevalence are scarce, especially in China. Accurate estimates of prevalence are important for making public policy. In this paper, we aimed to determine the prevalence of suicidal ideation in Chinese college students.Objective and MethodsDatabases including PubMed, Web of Knowledge, Chinese Web of Knowledge, Wangfang (Chinese database) and Weipu (Chinese database) were systematically reviewed to identify articles published between 2004 to July 2013, in either English or Chinese, reporting prevalence estimates of suicidal ideation among Chinese college students. The strategy also included a secondary search of reference lists of records retrieved from databases. Then the prevalence estimates were summarized using a random effects model. The effects of moderator variables on the prevalence estimates were assessed using a meta-regression model.ResultsA total of 41 studies involving 160339 college students were identified, and the prevalence ranged from 1.24% to 26.00%. The overall pooled prevalence of suicidal ideation among Chinese college students was 10.72% (95%CI: 8.41% to 13.28%). We noted substantial heterogeneity in prevalence estimates. Subgroup analyses showed that prevalence of suicidal ideation in females is higher than in males.ConclusionsThe prevalence of suicidal ideation in Chinese college students is relatively high, although the suicide rate is lower compared with the entire society, suggesting the need for local surveys to inform the development of health services for college students.

The indicator measures the number of deaths that result from suicide per 100 000 inhabitants. The World Health Organization defines suicide as an act deliberately initiated and performed by a person in the full knowledge or expectation of its fatal outcome. Data on causes of death (COD) refer to the underlying cause which - according to the World Health Organisation (WHO) - is "the disease or injury which initiated the train of morbid events leading directly to death, or the circumstances of the accident or violence which produced the fatal injury". COD data are derived from death certificates. The medical certification of death is an obligation in all Member States. The data are presented as standardised death rates, meaning they are adjusted to a standard age distribution in order to measure death rates independently of different age structures of populations. This approach improves comparability over time and between countries. The standardised death rates used here are calculated on the basis of a standard European population. The number of suicides in certain countries may be under-reported because of the stigma associated with the act for religious, cultural or other reasons. The comparability of suicide data between countries is also affected by a number of reporting criteria, including how a person’s intention of killing him- or herself is ascertained or who is responsible for completing the death certificate. The product has been discontinued since: 29 Nov 2018.

Every year the CDC releases the country’s most detailed report on death in the United States under the National Vital Statistics Systems. This mortality dataset is a record of every death in the country for 2005 through 2015, including detailed information about causes of death and the demographic background of the deceased.

It's been said that "statistics are human beings with the tears wiped off." This is especially true with this dataset. Each death record represents somebody's loved one, often connected with a lifetime of memories and sometimes tragically too short.

Putting the sensitive nature of the topic aside, analyzing mortality data is essential to understanding the complex circumstances of death across the country. The US Government uses this data to determine life expectancy and understand how death in the U.S. differs from the rest of the world. Whether you’re looking for macro trends or analyzing unique circumstances, we challenge you to use this dataset to find your own answers to one of life’s great mysteries.

Overview

This dataset is a collection of CSV files each containing one year's worth of data and paired JSON files containing the code mappings, plus an ICD 10 code set. The CSVs were reformatted from their original fixed-width file formats using information extracted from the CDC's PDF manuals using this script. Please note that this process may have introduced errors as the text extracted from the pdf is not a perfect match. If you have any questions or find errors in the preparation process, please leave a note in the forums. We hope to publish additional years of data using this method soon.

A more detailed overview of the data can be found here. You'll find that the fields are consistent within this time window, but some of data codes change every few years. For example, the 113_cause_recode entry 069 only covers ICD codes (I10,I12) in 2005, but by 2015 it covers (I10,I12,I15). When I post data from years prior to 2005, expect some of the fields themselves to change as well.

All data comes from the CDC’s National Vital Statistics Systems, with the exception of the Icd10Code, which are sourced from the World Health Organization.

Project ideas

• The CDC's mortality data was the basis of a widely publicized paper, by Anne Case and Nobel prize winner Angus Deaton, arguing that middle-aged whites are dying at elevated rates. One of the criticisms against the paper is that it failed to properly account for the exact ages within the broad bins available through the CDC's WONDER tool. What do these results look like with exact/not-binned age data?
• Similarly, how sensitive are the mortality trends being discussed in the news to the choice of bin-widths?
• As noted above, the data preparation process could have introduced errors. Can you find any discrepancies compared to the aggregate metrics on WONDER? If so, please let me know in the forums!
• WONDER is cited in numerous economics, sociology, and public health research papers. Can you find any papers whose conclusions would be altered if they used the exact data available here rather than binned data from Wonder?

Differences from the first version of the dataset

• This version of the dataset was prepared in a completely different many. This has allowed us to provide a much larger volume of data and ensure that codes are available for every field.
• We've replaced the batch of sql files with a single JSON per year. Kaggle's platform currently offer's better support for JSON files, and this keeps the number of files manageable.
• A tutorial kernel providing a quick introduction to the new format is available here.
• Lastly, I apologize if the transition has interrupted anyone's work! If need be, you can still download v1.

this graph was created in OurDataWorld:

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F16731800%2F890ca83cc43ed9a357bcb81b13bc5a59%2Fgraph1.png?generation=1721685146443911&alt=media" alt=""> https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F16731800%2F649d320a96a8c73ddddf24307c4f70f4%2Fgraph2.png?generation=1721685151066961&alt=media" alt=""> https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F16731800%2F0ac0a8cce50ad97f2f595b8048546fd0%2Fgraph3.png?generation=1721685156829214&alt=media" alt="">

Extreme heat has major impacts on human wellbeing: it makes it harder for kids to learn at school, reduces the productivity of outdoor workers, and puts pressure on healthcare systems. In the worst case, it kills.

This is already an issue — particularly for countries in the tropics — but will become even more critical as the world warms. This article is the third in my series on extreme heat. In my previous articles, I looked at how many die from extreme temperatures today and how climate change could affect this in the future. In many of the world’s poorest countries, deaths are expected to increase if we don’t invest more in adaptation.

Protecting people from extreme heat will require blending the old and the new. Technological solutions like air conditioning (AC) will be essential, but relying on them alone would be a mistake.

The availability and affordability of AC is — and will continue to be — highly unequal, leaving the poorest households unable to protect themselves. It’s also not a solution for those who work outdoors in agriculture, construction, or as street sellers. This is the reality for most people in tropical countries, where heatwaves will be most extreme.

The goal, then, is to build communities and cities more resilient to heat through urban planning, communication, and emergency responses.

We can learn a lot from our ancestors, who learned how to build cities and design lifestyles that could cope with scorching summers and intense heat waves. That will not be enough in a warming world, but it’s a starting point to build new solutions.

Go to the old parts of many cities, and you’ll find yourself walking through narrow streets. This helps to keep them cool. The ground and the walls of the houses are only exposed to the sun for a short period of the day when the rays come from directly above. Wider streets are in direct sunlight for long periods, absorbing large amounts of heat. Cul-de-sacs also form heat barriers, so they’re more common, too.

Seville in Spain is a perfect example of this. It’s one of Europe’s hottest cities and is often hit by extreme heat. Older parts of the city — stretching back to the Middle Ages — were designed with these natural cooling techniques in mind. It has small squares where people can find shade, communal fountains for people to keep cool, and trees and vegetation line the streets, where people can find shade. Newer parts weren’t designed like this: they often have large, wide avenues that can reach baking temperatures in the summer.

Lifestyles in Seville have also been adapted to deal with the heat. People stay indoors until the evening; the city comes to life only then. Afternoon siestas are normal for rest and shelter.