Import Excel files from the web
When working with multiple data sources, .xls
is a common format for storage and exchange. You have been provided with a URL which you'll be using to download and import a .xls
file. The URL is already available in the sample code. Once downloaded, you will import the file using readxl
and inspect its content.
This is a part of the course
“Intermediate Importing Data in R”
Exercise instructions
- Load the
readxl
package. It is already installed on DataCamp's servers. - Use
download.file()
to download the.xls
file behind the URL and store it locally as"local_latitude.xls"
. - Import the
.xls
file located at the URLurl_xls
usingread_excel()
. Store the resulting data frame asexcel_readxl
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Load the readxl package
# Specification of url: url_xls
url_xls <- "https://assets.datacamp.com/production/course_1478/datasets/latitude.xls"
# Download file behind URL, name it local_latitude.xls
# Import the local .xls file