Baselight
Sign In

Education In India

District and state-wise primary & secondary school education data, 2015-16

@kaggle.rajanand_education_in_india

Loading...
Loading...

About this Dataset

Education In India

Context

When India got independence from British in 1947 the literacy rate was 12.2% and as per the recent census 2011 it is 74.0%. Although it looks an accomplishment, still many people are there without access to education.

It would be interesting to know the current status of the Indian education system.

Content

This dataset contains district and state wise Indian primary and secondary school education data for 2015-16.

Granularity: Annual

List of files:

  1. 2015_16_Districtwise.csv ( 680 observations and 819 variables )
  2. 2015_16_Statewise_Elementary.csv ( 36 observations and 816 variables )
  3. 2015_16_Statewise_Secondary.csv ( 36 observations and 630 variables )

Acknowledgements

Ministry of Human Resource Development (DISE) has shared the dataset here and also published some reports.

Source of Banner image.

Inspiration

This dataset provides the complete information about primary and secondary education. There are many inferences can be made from this dataset. There are few things I would like to understand from this dataset.

  1. Drop out ratio in primary and secondary education. (Govt. has made law that every child under age 14 should get free compulsary education.)
  2. Various factors affecting examination results of the students.
  3. What are all the factors that makes the difference (in literacy rate) between Kerala and Bihar?
  4. What could be done to improve the female literacy rate and literacy rate in rural area?

Tables

N 2015–16 Districtwise

@kaggle.rajanand_education_in_india.n_2015_16_districtwise
  • 2.11 MB
  • 680 rows
  • 819 columns
Loading... 
CREATE TABLE n_2015_16_districtwise (
  "ac_year" VARCHAR,
  "statcd" BIGINT,
  "distcd" BIGINT,
  "statname" VARCHAR,
  "distname" VARCHAR,
  "districts" BIGINT,
  "blocks" BIGINT,
  "villages" BIGINT,
  "clusters" BIGINT,
  "totpopulat" DOUBLE,
  "p_urb_pop" DOUBLE,
  "population_0_6" DOUBLE,
  "growthrate" DOUBLE,
  "sexratio" DOUBLE,
  "p_sc_pop" DOUBLE,
  "p_st_pop" DOUBLE,
  "overall_li" DOUBLE,
  "female_lit" DOUBLE,
  "male_lit" DOUBLE,
  "area_sqkm" DOUBLE,
  "tot_6_10_15" DOUBLE,
  "tot_11_13_15" DOUBLE,
  "sch1" BIGINT,
  "sch2" BIGINT,
  "sch3" BIGINT,
  "sch4" BIGINT,
  "sch5" BIGINT,
  "sch6" BIGINT,
  "sch7" BIGINT,
  "sch9" BIGINT,
  "schtot" BIGINT,
  "sch1g" BIGINT,
  "sch2g" BIGINT,
  "sch3g" BIGINT,
  "sch4g" BIGINT,
  "sch5g" BIGINT,
  "sch6g" BIGINT,
  "sch7g" BIGINT,
  "sch9g" BIGINT,
  "schtotg" BIGINT,
  "sch1p" BIGINT,
  "sch2p" BIGINT,
  "sch3p" BIGINT,
  "sch4p" BIGINT,
  "sch5p" BIGINT,
  "sch6p" BIGINT,
  "sch7p" BIGINT,
  "sch9p" BIGINT,
  "schtotp" BIGINT,
  "sch1m" BIGINT,
  "sch2m" BIGINT,
  "sch3m" BIGINT,
  "sch4m" BIGINT,
  "sch5m" BIGINT,
  "sch6m" BIGINT,
  "sch7m" BIGINT,
  "sch9m" BIGINT,
  "schtotm" BIGINT,
  "sch1gr" BIGINT,
  "sch2gr" BIGINT,
  "sch3gr" BIGINT,
  "sch4gr" BIGINT,
  "sch5gr" BIGINT,
  "sch6gr" BIGINT,
  "sch7gr" BIGINT,
  "sch9gr" BIGINT,
  "schtotgr" BIGINT,
  "sch1ga" BIGINT,
  "sch2ga" BIGINT,
  "sch3ga" BIGINT,
  "sch4ga" BIGINT,
  "sch5ga" BIGINT,
  "sch6ga" BIGINT,
  "sch7ga" BIGINT,
  "sch9ga" BIGINT,
  "schtotga" BIGINT,
  "sch1pr" BIGINT,
  "sch2pr" BIGINT,
  "sch3pr" BIGINT,
  "sch4pr" BIGINT,
  "sch5pr" BIGINT,
  "sch6pr" BIGINT,
  "sch7pr" BIGINT,
  "sch9pr" BIGINT,
  "schtotpr" BIGINT,
  "schboy1" BIGINT,
  "schboy2" BIGINT,
  "schboy3" BIGINT,
  "schboy4" BIGINT,
  "schboy5" BIGINT,
  "schboy6" BIGINT,
  "schboy7" BIGINT,
  "schboy9" BIGINT,
  "schboytot" BIGINT,
  "schgir1" BIGINT,
  "schgir2" BIGINT,
  "schgir3" BIGINT,
  "schgir4" BIGINT,
  "schgir5" BIGINT,
  "schgir6" BIGINT
);

