How to use left_join In R Language
This performs left join on two dataframes which are available in dplyr() package.
Syntax:
left_join(df1, df2, by='column_name')
where
- df1 and df2 are the two dataframes
- column_name specifies on which column they are joined
Example: R program to find a let join
R
# load the librarylibrary("dplyr")# create first dataframedata1=data.frame('name'=c('siva','ramu','giri','geetha'), 'age'=c(21,23,21,20))# displayprint(data1)# create second dataframedata2=data.frame('name'=c('siva','ramya','giri','geetha','pallavi'), 'marks'=c(21,23,21,20,30))# displayprint(data2)print("=========================")# left join on name columnprint(left_join(data1, data2, by='name')) |
Output:
How to Do a Left Join in R?
In this article, we will discuss how to do a left join in R programming language.
A left join is used to join the table by selecting all the records from the first dataframe and only matching records in the second dataframe.
Contact Us