In the world of data cleaning, two approaches often stand out: Python, the go-to for coding enthusiasts, and Excel’s Power Query, a code-free, user-friendly alternative.

The data include the network of bike routes, lanes, and paths around the city of San Francisco. Maintained by the SFMTA. Since this data is subject to change, we downloaded it on June 28th, 2016. The ...