Expand nested dataframe cell in long format

Question

Have fetched info from mongo and it looks like this :

I want to expand part_list in such a way it looks like this :

Have checked this solution ( Expand nested dataframe into parent ), but it seems to not work in my case.

Also I am unable to create a dataframe like this to post a reproducible code here. How should I expand it ?

Answer 1

You can use unnest() in tidyr to expand a nested column.

tidyr::unnest(df, part_list)

# # A tibble: 3 x 2
#   chapterid part_list
#   <chr>     <chr>    
# 1 a         c        
# 2 a         d        
# 3 b         e 

---

Data

df <- data.frame(chapterid = c("a", "b"))
df$part_list <- list(c("c", "d"), "e")

#   chapterid part_list
# 1         a      c, d
# 2         b         e