Skip to Content
Author's profile photo Kiran Kumar Valluru

Data Geek Challenge – Analysis of Agriculture Farmer Suicides in India

India is an agrarian country with around 60% of its people depending directly or indirectly upon agriculture. Agriculture in India is often attributed as gambling with monsoons because of its almost exclusive dependency on precipitation from monsoons. The failure of these monsoons can lead to a series of droughts, lack of better prices, and exploitation of the farmers by middlemen, all of which have led to a series of suicides committed by farmers across India.

I have used SAP Lumira for the first time to analyze the Farmer Suicides in India.

I got the data from NCRB(National Crime Records Bureau) http://ncrb.nic.in/ by searching the previous year suicide records available at: http://ncrb.nic.in/adsi/main.htm

I saved the data in excel sheet and loaded it to SAP Lumira.

1.JPG

After loading the data I have created the necessary measures.

/wp-content/uploads/2013/08/2_267966.jpg

Year Wise Analysis:

Below are the Year Wise analysis of Farmer Suicides from 1999 to 2011 in different Age groups.

Column Chart:
3.JPG

Line Chart:

4.JPG

From the above 2 charts we can observe that the number of Farmers committing suicides in Age group 30-44 Years are more than other Age Groups. However the sad thing is children below age 14 years also committing suicides!

Are children (below age 14 years, who don’t know what life is) really committing suicides? I don’t call it a suicide rather it is a murder. Also the reason for Female farmer suicides and Children Suicides (Murder) are the inability or the fear of survival with out the Breadwinner!

Gender Wise Analysis:

Column Chart:

9.JPG

3D Column Chart:

10.JPG

Line Chart:

12.JPG

From the above charts we can observe that the number of Male Farmers committing suicides are more that the number of Female Farmers.

State Wise Analysis:

Here I have chosen the big 5 states for analysis as more that 51% of Farmers committing suicides are from these states.

Line Chart:

7.JPG

3D Line Chart:

8.JPG

Geo Chart:

5.JPG

      * Madhya Pradesh = Madhya Pradesh + Chattishgarh ( Chattishgarh was partitioned from Madhya Pradesh in the year 2000)

Pie Chart:

6.JPG

From the above charts we can observe that the number of Farmers committing suicides is more in Maharashtra state.

Also we can observe most of the Farmer suicides happening in the Cotton growing States.

Indebtedness is the major reason behind the farmer suicides. The number of farmers committing suicides in Andhra Pradesh has slightly reduced from 2005 as the Andhra Pradesh State Government has cleared the Agriculture loans of farmers.

Usually, a farmer is the only earning member in his family; his death leaves his family in destitution. Government should take enough measures to prevent suicides of farmers. If the issue remains unaddressed it is a large possibility that India would soon emerge as a food deficient country.

Finishing:

It took just10 minutes to analyze the above data using SAP Lumira. SAP Lumira is one of the most simple and powerful tool I have ever used for analyzing and predicting data in different ways.

Assigned tags

      19 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jitendra Kansal
      Jitendra Kansal

      Hi Kiran,

      Your choice is very sensitive but fact is fact.

      great analysis. 🙂

      Rgrds,

      Jitendra

      Author's profile photo Kiran Kumar Valluru
      Kiran Kumar Valluru
      Blog Post Author

      Thank you Jitendra!

      Cheers,

      Kiran

      Author's profile photo Kishore Kumar Reddy Valluru
      Kishore Kumar Reddy Valluru

      Dear Brother,

      Excellent analysis and awesome article.

      I wish U all the best for ur up-coming articles.

      All the best once again.

      Regards,

      Kishore Valluru

      Author's profile photo Kiran Kumar Valluru
      Kiran Kumar Valluru
      Blog Post Author

      Thanks for the support and encouragement!

      Author's profile photo Former Member
      Former Member

      Good Analysis....

      Best Regards,

      Naresh K.

      Author's profile photo Kiran Kumar Valluru
      Kiran Kumar Valluru
      Blog Post Author

      Thank You Naresh!

      Author's profile photo Jason Lax
      Jason Lax

      It's a sad and frustrating topic yet using graphics like this to highlight significant social issues can be very powerful.  I think I would have liked to see narrower age sets: 14 years seems to broad.

      I wonder if there's a way to correlate this data with education rates and other indicators that are influenced by local governments?

      Author's profile photo Kiran Kumar Valluru
      Kiran Kumar Valluru
      Blog Post Author

      Thank you Jason!

      I wonder if there's a way to correlate this data with education rates and other indicators that are influenced by local governments?

      Yes. But no direct relational data available. We can show in separate graphs indicating that the rise in literacy rate corresponds to a decrease in the number of suicides. Yet there are so many other factors like monsoons, power, water, providing good quality seeds... etc.,

      Local Government should take enough measures to reduce the rate of farmer suicides like providing Power, Low rate interests on debts and good quality seeds/ fertilizers/ pesticides etc.,

      When there is a loss in crop production, farmers won't think that Life is Important and Life of Persons who depend on them is more important!. They just fear of survival and indebtedness and commit suicides ( some times total family ).

      If the Government provides some support to those families this rate of farmer suicides will reduce.

      Regards,

      Kiran

      Author's profile photo Jason Lax
      Jason Lax

      There are many factors and there's no single solution to this problem: the power of visual analytics is that anyone can see the correlation between data and grasp how the factors affect one another +/-. This helps those in charge make more effective decisions on where to allocation resources on activities they can control, such as improving literacy, training on better farming practices, providing better materials and making low interest rate loans available.

      Author's profile photo Kiran Kumar Valluru
      Kiran Kumar Valluru
      Blog Post Author

      Yes Jason. Well Said! But the sad thing is, the ministers don't care about these and they just care about filling up their pockets!

      If they use the power of visual analytics and try to show little care about people as you said, a huge change can be seen!

      Author's profile photo Muthukumareshan vijayan
      Muthukumareshan vijayan

      Hi ,

      Good and Excellent analysis ,

      Thanks

      Muthu

      Author's profile photo Kiran Kumar Valluru
      Kiran Kumar Valluru
      Blog Post Author

      Thank You!

      Author's profile photo Former Member
      Former Member

      Dear Kiran,

      Thanks for the review.

      Regards

      Valluru

      Author's profile photo Janarthanan Elangovan
      Janarthanan Elangovan

      Hi Kiran,

      Thanks for sharing this article, very good analysis,

      Government should take enough measures to prevent suicides of farmers. If the issue remains unaddressed it is a large possibility that India would soon emerge as a food deficient country.

      its true and sad one...!

      Best Regards,

      Jana

      Author's profile photo Kiran Kumar Valluru
      Kiran Kumar Valluru
      Blog Post Author

      Thank You!

      Author's profile photo Former Member
      Former Member

      Hi Kiran,

      Good Day!

      Very nice blog! Valuable information!

      Keep posting good info like this. It will helps us to understand the exact info.

      Have a nice day!

      Regards,

      Hari Suseelan

      Author's profile photo Kiran Kumar Valluru
      Kiran Kumar Valluru
      Blog Post Author

      Thank You!

      Author's profile photo Chandan Sinha
      Chandan Sinha

      Hope some Ministers look at this report. Good Analysis for India's farmers.

      Author's profile photo Eduardo Rezende
      Eduardo Rezende

      Good analysis blog.

      Sad fact.