reading row vectors from file
Why not simply read it as an csv file, then transpose it. If you also
store it as a data frame, you can use attach() or detach() the object to
the search path whenever you want to access the variables directly.
df <- read.csv( "tmp.txt", header=FALSE, row.names=1 )
df <- data.frame( t( df ) )
df
freq noise signal pctrcv
V2 0 49 99 5
V3 1 47 0 0
V4 2 48 100 5
V5 3 48 0 0
V6 4 50 0 0
V7 5 47 100 5
V8 6 48 0 0
V9 7 47 100 5
V10 8 46 100 11
V11 9 50 0 0
V12 16 48 100 5
V13 17 54 101 5
V14 18 49 100 5
V15 19 47 0 0
V16 20 49 0 0
attach( df )
pctrcv
[1] 5 0 5 0 0 5 0 5 11 0 5 5 5 0 0
signal / noise
[1] 2.020408 0.000000 2.083333 0.000000 0.000000 2.127660 0.000000
2.127660
[9] 2.173913 0.000000 2.083333 1.870370 2.040816 0.000000 0.000000
On Thu, 2005-03-03 at 12:22 -0900, Ken Irving wrote:
Hi,
New to R, using version 2.0.1 (2004-11-15) on debian Linux (sid), kernel
2.6.8-2-686.
I have data in files with separate vectors on each row of the file,
e.g.,
$ cat /tmp/stats
freq,0,1,2,3,4,5,6,7,8,9,16,17,18,19,20,...
noise,49,47,48,48,50,47,48,47,46,50,48,54,49,47,49,...
signal,99,0,100,0,0,100,0,100,100,0,100,101,100,0,0,...
pctrcv,5,0,5,0,0,5,0,5,11,0,5,5,5,0,0,...
I can transpose the data file (e.g., using an awk script), and then read
it using read.csv("tstats"),
$ transpose /tmp/stats > /tmp/tstats
$ cat /tmp/tstats
freq,noise,signal,pctrcv
0,49,99,5
1,47,0,0
2,48,100,5
...
but would prefer to import the line-oriented files directly. I've
drawn a blank after perusing help, documentation, google searches, etc..
Something like read.csv( "transpose stat |" ) might be nice, e.g., the
trailing pipe symbol invokes the argument as a shell pipeline, then
reads from stdin, but I'm just making this up... Actually, this does
work:
t <- read.csv( pipe("transpose stat1") )
but it does rely on an external transpose command. Is there a way to
read line-oriented vector files directly?
Thanks for any help or leads,
Ken