如何从另一个数据框中的数据在 R 中创建新列

以下是示例数据.我们的目标是在第二个(数据框的名称)中创建一个标题为调整的新列，它将是d2022列中相应的INDCODE、AREA、OWOWNY组合.下面是所需结果的第一行.对如何做到这一点有什么 idea 吗？最终目标是获得这种调整，然后创建另一个新列，即第一个2022美元-第一个美元调整.

indcode  <- c(482000,482000,482000,524000,524000,524000)
 area <- c("000032","029820","039900","000032","029820","039900")
 ownership <- c(50,50,50,50,50,50)
 d2022 <- c(10,6,2,100,60,20)

 First<-data.frame(indcode,area,ownership,d2022)

这是现有数据

 indcode <- c(482000,482000,482000,484000,484000,484000,524000,524000,524000,531000,531000,531000)
 area <- c("000032","029820","039900","000032","029820","039900","000032","029820","039900","000032","029820","039900")
 ownership <- c(50,50,50,20,30,50,50,50,50,20,30,50)
 d2020 <- c(200,199,198,197,196,195,194,193,192,191,190,189)
 d2021 <- c(201,200,199,198,197,196,195,194,193,192,191,190)
 d2022 <- c(204,203,202,201,200,199,198,197,196,195,194,193)

 second <- data.frame(indcode1,area1,ownership1,d2020,d2021,d2022)

期望的结果

  indcode      area     ownership     d2020    d2021   d2022  adjustment
  482000      000032         50       200        201    204      10