About this Dataset

Indian School Education Statistics

Context

This dataset contains information about Indian School Education Statistics of the year 2013-2014 to 2015-2016. Many public datasets from Indian Government are scattered and the goal here is to have all those datasets under one umbrella so that it is easy for beginners to find important datasets like this to start their Data Science journey.

Content

I acquired this dataset from here. Have a look at the website.

This dataset contains 7 files in .csv format. You can find a description for each column. Let me summarize it here too.

Percentage of Schools with Drinking Water Facility from 2013-14 to 2015-16
Gross Enrolment Ratio from 2013-14 to 2015-16
Drop-out rate from 2012-13 to 2014-15
Percentage of Schools with Computers from 2013-14 to 2015-16
Percentage of Schools with Electricity from 2013-14 to 2015-16
Schools with Boys Toilet from 2013-14 to 2015-16
Schools with Girls Toilet from 2013-14 to 2015-16

Inspiration

This dataset is especially useful for starters in their Data Science journey, also whoever is interested in knowing how the education in India is progressing over the years. You can start your exploration by answering the below questions:

Which states have the highest Dropout Ratio?
Do boys and girls have enough water and toilet facilities available?
How is the Gross Enrollment ration for boys and girls in various levels of schooling life?
Which level of school life is there less number of enrollment? Is it dropping or increasing?
Any other ideas.

Acknowledgements

I thank the Indian Government for making it public under their Open Government Data (OGD) Platform India.

Tables

Percentage Of Schools With Water Facility 2013–2016

@kaggle.vidyapb_indian_school_education_statistics.percentage_of_schools_with_water_facility_2013_2016

15.1 KB
110 rows
13 columns


CREATE TABLE percentage_of_schools_with_water_facility_2013_2016 (
  "state_ut" VARCHAR,
  "year" VARCHAR,
  "primary_only" DOUBLE,
  "primary_with_u_primary" DOUBLE,
  "primary_with_u_primary_sec_hrsec" DOUBLE,
  "u_primary_only" DOUBLE,
  "u_primary_with_sec_hrsec" DOUBLE,
  "primary_with_u_primary_sec" DOUBLE,
  "u_primary_with_sec" DOUBLE,
  "sec_only" DOUBLE,
  "sec_with_hrsec" DOUBLE,
  "hrsec_only" DOUBLE,
  "all_schools" DOUBLE
);

Percentage Of Schools With Comps 2013–2016

@kaggle.vidyapb_indian_school_education_statistics.percentage_of_schools_with_comps_2013_2016

16.7 KB
110 rows
13 columns


CREATE TABLE percentage_of_schools_with_comps_2013_2016 (
  "state_ut" VARCHAR,
  "year" VARCHAR,
  "primary_only" DOUBLE,
  "primary_with_u_primary" DOUBLE,
  "primary_with_u_primary_sec_hrsec" DOUBLE,
  "u_primary_only" DOUBLE,
  "u_primary_with_sec_hrsec" DOUBLE,
  "primary_with_u_primary_sec" DOUBLE,
  "u_primary_with_sec" DOUBLE,
  "sec_only" DOUBLE,
  "sec_with_hrsec" DOUBLE,
  "hrsec_only" DOUBLE,
  "all_schools" DOUBLE
);

Schools With Boys Toilet 2013–2016

@kaggle.vidyapb_indian_school_education_statistics.schools_with_boys_toilet_2013_2016

15.45 KB
110 rows
13 columns


CREATE TABLE schools_with_boys_toilet_2013_2016 (
  "state_ut" VARCHAR,
  "year" VARCHAR,
  "primary_only" DOUBLE,
  "primary_with_u_primary" DOUBLE,
  "primary_with_u_primary_sec_hrsec" DOUBLE,
  "u_primary_only" DOUBLE,
  "u_primary_with_sec_hrsec" DOUBLE,
  "primary_with_u_primary_sec" DOUBLE,
  "u_primary_with_sec" DOUBLE,
  "sec_only" DOUBLE,
  "sec_with_hrsec" DOUBLE,
  "hrsec_only" DOUBLE,
  "all_schools" DOUBLE
);

Schools With Girls Toilet 2013–2016

@kaggle.vidyapb_indian_school_education_statistics.schools_with_girls_toilet_2013_2016

14.96 KB
110 rows
13 columns


CREATE TABLE schools_with_girls_toilet_2013_2016 (
  "state_ut" VARCHAR,
  "year" VARCHAR,
  "primary_only" DOUBLE,
  "primary_with_u_primary" DOUBLE,
  "primary_with_u_primary_sec_hrsec" DOUBLE,
  "u_primary_only" DOUBLE,
  "u_primary_with_sec_hrsec" DOUBLE,
  "primary_with_u_primary_sec" DOUBLE,
  "u_primary_with_sec" DOUBLE,
  "sec_only" DOUBLE,
  "sec_with_hrsec" DOUBLE,
  "hrsec_only" DOUBLE,
  "all_schools" DOUBLE
);

Percentage Of Schools With Electricity 2013–2016

@kaggle.vidyapb_indian_school_education_statistics.percentage_of_schools_with_electricity_2013_2016

15.93 KB
110 rows
13 columns


CREATE TABLE percentage_of_schools_with_electricity_2013_2016 (
  "state_ut" VARCHAR,
  "year" VARCHAR,
  "primary_only" DOUBLE,
  "primary_with_u_primary" DOUBLE,
  "primary_with_u_primary_sec_hrsec" DOUBLE,
  "u_primary_only" DOUBLE,
  "u_primary_with_sec_hrsec" DOUBLE,
  "primary_with_u_primary_sec" DOUBLE,
  "u_primary_with_sec" DOUBLE,
  "sec_only" DOUBLE,
  "sec_with_hrsec" DOUBLE,
  "hrsec_only" DOUBLE,
  "all_schools" DOUBLE
);

Dropout Ratio 2012–2015

@kaggle.vidyapb_indian_school_education_statistics.dropout_ratio_2012_2015

17.4 KB
110 rows
14 columns


CREATE TABLE dropout_ratio_2012_2015 (
  "state_ut" VARCHAR,
  "year" VARCHAR,
  "primary_boys" VARCHAR,
  "primary_girls" VARCHAR,
  "primary_total" VARCHAR,
  "upper_primary_boys" VARCHAR,
  "upper_primary_girls" VARCHAR,
  "upper_primary_total" VARCHAR,
  "secondary_boys" VARCHAR,
  "secondary_girls" VARCHAR,
  "secondary_total" VARCHAR,
  "hrsecondary_boys" VARCHAR,
  "hrsecondary_girls" VARCHAR,
  "hrsecondary_total" VARCHAR
);

Gross Enrollment Ratio 2013–2016

@kaggle.vidyapb_indian_school_education_statistics.gross_enrollment_ratio_2013_2016

19.48 KB
110 rows
14 columns


CREATE TABLE gross_enrollment_ratio_2013_2016 (
  "state_ut" VARCHAR,
  "year" VARCHAR,
  "primary_boys" DOUBLE,
  "primary_girls" DOUBLE,
  "primary_total" DOUBLE,
  "upper_primary_boys" DOUBLE,
  "upper_primary_girls" DOUBLE,
  "upper_primary_total" DOUBLE,
  "secondary_boys" DOUBLE,
  "secondary_girls" DOUBLE,
  "secondary_total" DOUBLE,
  "higher_secondary_boys" VARCHAR,
  "higher_secondary_girls" VARCHAR,
  "higher_secondary_total" VARCHAR
);