ComeçarComece de graça

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 exercício faz parte do curso

Intermediate Importing Data in R

Ver curso

Instruções do exercício

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

Exercício interativo prático

Experimente este exercício completando este código de exemplo.

# 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 e executar o código