import dat file into R

by

The dat file has some lines of extra information before the actual data. Skip them with the skip argument:

read.table("http://www.nilu.no/projects/ccc/onlinedata/ozone/CZ03_2009.dat", 
           header=TRUE, skip=3)

An easy way to check this if you are unfamiliar with the dataset is to first use readLines to check a few lines, as below:

readLines("http://www.nilu.no/projects/ccc/onlinedata/ozone/CZ03_2009.dat", 
          n=10)
# [1] "Ozone data from CZ03 2009"   "Local time: GMT + 0"        
# [3] ""                            "Date        Hour      Value"
# [5] "01.01.2009 00:00       34.3" "01.01.2009 01:00       31.9"
# [7] "01.01.2009 02:00       29.9" "01.01.2009 03:00       28.5"
# [9] "01.01.2009 04:00       32.9" "01.01.2009 05:00       20.5"

Here, we can see that the actual data starts at [4], so we know to skip the first three lines.

Update

If you really only wanted the Value column, you could do that by:

as.vector(
    read.table("http://www.nilu.no/projects/ccc/onlinedata/ozone/CZ03_2009.dat",
               header=TRUE, skip=3)$Value)

Again, readLines is useful for helping us figure out the actual name of the columns we will be importing.

But I don’t see much advantage to doing that over reading the whole dataset in and extracting later.

More Related Contents:

  1. Quickly reading very large tables as dataframes
  2. Only read selected columns
  3. How can I read multiple (excel) files into R? [duplicate]
  4. How can you read a CSV file in R with different number of columns
  5. How do I import a CSV file in R? [closed]
  6. How to avoid: read.table truncates numeric values beginning with 0
  7. Reading multiple csv files from a folder into a single dataframe in R [duplicate]
  8. Import data into R with an unknown number of columns?
  9. How to check if CSV file has a comma or a semicolon as separator?
  10. Issue when importing dataset: `Error in scan(…): line 1 did not have 145 elements`
  11. Preserving large numbers
  12. How to read.table() multiple files into a single table in R?
  13. Trying to merge multiple csv files in R
  14. Create a group number for each consecutive sequence
  15. Where does R store packages?
  16. Trimming a huge (3.5 GB) csv file to read into R
  17. regular expressions in base R: ‘perl=TRUE’ vs. the default (PCRE vs. TRE)
  18. How can I remove empty factors from ggplot2 facets?
  19. How to add a ggplot2 subtitle with different size and colour?
  20. Plot data in descending order as appears in data frame [duplicate]
  21. R knitr: Possible to programmatically modify chunk labels?
  22. How can I add a table to my ggplot2 output?
  23. R: Reshaping Multiple Columns from Long to Wide
  24. Extract file extension from file path
  25. Add x and y axis to all facet_wrap
  26. How to change positions of x and y axis in ggplot2
  27. Error with select function from dplyr
  28. R Plot Filled Longitude-Latitude Grid Cells on Map
  29. Collapse all columns by an ID column [duplicate]
  30. Error in Confusion Matrix : the data and reference factors must have the same number of levels

Leave a Comment