N 2015–16 Districtwise Metadata

@kaggle.rajanand_education_in_india.n_2015_16_districtwise_metadata
  • 17.53 kB
  • 821 rows
  • 2 columns
Loading... 
CREATE TABLE n_2015_16_districtwise_metadata (
  "field_name" VARCHAR,
  "description" VARCHAR
);

N 2015–16 Statewise Elementary

@kaggle.rajanand_education_in_india.n_2015_16_statewise_elementary
  • 661.86 kB
  • 36 rows
  • 816 columns
Loading... 
CREATE TABLE n_2015_16_statewise_elementary (
  "ac_year" VARCHAR,
  "statcd" BIGINT,
  "statname" VARCHAR,
  "districts" BIGINT,
  "blocks" BIGINT,
  "villages" BIGINT,
  "clusters" BIGINT,
  "totpopulat" BIGINT,
  "p_urb_pop" DOUBLE,
  "population_0_6" DOUBLE,
  "growthrate" DOUBLE,
  "sexratio" BIGINT,
  "p_sc_pop" DOUBLE,
  "p_st_pop" DOUBLE,
  "overall_li" DOUBLE,
  "female_lit" DOUBLE,
  "male_lit" DOUBLE,
  "area_sqkm" BIGINT,
  "tot_6_10_15" BIGINT,
  "tot_11_13_15" BIGINT,
  "sch1" BIGINT,
  "sch2" BIGINT,
  "sch3" BIGINT,
  "sch4" BIGINT,
  "sch5" BIGINT,
  "sch6" BIGINT,
  "sch7" BIGINT,
  "sch9" BIGINT,
  "schtot" BIGINT,
  "sch1g" BIGINT,
  "sch2g" BIGINT,
  "sch3g" BIGINT,
  "sch4g" BIGINT,
  "sch5g" BIGINT,
  "sch6g" BIGINT,
  "sch7g" BIGINT,
  "sch9g" BIGINT,
  "schtotg" BIGINT,
  "sch1p" BIGINT,
  "sch2p" BIGINT,
  "sch3p" BIGINT,
  "sch4p" BIGINT,
  "sch5p" BIGINT,
  "sch6p" BIGINT,
  "sch7p" BIGINT,
  "sch9p" BIGINT,
  "schtotp" BIGINT,
  "sch1m" BIGINT,
  "sch2m" BIGINT,
  "sch3m" BIGINT,
  "sch4m" BIGINT,
  "sch5m" BIGINT,
  "sch6m" BIGINT,
  "sch7m" BIGINT,
  "sch9m" BIGINT,
  "schtotm" BIGINT,
  "sch1gr" BIGINT,
  "sch2gr" BIGINT,
  "sch3gr" BIGINT,
  "sch4gr" BIGINT,
  "sch5gr" BIGINT,
  "sch6gr" BIGINT,
  "sch7gr" BIGINT,
  "sch9gr" BIGINT,
  "schtotgr" BIGINT,
  "sch1ga" BIGINT,
  "sch2ga" BIGINT,
  "sch3ga" BIGINT,
  "sch4ga" BIGINT,
  "sch5ga" BIGINT,
  "sch6ga" BIGINT,
  "sch7ga" BIGINT,
  "sch9ga" BIGINT,
  "schtotga" BIGINT,
  "sch1pr" BIGINT,
  "sch2pr" BIGINT,
  "sch3pr" BIGINT,
  "sch4pr" BIGINT,
  "sch5pr" BIGINT,
  "sch6pr" BIGINT,
  "sch7pr" BIGINT,
  "sch9pr" BIGINT,
  "schtotpr" BIGINT,
  "schboy1" BIGINT,
  "schboy2" BIGINT,
  "schboy3" BIGINT,
  "schboy4" BIGINT,
  "schboy5" BIGINT,
  "schboy6" BIGINT,
  "schboy7" BIGINT,
  "schboy9" BIGINT,
  "schboytot" BIGINT,
  "schgir1" BIGINT,
  "schgir2" BIGINT,
  "schgir3" BIGINT,
  "schgir4" BIGINT,
  "schgir5" BIGINT,
  "schgir6" BIGINT,
  "schgir7" BIGINT,
  "schgir9" BIGINT
);

N 2015–16 Statewise Elementary Metadata

@kaggle.rajanand_education_in_india.n_2015_16_statewise_elementary_metadata
  • 17.57 kB
  • 816 rows
  • 2 columns
