[R] how can I import op.gz files with read.csv or otherwise

herr dittmann Fri, 21 Dec 2012 06:52:58 -0800

Dear R-users,

I am struggling to directly read an "op.gz" file into R. NOAA kindly provides 
daily weather data on their FTP server for download.



> sessionInfo()
R version 2.15.1 (2012-06-22)
Platform: x86_64-pc-mingw32/x64 (64-bit)
locale:
[1] LC_COLLATE=English_United Kingdom.1252Â  LC_CTYPE=English_United 
Kingdom.1252Â Â Â  LC_MONETARY=English_United Kingdom.1252
[4] LC_NUMERIC=CÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  
LC_TIME=English_United Kingdom.1252Â Â  Â 
attached base packages:
[1] statsÂ Â Â Â  graphicsÂ  grDevices utilsÂ Â Â Â  datasetsÂ  methodsÂ Â  
baseÂ Â Â  Â 
loaded via a namespace (and not attached):
[1] tools_2.15.1

Here is the data set in question:
x <- 
read.csv(file="ftp://ftp.ncdc.noaa.gov/pub/data/gsod/2012/285880-99999-2012.op.gz";,
 skip = 1, sep = "")

and "structure" returns some incomprehensible gibberish:

> str(x)
'data.frame':Â Â  70 obs. ofÂ  6 variables:
Â $ 
X4Ã tYd...ÃÃ8.Ã¥WD...Ã«Ã¼.Ã¯Ã.X.QTÃ±VP..Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 
 : Factor w/ 70 levels 
"\005~4Ã¨dÅÃÃE\031y\020Ã¿ÃÂº\035JÃ«Ã¯ÃIËÃÃ\021â BÃÃR{Å¾Ykv\035`âÃ¬Â°a\017Z\021ÃsPâeÃhÃÃ""|
 __truncated__,..: 44 13 56 64 28 23 67 3 2 33 ...
Â $ 
X.Ã¶oMÃ½ÃT..ÃÂº_...ÃÃgÃ7.Ã¢..TÃ¾.Ã¼Ã.Âª...5ÃJ...Å¾ÃÃj.QÃ..Ã£.eÃÆÃGmÃ²Ã½Ã§Âºg..a...ÃÃ¦.J..Ã.Ã£sÃ§.ÃªÅ .Ã».ÃklsUDÃ.Å ..Ã¢U...u1.zÃ.WÃ..x...3._..E.Ã².ÃZD.Ã¯oÃÃ.dvÃ¦....Ã²k.C.y...8h:
 Factor w/ 41 levels 
"","\025Ã§\016\vÃÂ²i;Â§4ÆÃ±\002\001PâÃ¡\0025Â¶â¢Ã¢Ã{ÃÃâ¢Â¹=ÃÂ¤4&Ã°w\\\\QÂÂ´âºÂÃÂ´\"hnÃâ¢â°IÂ¨ÃÅ b*ÂªÅ¡\035b\b>6ÃÃ$W!ÃÃR=Â¨\022âPqË[Â»j\004$TÃâ¢3Â²*ÃÂ±%Ã ÂNââº\"|
 __truncated__,..: 1 1 1 39 1 1 1 8 1 5 ...
Â $ 
X.iÅ.yÃÃ»..Ã½2.h..Ã»Ã7.Ã£J.3k..jLm...Q..uYÃJÃ¤.K.zkU.8.Ã¶Ã..Y.7.3...Ã¼ÃÃ®A.Ã.3Ã»Ã..Z..5...Ã¢Å¡.Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 
 : Factor w/ 29 levels "","\001qÃ^+nÃª1",..: 1 1 1 4 1 1 1 14 1 6 ...
Â $ 
X.Ã®Fd.m.Å ..v.Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 
 : Factor w/ 17 levels 
"","Â Â´SL\aÅ¡ÃÃÂ°\035d)âÂ¼$ÃZÃÂ¼Ã²Â¶Ã®ÃJÃâÃ¤Ã¾â B6Ã¥\006%5l[âÂ¼Å¡\025a\024Ã±Ã¯+gT+3",..:
 1 1 1 16 1 1 1 1 1 1 ...
Â $ 
Ã¿A..E.Å¸JkEZ.ÃÃ.Ã¡.Ã«.......Å.z..Ã.z..Å..Ã²Ã.ÃÃÃ£g.Ã¶Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 
 : Factor w/ 8 levels 
"","\001S\177Â¿\017iSÃÃiÃÃ#\017\"UgÃ:iÂ´Ã\016pÃ\031UÃÃ©D""| 
__truncated__,..: 1 1 1 1 1 1 1 1 1 1 ...
Â $ X..oÃ°Ã§nPÃoÃWÃµj.Ã©Ã..B..ÃÃ¿Ã«.QÃªÃ¹...Ã¸Â Â Â Â  Â 


While I can manually open and read the op.gz file in a text editor, read.csv() 
or read.table() the imported file is simply unreadable.

How can I best get the job done? Any pointers, suggestions, ideas most welcome!!

Thanks in advance!

Bernd

        [[alternative HTML version deleted]]

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

[R] how can I import op.gz files with read.csv or otherwise

Reply via email to