Skip to content

README.md

Latest commit

 

History

History
34 lines (24 loc) · 1.31 KB

README.md

File metadata and controls

34 lines (24 loc) · 1.31 KB

Employment & Population Ratio in India (1961–1988)

This project explores employment trends and population ratios in India from 1961 to 1988 using data sourced from WorldData. I cleaned the raw data in Excel, structured it into a PostgreSQL table, and ran multiple queries to understand employment patterns across industries, genders, and age groups.

📂 Files in This Repository

  • population_ratio_data.sql: SQL dump of the cleaned and structured data table (popudata)
  • queries.sql: SQL queries for exploring and analyzing the dataset (to be added)

🧠 What I Did

  • Collected raw data from a public source
  • Cleaned and structured the data in Excel
  • Imported the cleaned CSV into PostgreSQL
  • Wrote and executed SQL queries:
    • Aggregate functions: AVG(), MAX(), MIN(), AVG(), ORDER BY(),UNION ALL(), GROUP BY()
    • Filtering using WHERE clauses
    • Extracting trends based on gender, age, and employment sector

📌 Tools Used

  • Excel
  • PostgreSQL
  • SQL
  • GitHub

📈 Key Insights

  • Employment in agriculture saw a steady decline post-1975.
  • Female employment in the services sector began catching up in the 1980s.
  • Industry-based employment stayed relatively consistent across genders.

📎 Data Source

WorldData.info