Loading... 
CREATE TABLE n_2015_16_statewise_elementary_metadata (
  "field_name" VARCHAR,
  "description" VARCHAR
);

N 2015–16 Statewise Secondary

@kaggle.rajanand_education_in_india.n_2015_16_statewise_secondary
  • 528.66 kB
  • 36 rows
  • 630 columns
Loading... 
CREATE TABLE n_2015_16_statewise_secondary (
  "ac_year" VARCHAR,
  "statcd" BIGINT,
  "statname" VARCHAR,
  "area_sqkm" DOUBLE,
  "tot_population" DOUBLE,
  "urban_population" DOUBLE,
  "grwoth_rate" DOUBLE,
  "sexratio" DOUBLE,
  "sc_population" DOUBLE,
  "st_population" DOUBLE,
  "literacy_rate" DOUBLE,
  "male_literacy_rate" DOUBLE,
  "female_literacy_rate" DOUBLE,
  "distcd" BIGINT,
  "blkcd" BIGINT,
  "villages" BIGINT,
  "clusters" BIGINT,
  "schools" BIGINT,
  "sch_1" BIGINT,
  "sch_2" BIGINT,
  "sch_3" BIGINT,
  "sch_4" BIGINT,
  "sch_5" BIGINT,
  "sch_6" BIGINT,
  "sch_7" BIGINT,
  "sch_r_1" BIGINT,
  "sch_r_2" BIGINT,
  "sch_r_3" BIGINT,
  "sch_r_4" BIGINT,
  "sch_r_5" BIGINT,
  "sch_r_6" BIGINT,
  "sch_r_7" BIGINT,
  "sch_u_1" BIGINT,
  "sch_u_2" BIGINT,
  "sch_u_3" BIGINT,
  "sch_u_4" BIGINT,
  "sch_u_5" BIGINT,
  "sch_u_6" BIGINT,
  "sch_u_7" BIGINT,
  "enr_1" BIGINT,
  "enr_2" BIGINT,
  "enr_3" BIGINT,
  "enr_4" BIGINT,
  "enr_5" BIGINT,
  "enr_6" BIGINT,
  "enr_7" BIGINT,
  "enr_all" BIGINT,
  "enr_r_1" BIGINT,
  "enr_r_2" BIGINT,
  "enr_r_3" BIGINT,
  "enr_r_4" BIGINT,
  "enr_r_5" BIGINT,
  "enr_r_6" BIGINT,
  "enr_r_7" BIGINT,
  "enr_r_all" BIGINT,
  "enr_u_1" BIGINT,
  "enr_u_2" BIGINT,
  "enr_u_3" BIGINT,
  "enr_u_4" BIGINT,
  "enr_u_5" BIGINT,
  "enr_u_6" BIGINT,
  "enr_u_7" BIGINT,
  "enr_u_all" BIGINT,
  "tch_1" BIGINT,
  "tch_2" BIGINT,
  "tch_3" BIGINT,
  "tch_4" BIGINT,
  "tch_5" BIGINT,
  "tch_6" BIGINT,
  "tch_7" BIGINT,
  "tch_all" BIGINT,
  "tch_r_1" BIGINT,
  "tch_r_2" BIGINT,
  "tch_r_3" BIGINT,
  "tch_r_4" BIGINT,
  "tch_r_5" BIGINT,
  "tch_r_6" BIGINT,
  "tch_r_7" BIGINT,
  "tch_r_all" BIGINT,
  "tch_u_1" BIGINT,
  "tch_u_2" BIGINT,
  "tch_u_3" BIGINT,
  "tch_u_4" BIGINT,
  "tch_u_5" BIGINT,
  "tch_u_6" BIGINT,
  "tch_u_7" BIGINT,
  "tch_u_all" BIGINT,
  "sing_cls_sch_1" DOUBLE,
  "sing_cls_sch_2" DOUBLE,
  "sing_cls_sch_3" DOUBLE,
  "sing_cls_sch_4" DOUBLE,
  "sing_cls_sch_5" DOUBLE,
  "sing_cls_sch_6" DOUBLE,
  "sing_cls_sch_7" DOUBLE,
  "sing_cls_sch_all" DOUBLE,
  "sing_tch_sch_1" DOUBLE,
  "sing_tch_sch_2" DOUBLE,
  "sing_tch_sch_3" DOUBLE,
  "sing_tch_sch_4" DOUBLE,
  "sing_tch_sch_5" DOUBLE
);

N 2015–16 Statewise Secondary Metadata

@kaggle.rajanand_education_in_india.n_2015_16_statewise_secondary_metadata
  • 13.43 kB
  • 630 rows
  • 2 columns
Loading... 
CREATE TABLE n_2015_16_statewise_secondary_metadata (
  "field_name" VARCHAR,
  "description" VARCHAR
);

Share link

Anyone who has the link will be able to view this.