Get started with your first joining verb: inner-join! You'll learn to join tables together to answer questions about the LEGO dataset, which contains information across many tables about the sets, parts, themes, and colors of LEGOs over time.  


The inner_join verb

What columns would you join on?

Joining parts and part categories

Joining with a one-to-many relationship

Joining parts and inventories

Joining in either direction

Joining three or more tables

Joining three tables

What's the most common color?

Joining Tables

Learn two more mutating joins, the left and right join, which are mirror images of each other! You'll learn use cases for each type of join as you explore parts and colors of LEGO themes. Then, you'll explore how to join tables to themselves to understand the hierarchy of LEGO themes in the data. 

Verba left_join

Left join dua set berdasarkan part dan color

Left join dua set berdasarkan warna

Mencari observasi yang tidak memiliki pasangan

Kata kerja right_join

joins

inner

left

right

Join mana yang paling tepat?

Menghitung warna komponen

Merapikan hasil hitung Anda

Menggabungkan tabel dengan dirinya sendiri

Menggabungkan theme dengan anaknya

Menggabungkan theme dengan cucu mereka

Left join pada tabel yang sama

Left and Right Joins

In this chapter, you'll cover three more joining verbs: full-join, semi-join, and anti-join. You'll then use these verbs to answer questions about the similarities and differences between a variety of LEGO sets. 

The full_join verb

Differences between Batman and Star Wars

Aggregating each theme

Full joining Batman and Star Wars LEGO parts

Comparing Batman and Star Wars LEGO parts

The semi_join and anti_join verbs

Select the join

Something within one set but not another

What colors are included in at least one set?

Which set is missing version 1?

Visualizing set differences

Aggregating sets to look at their differences

Combining sets

Visualizing the difference: Batman and Star Wars

Full, Semi, and Anti Joins

Put together all the types of join you learned in this course to analyze a new dataset: Stack Overflow questions, answers, and tags. This includes calculating and visualizing trends for some notable tags like dplyr and ggplot2. You'll also master one more method for combining tables, the bind_rows verb, which stacks tables on top of each other.

Stack Overflow questions

Left joining questions and tags

Comparing scores across tags

What tags never appear on R questions?

Joining questions and answers

Finding gaps between questions and answers

Joining question and answer counts

Joining questions, answers, and tags

Average answers by question

The bind_rows verb

Joining questions and answers with tags

Binding and counting posts with tags

Visualizing questions and answers in tags

Congratulations!

Case Study: Joins on Stack Overflow Data

sets

themes

parts

part_categories

inventories

inventory_parts

colors

questions

question_tags

answers

Dalam data science, Anda sering menemukan data menarik yang tersebar di banyak tabel. Kursus ini akan mengajarkan keterampilan yang Anda perlukan untuk menggabungkan banyak tabel agar dapat dianalisis secara terpadu. Anda akan berlatih menggunakan himpunan data menyenangkan tentang LEGO dari situs Rebrickable. Himpunan data ini memuat informasi tentang set, bagian, tema, dan warna LEGO, namun tersebar di banyak tabel. Anda akan bekerja dengan data ini sepanjang kursus sambil mempelajari total enam jenis join! Anda akan mempelajari empat mutating join: inner join, left join, right join, dan full join, serta dua filtering join: semi join dan anti join. Pada bab terakhir, Anda akan menerapkan keterampilan baru Anda pada data Stack Overflow yang berisi hampir 300.000 pertanyaan Stack Overflow ber-tag R, termasuk informasi tentang jawaban, tanggal pertanyaan diajukan, dan skornya. Bersiaplah untuk meningkatkan kemampuan dplyr Anda ke tingkat berikutnya!

Data Manipulation with dplyr 

Pelajari cara menggabungkan data dari beberapa tabel dengan dplyr. Anda akan mempelajari 6 jenis join.

Menggabungkan Data dengan dplyr

Pelajari cara menggabungkan data dari beberapa tabel untuk menjawab pertanyaan yang lebih kompleks menggunakan dplyr.

Associate Data Scientist di R

Analis Data  di R

Manipulasi Data  di R

Anda ingin hanya menyimpan observasi yang cocok persis di antara tabel.

Anda ingin menyimpan semua observasi di tabel pertama, termasuk observasi yang cocok di tabel kedua.

Anda ingin menyimpan semua observasi di tabel kedua, termasuk observasi yang cocok di tabel pertama.

Join mana yang paling tepat?

Menggabungkan Data dengan dplyr

Latihan interaktif praktis