Skip to Main Content

Quantitative Analysis Guide

Resources and support for statistical and numerical data analysis

This page graphically illustrates 15 different ways of combining two related data tables and provides the sample code for doing so in Tableau, SPSS, JMP, Stata, SAS, R, MATLAB, and Python. The sample files are available below. 


This table illustrates basic types of joining of flat data sets containing common key variables.

Merges and Joins examples

Concatenating (merging without keys)

Concatenating

Adding Rows (without pairing)

Adding Rows without pairing

Adding Rows (with pairing)

Adding Rows with pairing


This type of merge is not available through SPSS menu dialogs.


This type of merge is not available through SPSS menu dialogs.


This type of merge is not available through SPSS menu dialogs.


This type of merge is not available through SPSS menu dialogs.


This type of merge is not available through SPSS menu dialogs.


This type of merge is not available through SPSS menu dialogs.

Creative Commons License logo.
Original work in this LibGuide is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Accessibility (opens in new window)