README.md

hh-postgres-analyzer: Vacancy Data Cleaning and Analysis on HH.ru using PostgreSQL

---

📚 Table of Contents

• 🔎 Project Description
• 🎯 Problem Statement
• 📊 Data Overview
• 🛠 Project Workflow
• 📈 Quality Metrics
• 🧩 Skills Practiced
• 💡 Conclusions

---

🔎 Project Description

Vacancy data analysis from HH.ru using PostgreSQL. This project involves data cleaning, pattern discovery, feature engineering, and aggregation for enhanced analysis quality.

---

🎯 Problem Statement

Read, analyze, and create a new dataset based on the current data by manipulating and aggregating it.

---

📊 Data Overview

• Vacancy data from HH.ru
• Employer information
• Data on salaries, requirements, and working conditions

---

🛠 Project Workflow

1. Load the dataframe
2. Get acquainted with the data
3. Perform preliminary data analysis
4. Detailed vacancy analysis
5. Employer analysis
6. Subject-matter analysis
7. Draw final conclusions taking intermediate findings into account

---

📈 Quality Metrics

Quality metrics include removing outliers from tables and normalizing graphs accordingly.

---

🧩 Skills Practiced

• Reading databases
• Writing correct and optimized SQL queries
• Aggregating various data types
• Joining, grouping, and merging multiple tables

---

💡 Conclusions

• ⬆️ Project notebook completion

---

If you find this project useful or interesting, I would greatly appreciate a ⭐️⭐️⭐️ on the repository and support for my profile!