我有一个列表,每个元素都包含标识符和数据。数据存储在一个列表列/ tibble中。如何将列表缩减为一个data.frame,通过标识符将单个数据拼接起来并追加数据?
a = list(
mtcars %>% as_tibble() %>% select(mpg, cyl, disp) |> sample_n(5),
mtcars %>% as_tibble() %>% select(mpg, cyl, disp) |> sample_n(5)
)
b = a %>%
map(~ mutate(.x, class = floor(runif(nrow(.x), 0, 2)))) %>%
map(~ nest(.x, -class))B的产出:
✔ [main*]❯ print(b)
[[1]]
# A tibble: 2 × 2
class data
<dbl> <list>
1 1 <tibble [4 × 3]>
2 0 <tibble [1 × 3]>
[[2]]
# A tibble: 2 × 2
class data
<dbl> <list>
1 0 <tibble [4 × 3]>
2 1 <tibble [1 × 3]>我希望组合具有相同标识符class的b中的数据列。
**因此,预期产出是:**
# A tibble: 2 × 2
class data
<dbl> <list>
1 1 <tibble [5 × 3]>
2 0 <tibble [5 × 3]>使用b |> reduce(inner_join, by = "class")将列表扁平化为一个tibble,但现在数据列是新tibble的列,而不是合并到一个列。
编辑:注意,在我的用例中,b有两个以上的列表,我希望代码足够通用,不必事先知道有多少列表。
谢谢!
发布于 2022-10-13 15:42:00
在reduce步骤之后,我们可能需要绑定行(在处理OP的注释之后更新)
library(dplyr)
library(purrr)
b %>%
reduce(inner_join, by = "class") %>%
transmute(class, data = pmap(across(starts_with('data')), bind_rows))-output
# A tibble: 2 × 2
class data
<dbl> <list>
1 0 <tibble [11 × 3]>
2 1 <tibble [9 × 3]> 或者另一个选项是powerjoin,它以conflict作为函数
b %>%
reduce(power_inner_join, by = "class",
conflict = \(x, y) map2(x, y, bind_rows))-output
# A tibble: 2 × 2
class data
<dbl> <list>
1 0 <tibble [11 × 3]>
2 1 <tibble [9 × 3]> 输入b是
> b
[[1]]
# A tibble: 2 × 2
class data
<dbl> <list>
1 0 <tibble [3 × 3]>
2 1 <tibble [2 × 3]>
[[2]]
# A tibble: 2 × 2
class data
<dbl> <list>
1 1 <tibble [3 × 3]>
2 0 <tibble [2 × 3]>
[[3]]
# A tibble: 2 × 2
class data
<dbl> <list>
1 1 <tibble [3 × 3]>
2 0 <tibble [2 × 3]>
[[4]]
# A tibble: 2 × 2
class data
<dbl> <list>
1 1 <tibble [1 × 3]>
2 0 <tibble [4 × 3]>https://stackoverflow.com/questions/74058450
复制相似问题