From the course: Data Wrangling in R

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Importing Excel files into R

Importing Excel files into R

From the course: Data Wrangling in R

Start my 1-month free trial Buy for my team

Importing Excel files into R

“

- [Instructor] Microsoft Excel spreadsheets contain a large portion of the world's business information. Let's take a look at how you can read these files directly into R. Here's the Excel file that we'll work with. This file, contains data from the US Department of Agriculture on the federally funded school breakfast program. It shows by fiscal year, the number of students who participated in the program broken out by whether they pay full price, receive their meals for free or pay a reduced price. It also shows the total number of meals served and the proportion of free and discounted meals. Now it's important to note the information in row five, the data in columns B through F is in millions and the data stored in column G is a percentage, we'll need to know that information later. You can read Excel files into R using the read_excel function. Now, this function is part of the tidyverse because it works with…

Contents