Whether your data comes from files, databases, or both, you’ll need to master joins, as most software requires one large table of data to reference for analysis. Your data sets will come from a lot of different sources, so being able to combine them is key. This will allow you to take columns from each data source and use them alongside one another in the output. The rows of data they contain are added to the resulting data set.
Most of the examples in this chapter will use the 2019: Week 29 inputs. We will cover the logic and terminology for working with joins, how to join data sets together in Prep Builder, and which type of join to use in different situations.
How to Join Data Sets in Prep Builder
Joining separate data sources is very easy in Prep Builder. Simply drag one data source toward another, and Prep Builder will give you a number of options (Figure 16-1).
Figure 16-1. Dragging one step toward another triggers the Join/Union options
By dragging the second data set (in this case Subscription Pricing) to the original (blue) data flow (Clean 2), you’ll be given the option to union or join the data sets. If you hover over the Join option and then release the mouse button, Prep Builder will automatically link the two flows of data together (Figure 16-2).
Figure 16-2. The Join step in Prep
Another approach to joining two data sets ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
