Data sets are often spread across multiple tables or files that have certain key columns in common. To work with all the data you have available as one large data frame, you may need to merge or join two or more tables together. In this lesson we learn how to perform inner, right, left and outer joins to merge data in base R.
This is lesson 17 of a 30-part introduction to the R programming language for data analysis and predictive modeling. Link to the code notebook below:
Introduction to R: Merging Data
www.kaggle.com/hamelg/intro-t...
This guide does not assume any prior exposure to R, programming or data science. It is intended for beginners with an interest in data science and those who might know other programming languages and would like to learn R.
I will create the videos for this guide such that you should be able to learn a lot just watching on KZread, but to get the most out of the guide, it is recommended that you create a Kaggle account so that you can fork and edit each lesson so that you can follow along and run code yourself.
Follow DataDaft on social media for news and updates:
Twitter: / datadaft
Introduction to R Playlist:
• Introduction to R