JLGet in touch
← Selected workCase study / 02 of 05Jump to demo ↓

02 / TELECOM DATA QUALITY

Bulk RAN design-to-installation audit

A Python and SQL workflow cleans and joins client design tables with fragmented current-state exports from Huawei Master MAE. It audits hundreds of sites by technology and points reviewers to the exact cell and parameter that needs attention.

PythonSQLPandas2G / 3G / 4G / 5G
FocusAudit sites in one batchMissing configuration and design mismatches, down to cell level.

My contribution: cleaning and joining separate design and live-state exports, then checking parameters across hundreds of sites. Decision it supports: which cells need a configuration correction before sign-off.

Technical approach · join keys and NULL handling

The audit runs separately for 2G, 3G, 4G, and 5G. Records are matched by site ID, cell, and technology after normalizing source formats, then the requested values are compared with the installed configuration.

A NULL value is kept distinct from zero: it signals that a parameter has not been configured and receives a warning. Mismatches become alarms, summarized by site with cell-level detail for investigation.

INTERACTIVE DEMO

Mass configuration audit

Synthetic batch · Browser illustration of the workflow
01Client designOne dataset per technology
02Master MAE exportsCell, radio and antenna reports
03Clean + joinSite ID + cell + technology
04Audit resultSite alarms and cell details
Sites audited—
Cell rows joined—
Sites with alarms—
Sites with warnings—
Site results

Choose a site to inspect the affected cells and parameters.

—Click to inspect
Site IDCellsAlarmsWarningsResult
SELECTED SITE
—

Illustrative data only. In the actual project, Python and SQL process the source files; this demo reproduces the comparison rules in your browser. NULL means a parameter is not configured and is shown as a warning.