Gravatar Image

Frank Corso

Solving data challenges for growing companies

Currently accepting new data projects

I have 2–3 spots available for companies who have data challenges they need solved.

Articles about scatterplot

Apple Podcasts Charts Weekly Ranking Changes for Science Podcasts in US

Published on

I was recently working with Apple Podcasts charts data and was curious how much the charts change week-to-week. I am already scraping some Apple Podcasts charts already for a separate project, so I decided to look at the Science category for the US charts.

It turns out that the top few podcasts are fairly stable, but even just in the top 20, the podcasts change quite a bit.

Revenue vs Number of Employees for Fortune 500

Published on

I am working on a new guide for creating scatterplots with the Python Seaborn package and thought I’d use a Fortune 500 dataset for the examples. I was curious to see how revenue compares against the number of employees.

I discovered that Walmart and Amazon have 5x as many employees as the next companies, so I couldn’t even see most of the companies on the chart with them in it. I didn’t realize just how large their workforce is.

After removing them, I noticed a couple of interesting points:

  1. CVS is grouped closer to the healthcare and tech companies than the retail companies
  2. Exxon Mobil has extremely high revenue per employee, even higher than a lot of tech companies

Of course, revenue only reflects raw sales, and we’d have to look at profit and EBITA to really see where the differences are. But, it was still fun to explore with.

Scatterplot with title of Revenue vs Number of Employees for Fortune 500. The number of employees goes 0 to over 400,000 and revenue goes 0 to over 400 billion dollars in USD. Some of the outliers are labelled, such as Target and Home Depot having higher employees but only mid-range of revenue with CVS, Alphabet, Apple, and Exxon Mobile having much higher revenue with fewer employees.

Creating A Scatterplot Chart In Seaborn

Published on

Scatterplots are a great way to visualize relationships between different dimensions. Learn how to create them in Python using Seaborn.

Read data story

119th Congress Bills Introduced Per Member

Published on

I was curious to know how many bills a U.S. Congress member introduces or co-sponsors. It turns out that most don’t introduce new bills often.

Many have only introduced a handful since the start of this term.

A scatterplot titled 119th Congress Bills Introduced Per Member with subtitle of A look at the number of bills sponsored (introduced) and cosponsored by members of the 119th Congress so far. The chart shows that most members have only sponsored a dozen or two bills this year but often cosponsor 100+. Though, there are many who have sponsored over 100 bills.