KCMO Building Efficiency Tutorial 1: Dataset merging

Author

Joseph Bodenheimer

Material Description

This tutorial introduces a step-by-step workflow for exploring and preparing Kansas City building datasets from two different years for merging. It covers loading the data, standardizing key columns into a shared format, checking data completeness, data cleaning, and normalizing content. The module also shows how to perform exact matches by ID and address, leaving a smaller unresolved set for fuzzy matching in the next tutorial.

Module Materials

You can access the material here

This Material is under the CC BY license

Back to top