PDF to Excel Parser - College Cutoff Data

Parse Maharashtra Engineering CAP 2024 cutoff data from PDF and export to Excel.

Installation

pip install -r requirements.txt

Usage

python pdf_parser.py

This will:

1. Parse 2024ENGG_CAP1_CutOff-1-6.pdf
2. Extract all cutoff data from all 6 rounds
3. Create college_cutoff_data.xlsx with two sheets:
   • Cutoff Data: All parsed records with columns: Round, College Code, Institute Name, City, Branch Code, Branch Name, Seat Number, Category, Cut Off Percentage
   • Summary: Statistics including totals, cutoff ranges by round, and top colleges

Output Format

Cutoff Data Sheet

Round	College Code	Institute Name	City	Branch Code	Branch Name	Seat Number	Category	Cut Off Percentage

Summary Sheet

• Total records, rounds, colleges, branches
• Cutoff statistics by round (min, max, average)
• Top 10 colleges by average cutoff

Requirements

• Python 3.8+
• pdfplumber >= 0.11.0
• pandas >= 2.0.0
• openpyxl >= 3.1.0