[R] reading multiple key=value pairs per line

Frank Singleton b17flyboy at gmail.com
Fri Jan 18 05:21:26 CET 2013


Hi,

Thanks for a great environmentfor statistical  computing :-)

I have some input data in a file ("input_kvpairs.csv") of the form

key1=23, key2=67, key3="hello there"
key1=7, key2=22, key3="how are you"
key1=2, key2=77, key3="nice day, thanks"

Now in my head I wish it was of the form ("input.csv")

#key1, key2, key3
23,    67,   "hello there"
7,     22,   "how are you"
2,     77,   "nice day, thanks"

so I could do

data <- read.csv("input.csv", header=TRUE)

where the header column names are derived from the key names dynamically,
and I could access the data using normal data$key1 or data$key2 mechanism.

I guess I could just pre process the file first  using python etc to create
a CSV file with column header derived from key names, and values derived 
from
key values, but I am interested to see how experienced R folks would 
handle this
inside R.

Thanks,

Frank



More information about the R-help mailing list