How kavinandan18/attendance-gap-finder works
Project type and purpose
• This is a lightweight, open-source Streamlit web application (“Attendance Gap Finder”) whose primary purpose is to let users upload two data files (main vs. duplicate), compare them, and generate an output Excel file with discrepancies highlighted.
• It is not a microservices or distributed system—rather a single-process, monolithic Python app that runs a small web UI and executes in-memory data processing.
File structure
• Top level:
• attendance_gap_finder.py – the entire Streamlit app (UI + business logic)
• requirements.txt – lists Python dependencies (streamlit, pandas, openpyxl, etc.)
• README.md, LICENSE, .gitignore, sample Excel file
• No separate “frontend” or “backend” folders—they’re combined in one script using Streamlit.
README for additional insights
• Confirms use of Streamlit for interactive UI
• Uses Pandas for data manipulation, Openpyxl for Excel handling
• Outputs a new Excel file with highlighted differences and renders data tables in the browser
Main components
a. User (browser)
b. Streamlit Web Server (attendance_gap_finder.py)
c. Data Input Module
• File-uploader widgets
• Excel/CSV parsers (Pandas + Openpyxl)
d. Comparison Engine
• Pandas DataFrame diff logic
• Identification of missing/differing cells
e. Output Generator
• Excel writer (Openpyxl) with cell-level styling (highlighting)
• DataFrame renderers in Streamlit UI
f. File System / Local Storage
• Temporary in-memory DataFrames
• Generated “highlighted” Excel file on disk (or streamed to user)
Relationships and interactions
• User → uploads main & duplicate files to Streamlit Web Server
• Web Server invokes Data Input Module → reads into DataFrames
• DataFrames flow into Comparison Engine → outputs DataFrames + styling metadata
• Output Generator writes Excel file to local storage (or serves directly) and concurrently renders interactive tables in the browser
• User downloads highlighted Excel or views results in the UI
Architectural patterns / design principles
• Monolithic, single-process architecture
• 3-tier separation (presentation, business logic, data access) logically, even though collocated in one script
• Use of declarative UI (Streamlit) to minimize custom frontend code
• In-memory processing for small/medium datasets
Technologies / frameworks
• Python 3.x
• Streamlit – web UI framework
• Pandas – data manipulation
• Openpyxl – Excel file read/write + styling
• (requirements.txt) used by pip for reproducible environment