Module Overview

The running dataset is a multi-site facility energy & environment log - data every engineering discipline works with. Examples that lean toward one field are tagged inline, e.g. # [Industrial].

Learning Outcomes

• Load, clean, and transform tabular data from real engineering sources
• Filter, sort, group, and aggregate datasets confidently
• Handle missing data and inconsistent units - a common reality in field data
• Merge multiple data sources (e.g. an equipment register + a service-contract table)

Note on data: the site-energy, sector-demand, and service-contract datasets in this notebook are synthetically generated with fixed random seeds so every learner sees the same numbers and every cell is reproducible offline. They mimic the structure, units, and quirks (missing values, duplicates, inconsistent units) of a real building management system or SCADA historian export.

Run cells top to bottom - later lessons reuse DataFrames built in earlier ones.

---