How to create multiple dataframes from an existing one?

Question

My issue is that after reading a Json file and then using tibble::enframe(unlist(data)), I want to create multiple dataframes by splitting the existing one at 20th*n, where (n=1,2..nrow(data)/20) rows. By simply subsetting it, I am getting what I want with data[1:20,]. I am also aware of the split() and slice() functions. I am wondering how can I come up with multiple dataframes by looping over the initial dataframe. Thnx in advance for any suggestion.

Ronak Shah · Accepted Answer · 2021-05-18 06:19:09Z

1

You can use split creating an index of every n rows to split the data.

n <- 20
df <- data.frame(a = runif(100), b = rnorm(100))
list_df <- split(df, ceiling(seq(nrow(df))/n))

To create new dataframes -

names(list_df) <- paste0('df', seq_along(list_df))
list2env(list_df, .GlobalEnv)

edited May 18, 2021 at 6:19

answered May 18, 2021 at 5:55

Ronak Shah

391k20 gold badges173 silver badges237 bronze badges

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

3 Comments

Nikolaos Bakogiannis Over a year ago

Hallo Ronak and thanks a lot for your answer. This main issue I have again is that I want to come up with a solution that returns new dataframes. What you proposed to me creates Large list, from which I can retrieve every element and then transform it to a dataframe --> as.data.frame(list_df [1]). What I want though is to loop through that large list and create the respective dataframes

Ronak Shah Over a year ago

See the updated answer to create new dataframes.

Nikolaos Bakogiannis Over a year ago

That was perfect! Thanks again for your help. It's highly appreciated!

Collectives™ on Stack Overflow

How to create multiple dataframes from an existing one?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related