Analytics on India census using Spark

POC#: Analytics on India census using Spark

In this article, I have explored Census data for India to understand changes in India’s demographics, population growth, religion distribution, gender distribution and sex ratio etc. Even by using small data, I could still gain a lot of valuable insights about the country. I have used Spark SQL and Inbuild graphs provided by Databricks.

India is the second most populous country in the world, with over 1.271 billion people, more than a sixth of the world's population. Already containing 17.5% of the world's population, India is projected to be the world's most populous country by 2025, surpassing China, its population reaching 1.6 billion by 2050.Its population growth rate is 1.2%.

We have loaded Census Data into Tables 

 

India’s States with Number of Districts.

India’s Population Density in terms of Districts.

Scheduled Castes (SC’s) Population per State.

Literacy Rate per States in India

States having Literacy Rate less than 50%

Gender wise Literacy rate per State

Education Type wise Literacy rate per State

Genders Ration per State

 Population by Religion per state

Drinking water Facility for Every State in India

Status of Electricity Facility per State

Education Facility per State

Medical Facility per State

Bus Transportation per State

Road Status per State

 Residence Status in India by State