Merge Initial Data with airSlate SignNow

Merge initial data

hello everyone and welcome to introduction to our part 17 merging data so when you work with datasets you'll often not have everything you need all in a single file that you can load in sometimes the data you want to work with will be spread out across multiple files and when you work with them you'll want them all in one data frame so you can use everything all at the same time so to take data from two different files and join them together into one data frame you need to merge the data also known as performing a join so in this short lesson we're just going to show how to do that using base our first I'm going to load in some data that we're just generating as a toy example of how to do data merging so it's just going to be two tables of fake medical data it has a patient ID and some other columns and then there's a second table that also has a patient ID column and then some different different data variables so when you're joining or merging data you need to have some column in common between the two tables so that you know which records are associated with which variables so in this case above we can see for instance this patient with ID one appears in both tables so that means even though we don't know the height and weight for this patient if we only have access to this table or vice versa we don't know what the visits are checkup is if we only have access to this table and so we have this patient ID number we can match this patient in this table to the same patient and the other table and join them together so that we have every single column for that patient in one big table so we we want height weight and all these other variables all in one table and to do that we need this key column to perform the joint upon so that is a very important thing to know when you're doing merging that you always need some column you're gonna join on you can join on multiple columns if there are multiple columns and common so we'll also show how to do that but we'll just start with one so to perm merge or join in base are you use the merge function the first argument X is just the first data frame or table that you want to join the second argument Y is set equal to the second table and then the by argument you set equal to that key column that you want to use to join on so in this case we want to use that patient ID or PID column so that's what we're going to put for that and then we'll run this merge and we'll just print it out to see what the resulting table is but...