pinkleather221/kenya-femicide-analysis

# Femicide Cases in Kenya - Data Analysis (2016-2023) > A data-driven investigation into femicide patterns across Kenya using Excel Power Query, Pivot Tables, and an interactive dashboard. dev.to --- ## Project Overview Femicide, the killing of women and girls because of their gender, remains one of Kenya's most urgent and underreported crises. This project analyses **507 documented femicide cases** reported across Kenya between **2016 and 2023**, with the goal of surfacing patterns in how, where, and by whom these murders occur. The analysis was built entirely in **Microsoft Excel**, covering the full data pipeline: ingestion, cleaning, enrichment, visualization, and dashboard. --- ## Data Source The dataset was downloaded from **Kaggle** - *Femicide in Kenya (2016-2023)*. It was compiled from multiple verified sources including: - News articles and investigative journalism - Activist platforms and gender-based violence tracking networks - Social media reports and community alerts Each row in the dataset represents a **unique reported femicide case**, with metadata covering victim details, geography, suspect relationship, method of killing, and case legal status. | Column | Description | |---|---| | `Date` | Date the femicide was reported or occurred | | `Name of Victim` | Victim's name (where available) | | `Age` | Age of the victim | | `County` | Geographic county of the incident | | `Town / Area` | More specific location | | `Suspect Relationship` | Relationship between victim and perpetrator | | `Type of Femicide` | Intimate vs. Non-intimate classification | | `Mode of Killing` | Method used (e.g., stabbing, strangulation) | | `Murder Scene` | Where the killing took place | | `Author / Medium` | Reporting outlet or journalist | | `Case / Court Status` | Legal outcome, if available | > **Data Limitations:** Some cases have missing attributes due to un …