MostafaNabil21/HCV-Egypt-Clinical-SQL-Analysis

SQL Analysis for HCV patients # 🧬 HCV Egypt — Clinical Data Analysis with MySQL Exploratory Clinical Data Analysis of Hepatitis C Virus (HCV) Patients Using Pure MySQL --- ## 📌 Project Overview This project is an **exploratory clinical data analysis of patients with Hepatitis C Virus (HCV) patients from Egypt** performed entirely using **MySQL**. The analysis explores demographics characteristics, clinical symptoms, laboratory measurements, histological grading and staging, viral load, and treatment response. Rather than using Python, Pandas, R, or other analytical programming libraries, the project focuses on demonstrating how far **pure SQL can be taken for real-world exploratory data analysis**. The complete analysis is documented in a **Jupyter Notebook**, where SQL queries are organized into analytical sections and accompanied by explanations and query results. --- # 🎯 Project Goals The primary goal is to use SQL to transform raw clinical data into meaningful analytical insights. The project focuses on five major objectives: ### 1. Understand the patient population Analyze: - Age - Gender - BMI - Demographic distributions ### 2. Investigate disease severity Analyze: - Baseline histological staging - Histological grading - Clinical symptoms - Blood measurements - Liver enzymes ### 3. Analyze viral load Investigate: - Baseline RNA - RNA at Week 4 - RNA at Week 12 - End-of-treatment RNA - Viral-load changes ### 4. Examine treatment response Investigate: - Response groups - Baseline viral load vs response - Fibrosis stage vs response - Viral-load quartiles vs treatment response ### 5. Demonstrate advanced SQL Apply: - CTEs - Subqueries - Conditional aggregation - CASE - Window functions - Ranking - Percentiles - Quartile analysis --- ## 🗃️ Dataset ### Hepatitis C Virus (HCV) for Egyptian Patients The project uses the **Hepatitis C Virus (HCV) for Egyptian patients** dataset available through the: **🔗 UCI Machine Learning Repository** The dataset was donated to …