How to Combine Multiple Datasets

Author(s): Angelica Lo Duca

Originally published on Towards AI.

A description of the append and joining strategies, with a practical example in SQL.

This member-only story is on us. Upgrade to access all of Medium.

Photo by Tekton on Unsplash

How many times have we been faced with two datasets to combine or integrate? Maybe we have datasets that contain the same information but refer, for example, to different years. Or we have to merge datasets that have something in common, but that contain different information.

So how do you combine two or more datasets?

Many strategies exist. In this article, I focus on two strategies for datasets combination:

appendjoin

I also propose two practical examples of how to perform both combinations in SQL.

Let us suppose that we have… Read the full blog for free on Medium.

Join thousands of data leaders on the AI newsletter. Join over 80,000 subscribers and keep up to date with the latest developments in AI. From research to projects and ideas. If you are building an AI startup, an AI-related product, or a service, we invite you to consider becoming a sponsor.

Published via Towards AI