Question

How to combine data frames in R

Answer 1

students = data.frame(id=c(1,2,3,4,5), name=c("Echo", "Groot", "Luke", "Dana", "Kira"))
marks = data.frame(id=c(1,2,3,4,5), marks=c(85, 90, 100, 98, 87))

df = merge(students, marks, by=c("id"))

print(df)
   
   
   
         
         
# run:
#
#   id  name marks
# 1  1  Echo    85
# 2  2 Groot    90
# 3  3  Luke   100
# 4  4  Dana    98
# 5  5  Kira    87
#

 

70+ SQL courses for beginners and professionals