District Level Report Bharuch

Author

Ayush Patel

Published

August 23, 2022

Introduction - Bharuch

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 Bharuch district Gujarat on wikipedia.



Summary Statistics

Total Number of Villages: 653

Total Number of Gram Panchayat: 540

Total Number of Sub Districts: 8

Total Population : 1.02606^{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)
Amod 78582 3656 23754 44938.46 35030.00
Anklesvar 123204 3291 50965 38739.40 27497.79
Bharuch 185056 7544 52976 58947.10 48009.88
Hansot 55832 3167 19510 39115.16 23699.83
Jambusar 153694 8412 19091 105863.91 66070.06
Jhagadia 185337 3881 127290 80745.93 44348.51
Vagra 100044 4450 25028 88342.64 45564.86
Valia 144311 963 113366 50990.95 40328.99

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.001*
(0.001)
perc_marginalised_pop -0.133**
(0.059)
district_head_quarter_distance_in_km 0.074
(0.163)
sub_district_head_quarter_distance_in_km -0.409**
(0.181)
nearest_statutory_town_distance_in_km -0.043
(0.146)
sub_district_nameAnklesvar 5.470
(6.203)
sub_district_nameBharuch 4.253
(6.548)
sub_district_nameHansot 33.518***
(5.995)
sub_district_nameJambusar -38.594***
(6.046)
sub_district_nameJhagadia -2.243
(5.921)
sub_district_nameVagra -31.740***
(6.350)
sub_district_nameValia -12.816**
(6.184)
Constant 48.170***
(6.579)
Observations 641
R2 0.334
Adjusted R2 0.321
Residual Std. Error 27.267 (df = 628)
F Statistic 26.256*** (df = 12; 628)
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.