Software Development
Data

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 the conversation!

Find news, events, jobs and people who share your interests on Technical.ly's open community Slack

Trending

Philly daily roundup: Student-made college cost app; Central High is robotics world champ; Internet subsidy expiration looms

Philly daily roundup: Earth Day glossary; Gen AI's energy cost; Biotech incubator in Horsham

Philly daily roundup: Women's health startup wins pitch; $204M for internet access; 'GamingWalls' for sports venues

Gain knowledge and skills at the Technical.ly Developers Conference during Philly Tech Week 2024

Technically Media