Name: Education In India
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

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:

2015_16_Districtwise.csv ( 680 observations and 819 variables )
2015_16_Statewise_Elementary.csv ( 36 observations and 816 variables )
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.

Drop out ratio in primary and secondary education. (Govt. has made law that every child under age 14 should get free compulsary education.)
Various factors affecting examination results of the students.
What are all the factors that makes the difference (in literacy rate) between Kerala and Bihar?
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.01 MB
680 rows
819 columns


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.12 KB
821 rows
2 columns


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

646.35 KB
36 rows
816 columns


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.15 KB
816 rows
2 columns


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

516.27 KB
36 rows
630 columns


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.11 KB
630 rows
2 columns


CREATE TABLE n_2015_16_statewise_secondary_metadata (
  "field_name" VARCHAR,
  "description" VARCHAR
);