Skip to content

Complete a Data Analytics Project on a Indian Census Dataset using SQL

Notifications You must be signed in to change notification settings

CoderNitu/Indian_Census_Data_Analysis_SQL

Repository files navigation

๐™„๐™ฃ๐™™๐™ž๐™–๐™ฃ_๐˜พ๐™š๐™ฃ๐™จ๐™ช๐™จ_๐˜ฟ๐™–๐™ฉ๐™–_๐˜ผ๐™ฃ๐™–๐™ก๐™ฎ๐™จ๐™ž๐™จ_๐™Ž๐™Œ๐™‡

๐–ฃ๐—ˆ๐—‡๐–พ ๐–ฒ๐—๐–บ๐—๐—‚๐—Œ๐—๐—‚๐–ผ๐–บ๐—… ๐– ๐—‡๐–บ๐—…๐—’๐—Œ๐—‚๐—Œ ๐—ˆ๐—‡ ๐—๐—๐–พ ๐Ÿค๐Ÿข๐Ÿฃ๐Ÿฃ ๐–จ๐—‡๐–ฝ๐—‚๐–บ๐—‡ ๐—‰๐—ˆ๐—‰๐—Ž๐—…๐–บ๐—๐—‚๐—ˆ๐—‡ ๐–ผ๐–พ๐—‡๐—Œ๐—Ž๐—Œ ๐–ฝ๐–บ๐—๐–บ ๐—๐—ˆ ๐–พ๐—‘๐—๐—‹๐–บ๐–ผ๐— ๐–ผ๐—‹๐—Ž๐–ผ๐—‚๐–บ๐—… ๐—‚๐—‡๐—Œ๐—‚๐—€๐—๐—๐—Œ ๐–บ๐–ป๐—ˆ๐—Ž๐— ๐—๐—๐–พ ๐–ฝ๐—‚๐–ฟ๐–ฟ๐–พ๐—‹๐–พ๐—‡๐— ๐–ฟ๐–บ๐–ผ๐—๐—ˆ๐—‹๐—Œ ๐—Œ๐—Ž๐–ผ๐— ๐–บ๐—Œ ๐—๐—ˆ๐—๐–บ๐—… ๐—‰๐—ˆ๐—‰๐—Ž๐—…๐–บ๐—๐—‚๐—ˆ๐—‡, ๐—‰๐—ˆ๐—‰๐—Ž๐—…๐–บ๐—๐—‚๐—ˆ๐—‡ ๐—€๐—‹๐—ˆ๐—๐—๐— ๐—‹๐–บ๐—๐–พ, ๐—Œ๐–พ๐—‘_๐—‹๐–บ๐—๐—‚๐—ˆ, ๐—…๐—‚๐—๐–พ๐—‹๐–บ๐–ผ๐—’_๐—‹๐–บ๐—๐–พ, ๐–บ๐—‡๐–ฝ ๐—‰๐—ˆ๐—‰๐—Ž๐—…๐–บ๐—๐—‚๐—ˆ๐—‡ ๐–ฝ๐–พ๐—‡๐—Œ๐—‚๐—๐—’ ๐—๐—๐–บ๐— ๐—‹๐–พ๐—‰๐—‹๐–พ๐—Œ๐–พ๐—‡๐— ๐—๐—๐–พ ๐–ฝ๐–พ๐—†๐—ˆ๐—€๐—‹๐–บ๐—‰๐—๐—‚๐–ผ, ๐—Œ๐—ˆ๐–ผ๐—‚๐–บ๐—…, ๐–พ๐–ผ๐—ˆ๐—‡๐—ˆ๐—†๐—‚๐–ผ, ๐–บ๐—‡๐–ฝ ๐–ผ๐—Ž๐—…๐—๐—Ž๐—‹๐–พ ๐—ˆ๐–ฟ ๐—๐—๐–พ ๐–จ๐—‡๐–ฝ๐—‚๐–บ๐—‡ ๐—‰๐—ˆ๐—‰๐—Ž๐—…๐–บ๐—๐—‚๐—ˆ๐—‡ ๐–ป๐—’ ๐—Œ๐—ˆ๐—…๐—๐—‚๐—‡๐—€ ๐—Œ๐—ˆ๐—†๐–พ ๐—„๐–พ๐—’ ๐—Š๐—Ž๐–พ๐—Œ๐—๐—‚๐—ˆ๐—‡๐—Œ ๐—Ž๐—Œ๐—‚๐—‡๐—€ ๐–ฒ๐–ฐ๐–ซ.

