A data analysis of Indonesia's Election Ethics Tribunal (DKPP) performance data across 13 years of operation.
The Dewan Kehormatan Penyelenggara Pemilu (DKPP) — Indonesia's Honorary Council of Election Organizers — is the ethical arbiter of election administration in the country. This project applies statistical analysis to DKPP's official performance data from 2012 to 2025, combining descriptive and inferential methods to surface patterns in case volume, ruling severity, regional distribution, institutional breakdown, and the principles most frequently violated.
Kinerja DKPP/
├── DKPP-13022026.xlsx — Raw data file 1 (10 sheets, 2018–2025)
├── DKPP-14022026.xlsx — Raw data file 2 (5 sheets, 2020–2025, clean version)
├── analysis/
│ ├── dkpp_full_analysis.Rmd — Main R Markdown (descriptive + inferential, ~63 chunks)
│ ├── dkpp_full_analysis.html — Rendered interactive HTML report
│ ├── dkpp_pdf_version.Rmd — Flat Rmd (no tabsets, for PDF rendering)
│ ├── dkpp_pdf_version.html — Intermediate HTML used for PDF export
│ ├── 2file_dkpp_full_analysis_PRINT.pdf — Flat PDF version for sharing
│ ├── file1_dkpp_full_analysis.pdf — Earlier PDF export
│ ├── dkpp_analysis.py — Earlier Python analysis (matplotlib / scipy)
│ ├── stats_report.txt — Plain text inferential statistics output
│ └── *.png — 10 chart exports from Python analysis
└── words/ — Source PDFs: annual DKPP Laporan Kinerja 2018–2025
and supporting references
- Case volume trends — how many ethics complaints reached DKPP each year
- Institutional breakdown — KPU vs Bawaslu vs other election bodies
- Regional distribution — which provinces generate the most cases
- Violation categories — what types of ethical breaches are most common
- Principles violated — which DKPP ethical principles are most frequently invoked
- Ruling severity — distribution of sanctions (dismissal, warnings, rehabilitation)
- Election stage analysis — which phases of the election cycle produce the most complaints
- Inferential statistics — correlation, regression, and trend tests across the full 2012–2025 period
| # | Chart |
|---|---|
| 01 | Case Volume Trend |
| 02 | Institution Breakdown |
| 03 | Regional Heatmap |
| 04 | Violation Categories |
| 05 | Principles Violated |
| 06 | Ruling Severity |
| 07 | KPU vs Bawaslu |
| 08 | Election Stages |
| 10 | Regional Outliers |
| 11 | Correlation Matrix |
R Markdown (recommended):
- Open
analysis/dkpp_full_analysis.Rmdin RStudio - Make sure the Excel data files are in the parent directory
- Click Knit to reproduce the full HTML report
Python (exploratory):
cd analysis
python dkpp_analysis.pyRequired R packages: readxl, dplyr, ggplot2, tidyr, knitr, rmarkdown
Required Python packages: pandas, matplotlib, scipy, openpyxl
- DKPP official annual performance reports (Laporan Kinerja) 2018–2025
- DKPP case databases compiled from official records
- Source PDFs archived in
/words/
Analysis produced using R, Python, and Claude Code.