District Level Report Panch Mahals

Author

Ayush Patel

Published

August 23, 2022

Introduction - Panch Mahals

This report aims to provide a birds eye view of the district through the lens of village amenities data released by census in 2011. Before moving towards the descriptive insights from the census data, here is what pops up when a search is executed for Panch Mahals district Gujarat on wikipedia.



Summary Statistics

Total Number of Villages: 1210

Total Number of Gram Panchayat: 642

Total Number of Sub Districts: 11

Total Population : 2.055949^{6}

Statistical Summaries at the subdistrict level

Sub District Total Population Total SC Population Total ST Population Total Area of Vilalges Total Area Sown (Net)
Ghoghamba 218467 5018 90694 50199.37 32419.43
Godhra 300080 14566 50907 72259.81 47489.41
Halol 173694 4005 61628 49497.99 30788.34
Jambughoda 42476 562 15112 12126.57 6557.71
Kadana 129545 5243 101299 41100.83 20040.77
Kalol 183839 12311 21936 38981.70 27630.62
Khanpur 96041 5247 13193 32245.43 17245.82
Lunawada 220274 14805 18842 60788.97 40006.07
Morwa (Hadaf) 186920 4397 71906 32168.83 20565.87
Santrampur 246229 5903 208745 56257.19 29509.94
Shehera 258384 11025 43314 59213.22 32553.47

Population and Geographical Area

It is of interest to look into which are the most densely populated villages. We can do this by creating a simple scatter plot between population of village and the total geographical area of a village.


Irrigation for Agriculture

The census provides the net area sown (hectares) in a village along with area irrigated with water source in hectares. The area under irrigation may be affected by several factors.

Area Sown vs Area under Irrigation


A distribution for the percentage of area irrigated will be interesting to look at.

Understanding what drives area under irrigation

Much is heard about rain fed agriculture in India. There are several factors that can affect area under irrigation - ranging from government supports, demographics, distance from urban clusters and several known and unknown variables. With the given data we can check if the following variables have any relation with area under irrigation:

  • Percentage of Marginalised group population in village
  • Distance from Major government offices
  • Distance from urban center
  • Total population of a village

A simple Linear regression to see if the above explanation has any merit

Dependent variable:
perc_irrigated_over_net_sown
total_population_of_village -0.0002
(0.0005)
perc_marginalised_pop -0.089***
(0.028)
district_head_quarter_distance_in_km 0.016
(0.068)
sub_district_head_quarter_distance_in_km -0.135
(0.112)
nearest_statutory_town_distance_in_km -0.021
(0.111)
sub_district_nameGodhra -2.535
(4.015)
sub_district_nameHalol -7.154*
(4.035)
sub_district_nameJambughoda 1.930
(5.286)
sub_district_nameKadana 8.224*
(4.686)
sub_district_nameKalol 10.667**
(4.409)
sub_district_nameKhanpur -19.232***
(4.558)
sub_district_nameLunawada 12.184***
(3.651)
sub_district_nameMorwa (Hadaf) 15.635***
(4.840)
sub_district_nameSantrampur -5.406
(4.468)
sub_district_nameShehera -5.714
(4.049)
Constant 28.303***
(4.086)
Observations 1,185
R2 0.138
Adjusted R2 0.127
Residual Std. Error 26.018 (df = 1169)
F Statistic 12.436*** (df = 15; 1169)
Note: p<0.1; p<0.05; p<0.01

Model Diagnostic plots

Distribution of Redsiduals


Residuals vs Fitted

Note

This is to serve as a minimal example of creating parameterised reports with .rmd/.qmd files. This document is in no way analytically or statistically rigorous.