Tidy New York: Wrangling Pedestrian Count Data

I’m a huge fan of open data. I am especially fascinated by data related to transportation and urbanism, anyhting that I can put on a map that would represent some part of how we move and live in cities. That is why I was super excited to find that New York City collects and shares data on pedestrian counts in more than 100 locations across the city. However, the CSV dataset I downloaded needed a lot of love and care -in the form of wrangling- before it reached tidy formatting that could allow me to easily explore it by plotting it in maps and charts. Read more