The dataset I used for this activity is a simulated Hospital Patient Dataset that captures anonymized records of patients across various departments in a hospital. It consists of over 100 rows (individual patient records) and eleven columns, each representing a specific attribute about the patient or their treatment.
🧾 Columns:
Patient ID – A unique alphanumeric code assigned to each patient for identification without disclosing their personal information.
Name – The full name of the patient, used in administrative and internal records.
Date of Birth (DOB) – The patient’s date of birth, helping determine their age for treatment planning and demographic insights.
Gender – The gender identity of the patient (Male, Female, or Other), which can be useful in analyzing gender-based health trends.
Medical Condition – The primary health issue or diagnosis that led the patient to seek medical attention (e.g., Diabetes, Fracture, Pneumonia).
Treatments – A brief description of the medical procedures or therapies administered to the patient (e.g., Surgery, Medication, Physiotherapy).
Doctor’s Note – A summary note from the attending physician outlining key observations, recovery advice, or follow-up requirements.
Admit Date – The date on which the patient was admitted to the hospital.
Discharge Date – The date on which the patient was discharged after treatment completion.
Bill Amount – The total cost incurred by the patient for their hospital stay and treatment, in INR (₹).
🔍 Observations:
Cardiology and Orthopedics were the most frequently visited departments, suggesting these are high-demand specializations in the hospital.
Patients in the 51+ age group had significantly longer average stays, particularly in departments like Cardiology, which could indicate age-related chronic conditions.
Fever and minor infections often resulted in the shortest stays (1–2 days), while more serious conditions like heart issues or fractures involved longer recovery periods (up to 10+ days).
The gender distribution was nearly equal, which implies balanced representation in patient care across all departments.
This dataset helped me understand how demographic and departmental data can be analyzed to gain insights about patient behavior and hospital resource usage. I found it especially interesting to notice how age and diagnosis were strongly linked to the length of hospital stay. It shows how statistical tools can reveal real-world patterns that can help in better planning of healthcare resources.