The decennial Census of India has been conducted 15 times, as of 2011. While it has been undertaken every 10 years, beginning in 1872 under British Viceroy Lord Mayo, the first complete census was taken in 1881. Post 1949, it has been conducted by the Registrar General and Census Commissioner of India under the Ministry of Home Affairs, Government of India. All the censuses since 1951 were conducted under the 1948 Census of India Act. The last census was held in 2011, whilst the next was to be held in 2021. But it has been postponed due to the COVID-19 pandemic .So, this repository contains Exploratory Data Analysis of India Census using SQL (Structured Query Language).
| Files/Folder | Description |
|---|---|
| Dataset Folder | This folder provides you two datsets i.e data1.csv and data2.csv |
| INDIAN CENSUS_SQL File | This file provides you .sql format file which you can download and work on analysis using SQL platform. |
o Fetching count of rows in both datasets.
o Average sex ratio, average growth, and average literacy rate state wise.
o Top 5 states having the highest growth rate.
o Bottom 5 states having the lowest sex ratio.
o Records for which states are starting with the letter 'A' or 'B'.
o Total males and females state wise.
Must browse through from each folder of this repository must start with:
1.Always start with creating Database in SQL platform.
2.Then Import csv file. Below procedure and screenshot shows how to **import CSV** dataset in SQL SERVER.
o First go to Explorer window section.
o Left click on database in Explorer window
o Then select Task option
o And in last go to Import Flat file section and select CSV files and import it.
I'm an aspiring data analyst...
• Structured Query Language (SQL)
• Excel
• Analytical Visualisation
• PowerPoint
• MS Word