Software Development

Where is Philly’s best and worst coffee?

A visualization of Yelp data sheds some light on which neighborhood has the best java.

Philly's worst cup of joe is, unsurprisingly, at the airport. (Video by YouTube user Free footage, used under a Creative Commons license)

Turns out that Delaware’s most eminent parenting nerds, Dan and Lynsey Larson, went and moved to Philly last March, their two adorable kids in tow.

As the couple settled into their new town due to Dan’s new job at Drexel University, the first question from the caffeine-obsessed couple was: where’s the good coffee?

Naturally, they found the answer in data.

“Sure, we could have simply done a survey or asked some people we know in the area, but that’s crazy talk,” Larson wrote in a blog post. So he took to the dev console and pulled all the Yelp ratings for Philly coffee shops, transposed the data onto a Tableau dashboard and voilà:

<a href=’#’><img alt=’Philadelpia Coffee ‘ src=’https://public.tableau.com/static/images/7H/7HY3C64NZ/1_rss.png’ style=’border: none’ /></a>

var divElement = document.getElementById(‘viz1499694531058’); var vizElement = divElement.getElementsByTagName(‘object’)[0]; vizElement.style.width=’654px’;vizElement.style.height=’1229px’; var scriptElement = document.createElement(‘script’); scriptElement.src = ‘https://public.tableau.com/javascripts/api/viz_v1.js’; vizElement.parentNode.insertBefore(scriptElement, vizElement);

The first takeaway: University City has all the best-ranked coffee spots on Yelp, likely due to all the caffeine-crazed students in the area. Also interesting: the raw numbers: There are 816 coffee establishments in Philadelphia, including 94 Dunkin’ Donuts and 48 Starbucks.

Read the full post
Engagement

Join our growing Slack community

Join 5,000 tech professionals and entrepreneurs in our community Slack today!

Donate to the Journalism Fund

Your support powers our independent journalism. Unlike most business-media outlets, we don’t have a paywall. Instead, we count on your personal and organizational contributions.

Trending

Got a startup idea? This new Philly venture studio wants to find founders at their earliest steps

Despite Trump's actions and rhetoric, Ukrainian tech workers are laying stakes in the US  

How tech and entrepreneurship can boost economic mobility

5 things in the office you can't duplicate with work from home

Technically Media