Turn a dataframe into a named list of dataframes with names from a column in R

Question

So I turned a list into a long dataframe which now has one column, that used to be the names of the list with something like:

df <- map_df(list, ~as.data.frame(.x), .id="id")

Now I want to go the other way round and turn the dataframe back into a named list, based on that column. So for example in the following data:

df = data.frame(a=c("foo", "bar", "baz"), b=1:3)
df
    a b
1 foo 1
2 bar 2
3 baz 3

Now I would like to have a list with the names of column a, so foo bar and baz and the values are the dataframes now only containing one line: 1 for a, 2 for b ...

lst = list(foo=data.frame(b=1), bar=data.frame(bar=2), baz=data.frame(b=3))

why does the bar dataframe have the name `bar`?. Also could you have abit complex example give more intuition and where is the `id` column? — Onyambu, Nov 10 '20 at 21:43

score 3 · Answer 1 · answered Nov 10 '20 at 21:47

3

You could also use split:

split(df[-1], df[1])

answered Nov 10 '20 at 21:47

Onyambu

67,392
3
24
53

score 1 · Answer 2 · edited Nov 10 '20 at 22:03

1

A second option would be using dplyr for grouped variables:

library(dplyr)

df %>% 
  group_split(a, .keep = FALSE)

edited Nov 10 '20 at 22:03

zx8754

52,746
12
114
209

answered Nov 10 '20 at 21:48

DPH

4,244
1
8
18

score 1 · Accepted Answer · edited Nov 10 '20 at 23:38

1

We can use:

library(tibble)
as.list(deframe(df))

edited Nov 10 '20 at 23:38

Elletlar

3,136
7
32
38

answered Nov 10 '20 at 21:52

akrun

874,273
37
540
662

Turn a dataframe into a named list of dataframes with names from a column in R

3 Answers3