Global Suicide Rate Insight

Global Suicide Rate Insight

Webscapping the Global suicide rate data using Python jupyter notebook

Step 1 : Create a new folder on your desktop and Download anaconda from Google Chrome and install it on your PC then you write the above code and run using 'Alt + enter key '

NB : make sure you locate the new folder you created using jupyter notebook. Folder name can be 'suicide'

NB : also make sure that you have kaggle account in order to have access to your api key and switch on your internet connection

Link to suicide data : kaggle.com/datasets/russellyates88/suicide-..

one.jpeg

two.jpeg

first second.jpeg

Step 2 : we opened our Microsoft powerBi and connected to the suicide rate dataset we scrapped from kaggle which is 'master.csv' and clicked the 'ok' button

Data cleaning

four.jpeg

Step 3 : we went to the column tool and converted the country column data category to country for map visual

seven.jpeg

Step 4 : we created a pie chart to show the suicide rate by gender and we noticed that there is high rate of suicide among the males than the females

76.89% for males and 23.11% for females

pie chart.jpeg

Step 5 : we also created a clustered column chart to show the suicide rate per generation and we as well noticed that the boomers generation are commiting more suicide than any other generation

five.jpeg

Step 6 : we also wanted to see the suicide rate between different age range so we created a line chart to depict this and we discovered that age range between 35 - 54 years old have high rate of suicide

lines.jpeg

Step 7 : we decided to show the total number of suicide per year using the clustered column chart and noticed that the year 1999 has the highest number of suicide rate

six.jpeg

Step 8 : we created a map visual but we noticed the map won't show until we enable the above settings and restart the powerBi

N.B : click on the file tab and select option setting

N.B : save your powerBi before restarting

eight.jpeg

Step 9 : we successfully created a map visual to show the country with the highest rate of suicide but discovered that the Russian Federation has the highest suicide rate.

last.jpeg