CommencerCommencer gratuitement

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.

Cet exercice fait partie du cours

Intermediate Importing Data in R

Afficher le cours

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 URL url_xls using read_excel(). Store the resulting data frame as excel_readxl.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de 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
Modifier et exécuter le code