Join Mark Niemann-Ross for an in-depth discussion in this video Joins: Inner and full, part of R for Data Science: Lunchbreak Lessons.
- [Instructor] If you're familiar with SQL,…you're familiar with the phrases: INNER JOIN or FULL JOIN.…And you're probably wondering how…to do that with data frames NR.…So, let's take a look at some of the commands…that enable us to emulate INNER JOINS and OUTER JOINS.…First, I need a couple of data frames,…so I'll create df1 and df2.…And it's important to look at…what these things look like;…df1 is a series of rows of capital letters…followed by an index number; one through 26,…df2 is lower case letters followed by an index…of one through, well, not 26.…
It goes 15, 20, and it jumps around a bit.…And that's just to demonstrate how these rules will line up.…We'll use df index as our common key to merge…the two databases together.…So, how do we do an INNER JOIN?…In an INNER JOIN returns rows when there is a match…in both tables.…The command is simple, it's merge.…And I merge df1 with df2.…I'm going to hit control return.…
Down in the console we can see that I have a merge…between df1 and df2.…First of all it gives me the index…
Author
Updated
2/20/2019Released
1/10/2018The five minutes you spend each week will provide you with a building block you can use in the next two hours at work. Review language basics, discover methods to improve existing R code, explore new and interesting features, and learn about useful development tools and libraries that will make your time programming with R that much more productive.
All series code samples can be downloaded at https://github.com/mnr/five-minutes-of-R.
Skill Level Intermediate
Duration
Views
Related Courses
-
R Statistics Essential Training
with Barton Poulson5h 59m Intermediate -
Learning R
with Barton Poulson2h 25m Beginner -
Code Clinic: R (2015)
with Mark Niemann-Ross3h 24m Intermediate -
Integrating Tableau and R for Data Science
with Ben Sullins1h 10m Intermediate
-
New This Week
-
matplot New3m 50s
-
-
Introduction
-
Welcome50s
-
Exercise files36s
-
-
Lunchbreak Lessons
-
R built-in data sets5m 21s
-
Vector math5m 57s
-
Subsetting7m 17s
-
R data types: Basic types7m 34s
-
R data types: Vector5m 16s
-
R data types: List5m 27s
-
R data types: Factor5m 15s
-
R data types: Matrix8m 48s
-
R data types: Array3m 50s
-
R data types: Data frame6m 44s
-
Data frames: Order and merge8m 10s
-
Data frames: Read and update4m 44s
-
Data frames: rbind3m 4s
-
Dataframes: cbind3m 11s
-
apply and lapply3m 21s
-
mapply2m 21s
-
plot2m 45s
-
Brackets and double-brackets2m 50s
-
mean, rowMeans, and colMeans1m 49s
-
RSQLite3m 44s
-
sqldf2m 9s
-
Aggregate3m 17s
-
Random numbers4m 26s
-
Pipeline4m 42s
-
Working with clipboards2m 45s
-
Style guides3m
-
cut3m 17s
-
split3m 44s
-
askYesNo3m 48s
-
cdplot5m 32s
-
Fun3m 18s
-
boxplot2m 33s
-
Histogram3m 40s
-
Plot to file6m 2s
-
coplot4m 3s
-
cowsay2m 40s
-
table2m 48s
-
Look inside3m 21s
-
barplot2m 32s
-
Pie chart2m 11s
-
unlist3m 24s
-
Joins: Inner and full3m 3s
-
Joins: Left and right2m 13s
-
Sets: Equal and in2m 14s
-
colors2m 25s
-
ifelse3m 5s
-
spineplot2m 36s
-
browser3m 37s
-
debugonce2m 25s
-
Default mirror2m 31s
-
Dealing with NA6m 1s
-
Using with()2m 55s
-
Simple string matching4m 35s
-
grep2m 53s
-
dotchart3m 54s
-
fourfoldplot3m 34s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Joins: Inner and full