id x 1 2 3 x1 x2 x3 id y 1 2 y1 y2 4 y4 left_join(x, y, by = "id")