Create dataframe from list of lists [duplicate]

Question

I have a list of lists, like this:

tweetsdata <- list(politician1=list(meanlikes=2, meanretweet=1), politician2=list(meanlikes=4, meanretweet=3))

My desidered output is a data frame tweetsdata_df with 3 columns, like this:

|  POLITICIAN | MEANLIKES | MEANRETWEETS |

| ----------- | --------- | ------------ |

| Politician1 |     2     |      1       |

| Politician2 |     4     |      3       |

If I do a simple as.data.frame(tweetsdata) the output is a dataframe with 1 obs. of 4 variables (politician1.meanlikes, politician1.meanretweet, politician2.meanlikes, politician2.meanretweet)

If I try to create the dataframe manually I don't know how to access the right variable:

tweetsdata_df <- data.frame(POLITICIANS=names(tweetsdata), MEANLIKES=???, MEANRETWEETS=???)

What am I doing wrong?

Nir Graham · Accepted Answer · 2023-03-13 18:27:15Z

1

library(tidyverse)

enframe(tweetsdata) |> unnest_wider(col="value")

answered Mar 13, 2023 at 18:27

Nir Graham

5,1972 gold badges8 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

GuedesBF · Accepted Answer · 2023-03-13 18:58:38Z

0

We can use purrr::map_dfr()

library(purrr)

map_dfr(tweetsdata, f = ~.x, .id = "politician").

# A tibble: 2 × 3
  politician  meanlikes meanretweet
  <chr>           <dbl>       <dbl>
1 politician1         2           1
2 politician2         4           3

answered Mar 13, 2023 at 18:58

GuedesBF

9,9515 gold badges23 silver badges42 bronze badges

Collectives™ on Stack Overflow

Create dataframe from list of lists [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related