---
title: "UIDAI Aadhaar Data Analysis Pipeline"
description: "I cleaned and analyzed 4.4M Aadhaar enrollment records — removed 602K duplicates, standardized 65 state-name variants down to 38 — and served the results through a 14-endpoint Flask API."
canonical: "https://shivanshutiwari.in/projects/uidai-aadhaar-analysis"
lastUpdated: "2026-09-02"
---

# UIDAI Aadhaar Data Analysis Pipeline

I cleaned and analyzed 4.4M Aadhaar enrollment records — removed 602K duplicates, standardized 65 state-name variants down to 38 — and served the results through a 14-endpoint Flask API.

**Stack:** Python, Flask, pandas  
**Date:** 2025  

## The Honest Part

I caught my own bug during the audit: a hardcoded summary in one script is off by about 40K records from the real cleaned total. I don't have git history or a deployment beyond localhost yet.

## Highlights

- Cleaned 4.4M records: removed 602K duplicates, standardized 65 state-name variants down to 38
- 14-endpoint Flask API serving the cleaned dataset
- Honestly flagged its own bug: hardcoded summary is off by ~40K from the real cleaned total

---
*Source: https://shivanshutiwari.in/projects/uidai-aadhaar-analysis*