Exploratory
Search…
Exploratory
Introduction
Product Features
Data Import
Data Wrangling
Command Line mode for faster and more flexible data interaction in Exploratory
Select / Remove Columns
Reorder Columns
Create New Calculation
Create New Calculation for Multiple Columns
Summarize (Aggregate)
Group
Filter
Rename
Arrange (Sort)
Top / Bottom N
Join
Merge
Gather
Spread
Pivot
Expand
Complete
Separate
Unite
Bind Rows
Bind Columns
Keep Only Unique Rows
Keep Only Duplicated Rows
Slice
Drop NA
Sample
Impute NA
Fill
Create Buckets
Assign New Values to Existing Values - Recode
Assign New Values by Setting Conditions - Case When
Work with Categories
Data Type Conversion
Row as header
Ungroup
Unnest
Separate List Items into Columns (Unnest Wider)
Separate List Items into Rows (Unnest Longer)
Separate Address (Japan)
Hoist
Remove Empty Rows
Remove Empty Columns
Clean Column Names
Window Calculation
Window Calculation (日本語)
Add Row
Text Wrangling
Regular Expression Cheat Sheet
Regular Expression Cheat Sheet (日本語)
Visualization
Analytics
Statistics
Machine Learning
Text Analysis
Extend with R
Setup
Diagnostics
Keyboard shortcuts
Powered By GitBook
Join
Join rows from the data frame with rows from another data frame by matching values of key columns.

How to Access This Feature

From + (plus) Button

From Column Menu

How to Use This Feature

  1. 1.
    Select "Join Type".
  • Left Join - Return all rows from the current data frame, and all columns from the current and the target. Rows in the current with no match in the target will have NA values in the new columns. If there are multiple matches between the current and the target, all combinations of the matches are returned.
  • Right Join - Return all rows from the target data frame, and all columns from the current and the target.
  • Full Join - Return all rows and all columns from both the current data frame and the target data frame.
  • Inner Join - Return all rows from the current data frame where there are matching values in the current, and all columns from the current and the target.
  • Semi Join - Return all rows from the current data frame where there are matching values in the target data frame, keeping just columns from the current.
  • Anti Join - Return all rows from the current data frame where there are not matching values in the target, keeping just columns from the current.
  1. 1.
    Select "Target Data Frame".
Select the other data frame to join current data frame with.
  1. 1.
    Select "Current Column" and "Target Column". "Current Column" is a column from current data frame, and "Target Column" is a column from target data frame. When a row from current data frame and a row from target data frame have same values in those columns, the rows are joined into one row in the resulting data frame.
  2. 2.
    Enable "Case Insensitive Join" (Optional)
    If you want to join two data frames by ignoring case of the join key column value, select this checkbox.
  3. 3.
    Specify "Current Columns Suffix" and/or "Target Columns Suffix" (Optional) These are the suffixes to distinguish columns from current data frame and columns from target data frame in the resulting data frame, when there are columns with same names in both data frames. Note that those suffixes are applied only to column names that appear both in current and target data frames.
  4. 4.
    Click "Run" button.

References

Previous
Top / Bottom N
Next
Merge
Last modified 9mo ago
Copy link
Outline
How to Access This Feature
From + (plus) Button
From Column Menu
How to Use This Feature
References