Skip to content
Prev 315579 / 398503 Next

reading multiple key=value pairs per line

PIKAL Petr 
Hi

One option are regular expressions but you can also read data with "=" as separator.

test<-read.table("input_kvpairs.csv", sep=c("="), header=F, stringsAsFactors=F)

#use this function to split and extract numeric parts
extract<-function(x) as.numeric(sapply(strsplit(x,","),"[",1))

# and apply the function to appropriate columns
test1 <- data.frame(sapply(test[,2:3], extract), test[,4])

Now you can put names to resulting data frame see
?names

Regards
Petr

Thread (7 messages)

Frank Singleton reading multiple key=value pairs per line Jan 17 Christophe Pallier reading multiple key=value pairs per line Jan 17 PIKAL Petr reading multiple key=value pairs per line Jan 18 arun reading multiple key=value pairs per line Jan 18 arun reading multiple key=value pairs per line Jan 18 Greg Snow reading multiple key=value pairs per line Jan 18 Frank Singleton reading multiple key=value pairs per line Jan 18