Extract data in a list in a data frame

[isaid]

Hi, I want to extract values in a list, where those list is stored in a dataframe.

Data
df is a dataframe of 1000 rows and 20 column. I only interested in the 7th column (a list), so ignore another column.

Here's the first row of the df[[7]] looks like (or its df[[7]][[1]]):

What I want to do
I want to extract the screen_name value under user_mention which in this case paijodirajo. Except, I want to get all rows screen_name data instead of only first row.

I'm using this stupid code df[[7]][[1:10000]]$user_mentions$screen_name which ofcourse failed, but you get the idea.

So how to do it correctly?

[nirgrahamuk]

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

[isaid]

Since I'm struggling to address the location of the value, creating a reproducible data is even more challenging for me. But right, this question is really messy. I'll try to fix the question. Thanks for reminding

[nirgrahamuk]

@isaid

df[[7]][[1:10000]]

here iris stands in for df, as I dont have df to play with. but everyone who uses r can acces iris:
while you wouldnt expect to be able to do iris[[4]][[1:5]] you could do iris[[4]][1:5]
this gets the first 5 columnwise entries in the 4th column of iris.

[isaid]

I feel like it's not very accurate to use iris as an example because my dataframe structure is very different. Its the output of rtweet::search_tweets() function, so my df have a lot of column that contains lists.
The 7th column contains list which data looked like this

That list structure is for each row in column 7 (the example on the pic is first row).

However, I managed to find the solution. For anyone who looking for answer, heres the solution

screen_name_data <- vector()
for (i in 1:nrow(df)) {
screen_name_data[i] <- df[[7]][[i]][["user_mentions"]][["screen_name"]]
}

With this loop method, I managed to get specific values in each row that I want.

print(screen_name_data)

#> [1] "paijodirajo"     NA                NA               
#> [4] "P3n99u94t"       "bianca125547620" "MichelAdam9191" 
#> [7] "OposisiCerdas"   "hc_poirot"       "MichelAdam9191" 
#> 10] "bianca125547620" "MichelAdam9191"  "MichelAdam9191"
#> ...and so on

Anyway, thanks for the reply