edfEazyDataFix

Excel Cleaning

Handle merged cells, blank rows and inconsistent columns from .xlsx workbooks.

Overview

Excel exports frequently contain merged header rows, stray notes and inconsistent dtypes. This example shows the recommended pipeline.

Dataset

sales_q3.xlsx3,411 rows × 8 columns
order_idcustomerregionamountdate...

Python code

excel-cleaning.py
import eazydatafix as edf

result = edf.fix(
    "sales_q3.xlsx",
    strategy="auto",
    fill_missing="median",
)
result.to_excel("sales_q3.clean.xlsx")

Expected output

Python 3.11
>>> result = edf.fix("sales_q3.xlsx")
FixResult(rows=3,407, fixes=5)
CSV Cleaning
Load a messy CSV, assess quality and export a cleaned copy.
Hospital Dataset
Assess a hospital admissions dataset with mixed dtypes and PII.
HR Dataset
Detect duplicate employee records and normalise department names.