Data Geek III – Analyzing Crimes against Women in India

Hello everyone,

This is my second submission to the Data Geek III challenge.

In this blog, I am going to analyze crimes against women in India. Safety of women is now a serious concern in India. Police records show high occurrences of crimes against women in the country with a growing trend over years. Women are now more courageous and strong than earlier days to report incidents of crime against them. Still, according to experts, the actual number of incidents is higher than that has been reported.

Allegiance

I have chosen HOUSE OF SPIRITS for this story.

Source of Data

I have collected this data as MS Excel worksheets from http://www.data.gov.in.

Technical Details

I have used SAP Lumira 1.17.1 build 1098 for this analysis.

Analysis

To start the analysis, let me see a trend of various crimes against women in India.

In the above trend, we can see the most occurring crimes in order of number of occurrence are :

1. Cruelty by husband or his relatives
2. Assault to outrage modesty
3. Kidnapping and abduction
4. Rape

Now, let me see a state-wise picture of the same for the year 2012:

In the above analysis, we can see that crime against women is very high in West Bengal and Andhra Pradesh followed by UP and Rajasthan compared to other states. Most of the crimes are occurring because of domestic violence.

Let me create a story covering the analysis so far:

Click on the image for a better view

Now, I want some details on rape cases as that is now a days a burning issue in the country. Very frequently we find news of rape and molestation in the newspapers. I shall analyze the data for 2012 for the rest of my analysis.

Above analysis shows, in Madhya Pradesh, highest number of rape cases have been filed in 2012 while Delhi, the capital of India is in the top among all districts and union territories in India.

50% of total rape victims were women between 18-30 years, while 36% were minors.

In maximum cases, offenders were known to victims.

Men between 18 to 50 years were mainly found guilty of rape cases.

Let me create another story for rape cases in 2012 with help of above visualization.

Click on the image for a better view

Now, let’s see what actions are being taken to prevent crimes against women in India.

I have created two story boards for analyzing the data for 2012:

In the above analysis, we can select one or more crime head and see the number of cases reported during 2012, total cases with charge-sheet and final report submitted, number of cases convicted, total cases for trial for crimes against women, number of cases discharged and number of cases pending trial at end of 2012.

In the above analysis, we can select one or more crime head and see the number of persons arrested during 2012, number of persons released by police, number of person under trial for crime against women and number of persons acquitted.

While government doing duties, good citizen of India also have come forward to protest crimes against women. Recently many times all social medias have been flooded with protests from all kind of people against crimes against women, streets of cities have seen many protest marches. This protest will be continued and we all hope that one day we can make our country a truly safe place for women.