edfEazyDataFix

Hospital Dataset

Assess a hospital admissions dataset with mixed dtypes and PII.

Overview

A realistic hospital admissions extract with 30,000 rows. Combine profile() and assess() to plan a safe cleaning strategy.

Dataset

hospital.csv30,000 rows × 21 columns
patient_idagegenderadmission_datediagnosis...

Python code

hospital.py
import pandas as pd
import eazydatafix as edf

df = pd.read_csv("hospital.csv")
prof = edf.profile(df, sample=10_000)
report = edf.assess(df)
report.summary()

Expected output

Python 3.11
>>> prof = edf.profile(df, sample=10_000)
>>> prof.columns['age']
ColumnProfile(age) min=0 max=104 mean=42.3
CSV Cleaning
Load a messy CSV, assess quality and export a cleaned copy.
Excel Cleaning
Handle merged cells, blank rows and inconsistent columns from .xlsx workbooks.
HR Dataset
Detect duplicate employee records and normalise department names.