我相信这是相当简单的,尽管我是一个使用R和代码的新手。我有一个数据集,每个捕鼠器站点都有一行。然而,在4年内有8次被诱捕。我想要做的是扩展陷阱站点数据,并为每行追加一个数字1到8。
然后,我可以用陷阱访问标记它们,以便后续连接所获得的陷阱数据。
我已经设法用下面的代码复制了这些行。
structure(list(TrapCode = c("IA1sA", "IA2sA", "IA3sA", "IA4sA",
"IA5sA"), Y = c(-12.1355987315, -12.1356879776, -12.1357664998,
-12.1358823313, -12.1359720852), X = c(-69.1335789865, -69.1335225279,
-69.1334668485, -69.1333847769, -69.1333226532)), row.names = c(NA,
5L), class = "data.frame")
gps_1 <– gps_1[rep(seq_len(nrow(gps_1)), 3), ]
给出
"IA5sA", "IA1sA", "IA2sA", "IA3sA", "IA4sA", "IA5sA", "IA1sA",
"IA2sA", "IA3sA", "IA4sA", "IA5sA"), Y = c(-12.1355987315, -12.1356879776,
-12.1357664998, -12.1358823313, -12.1359720852, -12.1355987315,
-12.1356879776, -12.1357664998, -12.1358823313, -12.1359720852,
-12.1355987315, -12.1356879776, -12.1357664998, -12.1358823313,
-12.1359720852), X = c(-69.1335789865, -69.1335225279, -69.1334668485,
-69.1333847769, -69.1333226532, -69.1335789865, -69.1335225279,
-69.1334668485, -69.1333847769, -69.1333226532, -69.1335789865,
-69.1335225279, -69.1334668485, -69.1333847769, -69.1333226532
)), row.names = c("1", "2", "3", "4", "5", "1.1", "2.1", "3.1",
"4.1", "5.1", "1.2", "2.2", "3.2", "4.2", "5.2"), class = "data.frame")
我有一个列,其中Trap_ID当前是唯一标识符。我希望在复制之后,我可以在它后面附加一个迭代号,以保持它是唯一的ID。
例如:
Trap_ID
IA1sA.1
IA1sA.2
IA1sA.3
IA2sA.1
IA2sA.2
IA2sA.3
发布于 2019-06-21 03:23:19
只需使用交叉连接(即,不带by列的连接,以返回两个集合的笛卡尔乘积):
mdf <- merge(data.frame(Trap_ID = 1:8), trap_side_df, by=NULL)
https://stackoverflow.com/questions/56691595
复制相似问题