set dataframe name inside a function using lapply

Question

Let's say, for the sake of the example, that I have a list of departments. Everyone of them is on a separate table named "departmentName", so I created a list this way.

depts <- c("financial","sales",.....)

and then iterate to get members this way creating a function:

get.employees <- function(tablename) {

  con <- DBI::dbConnect(connectiondata....)

  query <- glue::glue("select name,position,area from {tablename}")

  assign(tablename,
         dplyr::tbl(conn, sql(query)) %>% collect())

}

lapply(depts,get.employees)

It works fine but It returned a list of data frames with no name assigned to every element as I was expecting.

I need every dataframe named as the department name.

if you do result <- lapply(depts,get.employees) than names(results) <- depts should assigne the names — TinglTanglBob
– TinglTanglBob, Commented Apr 12, 2019 at 12:27

G. Grothendieck · Accepted Answer · 2019-04-12 12:30:17Z

1

1) Simplifying the example to use get.employees and depts in the Note at the end we can use Map instead of lapply:

L <- Map(get.employees, depts)
names(L)
## [1] "finance" "sales"

2) This also works:

L2 <- sapply(depts, get.employees, simplify = FALSE)
names(L2)
## [1] "finance" "sales"

Note

Simplified example:

get.employees <- function(x) BOD
depts <- c("finance", "sales")

answered Apr 12, 2019 at 12:30

G. Grothendieck

273k18 gold badges221 silver badges365 bronze badges

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

Comments

Rushabh Patel · Accepted Answer · 2019-04-12 12:38:10Z

0

You can also try-

> ls <- mapply(get.employees, depts,SIMPLIFY = F)

> names(ls)
[1] "finance" "sales"

Note- Input data was taken from answer provided by @G. Grothendleck

answered Apr 12, 2019 at 12:38

Rushabh Patel

2,7741 gold badge18 silver badges37 bronze badges

Collectives™ on Stack Overflow

set dataframe name inside a function using lapply

2 Answers 2

Note

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Note

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related