In [ ]:
In [1]:
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
/var/folders/gc/0752xrm56pnf0r0dsrn5370c0000gr/T/ipykernel_70616/555797462.py:1: DeprecationWarning: Pyarrow will become a required dependency of pandas in the next major release of pandas (pandas 3.0), (to allow more performant data types, such as the Arrow string type, and better interoperability with other libraries) but was not found to be installed on your system. If this would cause problems for you, please provide us feedback at https://github.com/pandas-dev/pandas/issues/54466 import pandas as pd
In [2]:
#Loading the dataset
data = pd.read_csv("Death_rates_for_suicide__by_sex__race__Hispanic_origin__and_age__United_States.csv")
In [ ]:
In [3]:
# Filter the dataset to include males who are American Indian or Alaska Native or African American between the ages of 25-44 years and the years 1950 and 1984
American_Indian_or_Alaska_Native_Male_Data = data[(data['STUB_LABEL'].str.contains('Male: American Indian or Alaska Native')) &
(data['YEAR'].between(1985, 2018))]
# Display the filtered dataset including the INDICATOR, UNIT, AGE, YEAR, and ESTIMATE columns
American_Indian_or_Alaska_Native_Male_Data[['INDICATOR', 'UNIT', 'STUB_LABEL', 'AGE', 'YEAR', 'ESTIMATE']]
Out[3]:
INDICATOR | UNIT | STUB_LABEL | AGE | YEAR | ESTIMATE | |
---|---|---|---|---|---|---|
429 | Death rates for suicide | Deaths per 100,000 resident population, crude | Male: American Indian or Alaska Native: 15-24 ... | 15-24 years | 1985 | 42.0 |
430 | Death rates for suicide | Deaths per 100,000 resident population, crude | Male: American Indian or Alaska Native: 15-24 ... | 15-24 years | 1986 | NaN |
431 | Death rates for suicide | Deaths per 100,000 resident population, crude | Male: American Indian or Alaska Native: 15-24 ... | 15-24 years | 1987 | NaN |
432 | Death rates for suicide | Deaths per 100,000 resident population, crude | Male: American Indian or Alaska Native: 15-24 ... | 15-24 years | 1988 | 41.8 |
433 | Death rates for suicide | Deaths per 100,000 resident population, crude | Male: American Indian or Alaska Native: 15-24 ... | 15-24 years | 1989 | 43.7 |
... | ... | ... | ... | ... | ... | ... |
541 | Death rates for suicide | Deaths per 100,000 resident population, crude | Male: American Indian or Alaska Native: 45-64 ... | 45-64 years | 2013 | 18.3 |
542 | Death rates for suicide | Deaths per 100,000 resident population, crude | Male: American Indian or Alaska Native: 45-64 ... | 45-64 years | 2014 | 15.1 |
543 | Death rates for suicide | Deaths per 100,000 resident population, crude | Male: American Indian or Alaska Native: 45-64 ... | 45-64 years | 2015 | 20.8 |
544 | Death rates for suicide | Deaths per 100,000 resident population, crude | Male: American Indian or Alaska Native: 45-64 ... | 45-64 years | 2016 | 19.8 |
545 | Death rates for suicide | Deaths per 100,000 resident population, crude | Male: American Indian or Alaska Native: 45-64 ... | 45-64 years | 2017 | 19.7 |
101 rows × 6 columns
In [4]:
American_Indian_or_Alaska_Native_Female_Data = data[(data['STUB_LABEL'].str.contains('Female: American Indian or Alaska Native')) &
(data['AGE'] == '25-44 years') &
(data['YEAR'].between(1985, 2018))]
American_Indian_or_Alaska_Native_Female_Data[['INDICATOR', 'UNIT', 'STUB_LABEL', 'AGE', 'YEAR', 'ESTIMATE']]
Out[4]:
INDICATOR | UNIT | STUB_LABEL | AGE | YEAR | ESTIMATE | |
---|---|---|---|---|---|---|
975 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1985 | NaN |
976 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1986 | NaN |
977 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1987 | NaN |
978 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1988 | 6.9 |
979 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1989 | NaN |
980 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1990 | NaN |
981 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1991 | 5.8 |
982 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1992 | 5.6 |
983 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1993 | 6.6 |
984 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1994 | NaN |
985 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1995 | 6.4 |
986 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1996 | 8.0 |
987 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1997 | 5.6 |
988 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1998 | 6.8 |
989 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 1999 | 6.8 |
990 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2000 | 7.2 |
991 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2001 | 6.0 |
992 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2002 | 5.4 |
993 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2003 | 4.3 |
994 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2004 | 8.9 |
995 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2005 | 6.6 |
996 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2006 | 6.9 |
997 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2007 | 5.8 |
998 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2008 | 6.2 |
999 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2009 | 7.5 |
1000 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2010 | 7.4 |
1001 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2011 | 7.8 |
1002 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2012 | 6.6 |
1003 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2013 | 7.5 |
1004 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2014 | 9.7 |
1005 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2015 | 8.8 |
1006 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2016 | 10.7 |
1007 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2017 | 12.1 |
1008 | Death rates for suicide | Deaths per 100,000 resident population, crude | Female: American Indian or Alaska Native: 25-4... | 25-44 years | 2018 | 10.8 |
What the code below does:¶
It visualizes the suicide estimates over time for American Indian or Alaska Native males and females, by creating a single plot showing all the suicide estimates over time, categorized by age.
In [5]:
# Create a single plot
plt.figure(figsize=(12, 8))
# Define colors for each age category
colors = ['blue', 'green', 'red', 'orange', 'purple', 'cyan', 'magenta', 'yellow', 'lime', 'pink']
# Plot line plots for each age category for American Indian or Alaska Native Males
for i, age_category in enumerate(['15-24 years', '25-44 years', '45-64 years', '65-74 years', '75-84 years']):
# Filter data for American Indian or Alaska Native Males of the current age category
male_data = American_Indian_or_Alaska_Native_Male_Data[American_Indian_or_Alaska_Native_Male_Data['AGE'] == age_category]
# Plot line plot for American Indian or Alaska Native Males of the current age category with a different color
plt.plot(male_data['YEAR'], male_data['ESTIMATE'], color=colors[i], marker='o', label=f'American Indian or Alaska Native Males ({age_category})')
# Plot line plots for each age category for American Indian or Alaska Native Females
for i, age_category in enumerate(['15-24 years', '25-44 years', '45-64 years', '65-74 years', '75-84 years']):
# Filter data for American Indian or Alaska Native Females of the current age category
female_data = American_Indian_or_Alaska_Native_Female_Data[American_Indian_or_Alaska_Native_Female_Data['AGE'] == age_category]
# Plot line plot for American Indian or Alaska Native Females of the current age category with a different color
plt.plot(female_data['YEAR'], female_data['ESTIMATE'], color=colors[i+len(colors)//2], marker='o', linestyle='--', label=f'American Indian or Alaska Native Females ({age_category})')
# Set titles and labels
plt.title('Suicide Estimates Over Time for American Indian or Alaska Native Males and Females by Age Category')
plt.xlabel('Year')
plt.ylabel('Suicide Estimate (% per 100,000 resident population)')
# Add legend
plt.legend()
# Show the plot
plt.grid(True)
plt.tight_layout()
plt.show()