<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Sarah Mitchell</title>
    <description>The latest articles on DEV Community by Sarah Mitchell (@sarah_mitchell_175f7d2828).</description>
    <link>https://dev.to/sarah_mitchell_175f7d2828</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4035512%2F32edb47d-79b7-488b-9d14-bcd8cc26497e.png</url>
      <title>DEV Community: Sarah Mitchell</title>
      <link>https://dev.to/sarah_mitchell_175f7d2828</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/sarah_mitchell_175f7d2828"/>
    <language>en</language>
    <item>
      <title>Building an Indian School Search Engine: Working with UDISE+ Datasets &amp; Crawler Architecture</title>
      <dc:creator>Sarah Mitchell</dc:creator>
      <pubDate>Sat, 18 Jul 2026 15:37:09 +0000</pubDate>
      <link>https://dev.to/sarah_mitchell_175f7d2828/building-an-indian-school-search-engine-working-with-udise-datasets-crawler-architecture-1gk8</link>
      <guid>https://dev.to/sarah_mitchell_175f7d2828/building-an-indian-school-search-engine-working-with-udise-datasets-crawler-architecture-1gk8</guid>
      <description>&lt;p&gt;Managing and indexing educational data at a national scale is a challenging task. In India, the Unified District Information System for Education (UDISE+) provides comprehensive statistics for over 1.5 million schools.&lt;/p&gt;

&lt;p&gt;In this case study, we will discuss the architecture of a custom crawler and parser built to index this data into a searchable portal.&lt;/p&gt;

&lt;p&gt;The Challenge: Data Volume &amp;amp; Standardization&lt;br&gt;
The raw UDISE+ directories contain diverse datasets across multiple states:&lt;/p&gt;

&lt;p&gt;Over 1.5 million school entries.&lt;br&gt;
Detailed metadata including student enrollment, board affiliations (CBSE, ICSE, State Boards), teacher strengths, and infrastructure logs.&lt;br&gt;
Database Parser Architecture&lt;br&gt;
To process this, we built a Python-based parser using Pandas to normalize state records:&lt;br&gt;
import pandas as pd&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;normalize_school_data&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;file_path&lt;/span&gt;&lt;span class="p"&gt;):&lt;/span&gt;
    &lt;span class="c1"&gt;# Load state school records
&lt;/span&gt;    &lt;span class="n"&gt;df&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;read_csv&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;file_path&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;

    &lt;span class="c1"&gt;# Standardize UDISE codes
&lt;/span&gt;    &lt;span class="n"&gt;df&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;udise_code&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;df&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;udise_code&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;astype&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nb"&gt;str&lt;/span&gt;&lt;span class="p"&gt;).&lt;/span&gt;&lt;span class="nb"&gt;str&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;zfill&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;11&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="n"&gt;df&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;school_name&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;df&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;school_name&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nb"&gt;str&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;upper&lt;/span&gt;&lt;span class="p"&gt;().&lt;/span&gt;&lt;span class="nb"&gt;str&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;strip&lt;/span&gt;&lt;span class="p"&gt;()&lt;/span&gt;

    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="n"&gt;df&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Working Implementation&lt;br&gt;
You can check the working search engine index and query performance live on the SchoolsPedia Directory.&lt;/p&gt;

&lt;p&gt;For structural references:&lt;/p&gt;

&lt;p&gt;See how we parsed district registries for the Uttar Pradesh Schools Registry.&lt;br&gt;
Inspect the block-level normalization index on the Bihar Schools Directory.&lt;br&gt;
Test the search query parser performance on the CBSE Schools Index.&lt;/p&gt;

</description>
      <category>python</category>
      <category>datascience</category>
      <category>webdev</category>
      <category>architecture</category>
    </item>
  </channel>
</rss>
