Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Reading from a file
Reading from an Excel file
12. Loading Excel from just one sheet
Summary

Instruction

The data is stored across several sheets; each of Q1, Q2, Q3, and Q4 stores the data for one quarter. What if we want data for the second quarter (Q2)? We just pass "Q2" to the sheet parameter, as shown below:

q2_iron_baron <- read_excel("data/iron_baron_mines.xlsx", sheet="Q2")

Exercise

Read second quarter (Q2) data from data/mount_venture_company.xlsx into the q2_mount_venture variable. Use read_excel() and specify the Q2 sheet.