Constructed Career Paths from Job Switching Data

You can do anything you want to do.

“It means your future hasn’t been written yet. No one’s has. Your future is whatever you make it.” —Emmett Brown

People switch jobs all of the time. Oftentimes the switch is to something related, and other times the career path swerves in a completely different direction.

We saw the former when we looked at the most common jobs people switched to, given their current occupation. For example, computer programmers most often switched to computer systems analysts. This was based on several years of data from the Current Population Survey.

I was curious. What if you consider this a connection — like in a network graph — between two occupations? More specifically, I wondered if, given that you already have a job, what is the shortest path to get to another job?

The chart below, mostly for fun, shows the shortest path for all of the jobs using the same dataset.

For example, for a statistician to become a chef, one could become an operations research analyst, then a manager, and into that head chef spot.

This path comes about because a surveyed person from the CPS was a statistician who became an operations research analyst. At some point during the sampled period, an operations research analyst became a manager. And finally, a manager became a head chef. Easy peasy.

So in forming these connections, I imagine the occupation switches belong to one person, when of course, I’m looking at a group of people. That means these are imaginary paths rooted in reality. But you know, if you’re a mortician who dreams of being an artist, you don’t actually have to become an elementary school teacher first. You can probably strive for the direct path.

What path will you take?

Shifting Jobs

These are the most common jobs that people switched to.

Notes

  • The source data comes from the Current Population Survey, 2011 through 2016. I downloaded the microdata using the IPUMS CPS extraction tool. The survey asks people what their current occupation is and what it was the previous year. I looked at the people who had different answers.
  • This interactive only shows the shortest path for each pair of occupations. Many occupation pairs had several paths between them.
  • I analyzed and prepared the data in R. I made the interactive with d3.js.

Become a member. Support an independent site. Make great charts.

See What You Get

Learn to Visualize Data See All →

Moving Past Default R Charts

Customizing your charts doesn’t have to be a time-intensive process. With just a teeny bit more effort, you can get something that fits your needs.

Getting Started with Charts in R

You get a lot of bang for the buck with R, charting-wise, but it can be confusing at first, especially if you’ve never written code. Here are some examples to get started.

How to Flatten the Curve, a Social Distancing Simulation and Tutorial

Using R, we look at how your decreased interaction with others can help slow the spread of infectious diseases.

How to Make a State Map Grid with Small Multiples in R

Combining small multiples with the grid layout can make for an intuitive geographic reference.

Favorites

Where Bars Outnumber Grocery Stores

A closer look at the age old question of where there are more bars than grocery stores, and vice versa.

Peak Non-Creepy Dating Pool

Based on the “half-your-age-plus-seven” rule, the range of people you can date expands with age. Combine that with population counts and demographics, and you can find when your non-creepy dating pool peaks.

Finding the New Age, for Your Age

You’ve probably heard the lines about how “40 is the new 30” or “30 is the new 20.” What is this based on? I tried to solve the problem using life expectancy data. Your age is the new age.

Watching the Growth of Walmart

The ever so popular Walmart growth map gets an update, and yes, it still looks like a wildfire. Sam’s Club follows soon after, although not nearly as vigorously.