ComenzarEmpieza gratis

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.

Este ejercicio forma parte del curso

Intermediate Importing Data in R

Ver curso

Instrucciones del ejercicio

  • 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.

Ejercicio interactivo práctico

Prueba este ejercicio y completa el código de muestra.

# 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
Editar y ejecutar código