Cross referencing two tables to include all or only matched data rows | Beginner solution

A tutorial for how to cross reference, combine or merge two or more data tables or sheets, and specify whether to include all data rows or include only matched data rows from one or both data tables. We provide a practical conceptual tutorial of different types of merge ( left, right, inner and outer merge) with example. This is a beginner solution and accessible for every background, specially for less technical professionals or learners. We apply this solution with Python, but you do not need to have any pre-knowledge of using Python. You may have your data in excel, google sheets, or any other source. This solution tutorial is applicable for you. In this example, our data exists in two sheets of a google sheets spreadsheet. Data and solution code all available to download here in below. Related links for this video: • a complementary blog with step-by-step tutorial, for more clarification on this video: https://winswithdata.com/?p=418 • Download the open source and access python code script template solution, available in the above blog page. Please like this video and subscribe to the channel for more tutorial videos, particularly with a focus on: • providing ready-to-execute solutions to achieve data goals of professionals regardless of your previous knowledge on technical background of programming and data. • a series of data and business insight from the perspective of an economist and applied data scientist in industry for those interested in the "under the hood" of the data related topics. About me: I am Dimo, an economist with a data science focus in industry. I am sharing my work productivity tips, tech-solution, data visualization and analysis experiences, statistical - econometrics - machine learning learning items in format of how-to tutorials in this channel. My Social Media Links & Profiles: Web blog: http://winswithdata.com/ All socials in LinkTree: https://linktr.ee/winswithdata Twitter: https://twitter.com/WinsWithData Facebook: https://www.facebook.com/WinsWithData Youtube: https://www.youtube.com/channel/UCyu3P3VvHx-vRyp55p4tK7Q Instagram: https://www.instagram.com/wins.with.data/ Dailymotion: https://www.dailymotion.com/winswithdata DTube: https://d.tube/c/winswithdata100