If I understand your problem correctly,
you want to use '[[' instead of '$':
order(parameters[["ItemColumn"]], parameters[["PriceColumn"]])
On 28/05/2013 07:06, Barry King wrote:
I have an Excel worksheet with 20 rows. Using XLConnect I successfully
read the data into 'indata'. In order to sort it on the 'Item' column
and the 'Price_Per_Item' column I submit:
index <- with(indata, order(Item, Price_Per_Item))
sortedData <- indata[index, ]
The above works fine but now I do not want to name the columns in the
R program directly but pass the names of the columns from a parameter file:
index <- with(indata, order(parameters$ItemColumn,
parameters$PriceColumn))
sortedData <- indata[index, ]
This does not work. Only one row appears in 'sortedData'. I've tried
unlisting the two arguments to 'order' but this does not correct the
problem.
Can anyone suggest a solution to my problem? Your assistance is
appreciated.
- Barry King
--
Patrick Burns
[email protected]
twitter: @burnsstat @portfolioprobe
http://www.portfolioprobe.com/blog
http://www.burns-stat.com
(home of:
'Impatient R'
'The R Inferno'
'Tao Te Programming')
______________________________________________
[email protected] 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.