1e3a62_1bfb5338078842639e7b7b12de6e882b~mv2

๐™‹๐™ค๐™ฅ๐™ช๐™ก๐™–๐™ฉ๐™ž๐™ค๐™ฃ ๐˜พ๐™š๐™ฃ๐™จ๐™ช๐™จ

A census is a process that includes collecting demographic, social, cultural, and economic data about a country or a part of a country, which is then sent to the data centers where data is analyzed and presented to the running government so it can take useful measures and make policies and thus present in the public domain for the people of a country to know. " ๐™„๐™ฃ ๐™„๐™ฃ๐™™๐™ž๐™–, ๐™ฉ๐™๐™š ๐™ฅ๐™ค๐™ฅ๐™ช๐™ก๐™–๐™ฉ๐™ž๐™ค๐™ฃ ๐™˜๐™š๐™ฃ๐™จ๐™ช๐™จ ๐™ž๐™จ ๐™˜๐™ค๐™ฃ๐™™๐™ช๐™˜๐™ฉ๐™š๐™™ ๐™–๐™›๐™ฉ๐™š๐™ง ๐™š๐™ซ๐™š๐™ง๐™ฎ ๐™ฉ๐™š๐™ฃ ๐™ฎ๐™š๐™–๐™ง๐™จ. ๐™„๐™ฉ ๐™ž๐™จ ๐™ค๐™ฃ๐™š ๐™ค๐™› ๐™ฉ๐™๐™š ๐™ฌ๐™ค๐™ง๐™ก๐™™'๐™จ ๐™ก๐™–๐™ง๐™œ๐™š๐™จ๐™ฉ ๐™–๐™™๐™ข๐™ž๐™ฃ๐™ž๐™จ๐™ฉ๐™ง๐™–๐™ฉ๐™ž๐™ซ๐™š ๐™š๐™ญ๐™š๐™ง๐™˜๐™ž๐™จ๐™š๐™จ. ๐™๐™๐™š ๐™ก๐™–๐™จ๐™ฉ ๐™˜๐™š๐™ฃ๐™จ๐™ช๐™จ ๐™ž๐™ฃ ๐™„๐™ฃ๐™™๐™ž๐™– ๐™ฌ๐™–๐™จ ๐™˜๐™ค๐™ฃ๐™™๐™ช๐™˜๐™ฉ๐™š๐™™ ๐™ž๐™ฃ 2011. ๐™๐™๐™š ๐™ฃ๐™š๐™ญ๐™ฉ ๐™˜๐™š๐™ฃ๐™จ๐™ช๐™จ ๐™ฌ๐™–๐™จ ๐™จ๐™˜๐™๐™š๐™™๐™ช๐™ก๐™š๐™™ ๐™›๐™ค๐™ง 2021, ๐™—๐™ช๐™ฉ ๐™ฌ๐™–๐™จ ๐™ฅ๐™ค๐™จ๐™ฉ๐™ฅ๐™ค๐™ฃ๐™š๐™™ ๐™™๐™ช๐™š ๐™ฉ๐™ค ๐™ฉ๐™๐™š ๐˜พ๐™Š๐™‘๐™„๐˜ฟ-19 ๐™ฅ๐™–๐™ฃ๐™™๐™š๐™ข๐™ž๐™˜. ๐™๐™๐™š ๐™ฃ๐™š๐™ญ๐™ฉ ๐™˜๐™š๐™ฃ๐™จ๐™ช๐™จ ๐™ž๐™จ ๐™š๐™ญ๐™ฅ๐™š๐™˜๐™ฉ๐™š๐™™ ๐™ฉ๐™ค ๐™—๐™š ๐™๐™š๐™ก๐™™ ๐™–๐™›๐™ฉ๐™š๐™ง ๐™ฉ๐™๐™š 2024 ๐™œ๐™š๐™ฃ๐™š๐™ง๐™–๐™ก ๐™š๐™ก๐™š๐™˜๐™ฉ๐™ž๐™ค๐™ฃ."

