View Code? Open in Web Editor NEW

Load external data from a .csv file into a data frame (5' training for The Carpentries)

loaddata's Introduction

Load external data from a .csv file into a data frame

See https://bit.ly/carpentry-slides

Try by intuition

Document what you did.

# Some code goes here

Back to the lesson

To download the data into the data/ subdirectory, run the following:

WARNING: This will fail. Why? (Run and read the error message)

Hint: * Look in the Files tab. What's missing? * What are the first two arguments of download.file()? * Find out with the help of autocompletion (press TAB) or with ?

# MISTERY-FUNCTION-GOES-HERE("data")

download.file(
  "https://ndownloader.figshare.com/files/2292169",
  "data/portal_data_joined.csv"
)
#> Warning in download.file("https://ndownloader.figshare.com/files/
#> 2292169", : URL https://ndownloader.figshare.com/files/2292169: cannot open
#> destfile 'data/portal_data_joined.csv', reason 'No such file or directory'
#> Warning in download.file("https://ndownloader.figshare.com/files/
#> 2292169", : download had nonzero exit status

You are now ready to load the data:

surveys <- read.csv("data/portal_data_joined.csv")

Print the variable's value: surveys

# WARNING: In the console, this prints looooong output
surveys

Let's check the top (the first 6 lines) of this data frame using the function head():

head(surveys)
#>   record_id month day year plot_id species_id sex hindfoot_length weight
#> 1         1     7  16 1977       2         NL   M              32     NA
#> 2        72     8  19 1977       2         NL   M              31     NA
#> 3       224     9  13 1977       2         NL                  NA     NA
#> 4       266    10  16 1977       2         NL                  NA     NA
#> 5       349    11  12 1977       2         NL                  NA     NA
#> 6       363    11  12 1977       2         NL                  NA     NA
#>     genus  species   taxa plot_type
#> 1 Neotoma albigula Rodent   Control
#> 2 Neotoma albigula Rodent   Control
#> 3 Neotoma albigula Rodent   Control
#> 4 Neotoma albigula Rodent   Control
#> 5 Neotoma albigula Rodent   Control
#> 6 Neotoma albigula Rodent   Control