Friday 15 August 2014

import subset of large table by name in R -



import subset of large table by name in R -

i have big table in .txt file , i'd import rows in r. exemple, table this:

name time mesure bob 17:24 0.418 jimmy 15:30 0.436 charles 05:26 0.257

i know possible take rows import number indexing :

table1 <- read.table(table0, skip=1, nrow=1, header=false, sep="")

which gives :

v1 v2 v3 jimmy 15:30 0.436

but how can obtain rows in value of 'name' 'jimmy' without knowing index ?

try

read.table(pipe('grep "jimmy" "table1.txt"')) #table1.txt file # v1 v2 v3 #1 jimmy 15:30 0.436 update

to utilize multiple words, try

read.table(pipe('grep "bob\\|jimmy" "table1.txt"')) # v1 v2 v3 #1 bob 17:24 0.418 #2 jimmy 15:30 0.436

r subset read.table

No comments:

Post a Comment