Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Data Manipulation in R

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.