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.
Diese Übung ist Teil des Kurses
Introduction to Importing Data in R
Anleitung zur Übung
- 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.
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
# Read all Excel sheets with lapply(): pop_list
pop_list <- ___
# Display the structure of pop_list
___