For loop to create multiple dataframe

Question

I have several dataframe, named "df.1","df.2",.....until "df.100".

I want to create a new dataframe for each of them, such as:

df.1.new <- df.1  %>% filter (var.1>=100)  %>% group_by (var.2)  %>% slice (which.min(var.3))

How can I apply the code to all thses dataframe from "df.1" to "df.100"?

Ronak Shah · Accepted Answer · 2020-11-04 01:13:21Z

2

Get the dataframes in a list and apply the code to each list element.

library(dplyr)

purrr::map(mget(paste0('df.', 1:100)), function(data) {
  data  %>% filter(var.1>=100)  %>% group_by(var.2)  %>% slice(which.min(var.3))
}) -> result

answered Nov 4, 2020 at 1:13

Ronak Shah

391k20 gold badges173 silver badges237 bronze badges

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

Collectives™ on Stack Overflow

For loop to create multiple dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related