๐™„๐™ข๐™ฅ๐™ค๐™ง๐™ฉ๐™–๐™ฃ๐™ฉ ๐˜พ๐™ค๐™ข๐™ข๐™ค๐™ฃ ๐™๐™–๐™˜๐™ฉ๐™ค๐™ง๐™จ

1. ๏ผฐ๏ฝ๏ฝ๏ฝ•๏ฝŒ๏ฝ๏ฝ”๏ฝ‰๏ฝ๏ฝŽโ€ƒ๏ผง๏ฝ’๏ฝ๏ฝ—๏ฝ”๏ฝˆโ€ƒ๏ผฒ๏ฝ๏ฝ”๏ฝ…

The population growth rate (PGR) is a factor that represents the rate of population growth or the change in number of people over a specific period. It can indicate growth, decline, or equilibrium of population size.

๏ผ’ใ€‚๏ผณ๏ฝ…๏ฝ˜โ€ƒ๏ผฒ๏ฝ๏ฝ”๏ฝ‰๏ฝโ€ƒ๏ผโ€ƒ๏ผง๏ฝ…๏ฝŽ๏ฝ„๏ฝ…๏ฝ’โ€ƒ๏ผฒ๏ฝ๏ฝ”๏ฝ‰๏ฝ

In India, the sex ratio is defined as the number of females per 1000 males (disregarding other genders), whereas in almost all the UN publications/International publications, it is expressed as males to per 100 females.

๏ผ“ใ€‚๏ผข๏ฝ‰๏ฝ’๏ฝ”๏ฝˆโ€ƒ๏ผฒ๏ฝ๏ฝ”๏ฝ…โ€ƒ๏ผ†โ€ƒ๏ผค๏ฝ…๏ฝ๏ฝ”๏ฝˆโ€ƒ๏ผฒ๏ฝ๏ฝ”๏ฝ…

The birth rate is the number of live births per 1000 people in a given area during a specific period. The death rate is the number of deaths per 1000 people in a given area during a specific period.

๏ผ”ใ€‚ ๏ผฌ๏ฝ‰๏ฝ”๏ฝ…๏ฝ’๏ฝ๏ฝƒ๏ฝ™โ€ƒ๏ผฒ๏ฝ๏ฝ”๏ฝ…

The literacy rate in India is calculated by dividing the total number of literate people aged 7 or above by the total number of population aged 7 or above and multiplying the result by 100

๏ผ•ใ€‚๏ผฐ๏ฝ๏ฝ๏ฝ•๏ฝŒ๏ฝ๏ฝ”๏ฝ‰๏ฝ๏ฝŽโ€ƒ๏ผค๏ฝ…๏ฝŽ๏ฝ“๏ฝ‰๏ฝ”๏ฝ™

Population Density is the number of people living in a specific area. It is calculated by dividing the total population of an area by its total land area. It is expressed as "per kilometer square". It is used to describe the location, growth, and migration of organisms.

๐™๐™ค๐™ค๐™ก๐™จ ๐™–๐™ฃ๐™™ ๐™๐™š๐™˜๐™๐™ฃ๐™ค๐™ก๐™ค๐™œ๐™ž๐™š๐™จ

  1. Pแด๊œฑแด›ษขส€แด‡SQL
  2. PGAแด…แดษชษด
  3. MS Exแด„แด‡สŸ (EDA)

About

Complete a Data Analytics Project on a Indian Census Dataset using SQL

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published