Tamil Nadu is often held up as a success story in Indian higher education — wide access, a dense network of colleges, strong enrolment. I wanted to check a narrower question against the actual government data: of all those colleges, how many can the national systems actually see?
The answer surprised me, so I built a small site to show it: The State of Tamil Nadu's Colleges.
What the data says
Tamil Nadu has 2,829 colleges (AISHE 2021-22). Only 84 appear in any NIRF 2025 ranking. That is 97.0% invisible — operating with no public quality signal at all.
Half of the ranked institutions sit in two cities. Chennai and Coimbatore together hold 51% of every ranked institution in the state.
Several large districts — Kancheepuram, Namakkal, Kanniyakumari, Viluppuram — have zero nationally ranked institutions despite having 80+ colleges each.
And year on year, the state lost ground: comparing NIRF 2024 to 2025, 83 Tamil Nadu institutions slipped in rank while only 36 climbed.
None of these numbers exist on the NIRF or AISHE sites directly. They come from joining three datasets that nobody combines.
The interesting part was the data, not the charts
This was less a visualization project than a data-cleaning one. Three lessons that cost me real time:
Government PDFs lie about their structure. The UGC list of accredited colleges is a 149-page PDF where the state name sits in a merged cell that renders at the vertical centre of each block — not the top. My first parser confidently assigned hundreds of Andhra colleges to the Andaman Islands. The fix was to stop trusting cell position and anchor on a fixed list of 36 state names instead. Detect known values; never trust layout.
A silent join can hand you a confident, wrong answer. When I joined the accredited list to the AISHE base, Chhattisgarh came back at 0% accredited. It wasn't — one source spells it Chhattisgarh, the other Chhatisgarh. The join matched nothing and returned a clean, publishable, completely false zero. The only reason I caught it is that I knew Chhattisgarh has ~199 accredited colleges. Always sanity-check a join against a number you already know.
"Current" data is rarely as current as you'd like. NIRF publishes its rankings before it publishes the detailed scorecards. When I refreshed to 2025, the whole College category's scorecard PDFs were still stubs. Rather than mix vintages silently, every scorecard on the site now states which year its data comes from, and 55% honestly say "2024, because the 2025 version isn't out yet."
How it works
Collection — NIRF ranking tables and per-institute scorecard PDFs, the UGC accredited list, the AISHE college base from data.gov.in. All public, all official, all cited.
Cleaning and joining — pandas and pdfplumber, fuzzy name matching with rapidfuzz (with a distinctive-word guard, because "SNS College of Technology" scores 92 against "PSG College of Technology" on tokens alone).
The site — a single static HTML page with a d3 choropleth of the 32 districts and a search over all 2,500 colleges. No backend; the whole thing is JSON files and runs free on GitHub Pages.
Honest limitations
I'd rather state these than have someone find them. District-level counts use the 2012-13 AISHE college list (the most recent cleanly downloadable one). Ranked counts are matched to districts by the institution's listed city, so a district shown as a "desert" means none were matched there, not a guaranteed zero. "Invisible" means not in NIRF, which only ranks ~100 per field — it is not a verdict on any college's quality. Full notes are on the site.
Try it
Live: https://bubblywolf.github.io/tamil-nadu-college-visibility/
You can search any college in the state and, if it's ranked, see exactly which parameter is dragging it down relative to its peers.
Data from public NIRF, AISHE and UGC sources; this is an independent project, not affiliated with any government body.
Top comments (0)