Hospitals manage large volumes of data with missing, inconsistent, and invalid entries.
Manual report generation is time-consuming, error-prone, and inconsistent.
This project automates:
- 🔹 Cleaning patient & visit records (NaN handling, invalid values)
- 🔹 Department-wise patient load analysis
- 🔹 Monthly visit trends & demographic summaries
- 🔹 Auto-generated Excel report with interactive charts
- Top 3 departments with highest patient load
- Monthly patient trend showing peak & low seasons
- Demographic breakdown (age, gender, visits)
- Operational inefficiencies (no-shows, duplicate records, invalid IDs
- Clone this repo
- Install dependencies:
pip install pandas matplotlib openpyxl - Run the Jupyter Notebook