Reading a workbook
In the previous exercise you generated a list of three Excel sheets that you imported. However, loading in every sheet manually and then merging them in a list can be quite tedious. Luckily, you can automate this with lapply().
Have a look at the example code below:
my_workbook <- lapply(excel_sheets("data.xlsx"),
read_excel,
path = "data.xlsx")
The read_excel() function is called multiple times on the "data.xlsx" file and each sheet is loaded in one after the other. The result is a list of data frames, each data frame representing one of the sheets in data.xlsx.
You're still working with the urbanpop.xlsx (view) file.
This exercise is part of the course
Introduction to Importing Data in R
Exercise instructions
- Use
lapply()in combination withexcel_sheets()andread_excel()to read all the Excel sheets in"urbanpop.xlsx". Name the resulting listpop_list. - Print the structure of
pop_list.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Read all Excel sheets with lapply(): pop_list
pop_list <- ___
# Display the structure of pop_list
___