search for: xcel

Hi, I am using RExcel both at work and at home and am facing a couple of challenges. The one at home is that when using RExcel and trying to run any code that involves changing the working directory, I get the following error. Error in command: setwd("C:\\Raoul\\R\\R Maps_UK Maps_Test\\NUTS_03M_2006_SH\\shape\\d...

Hi, This may be a very basic question but it seems i cannot figure it out does not matter what. how do you sort a table (ascending or descending) after the values in one particular column? I want to do something like the sort function in Xcel. Also, is there any other plot function that accepts log for y axes like the parplot2() from gregmisc? Thanks for the tip Marc about barplot2. very useful indeed! Thank you again for all the help, Monica

...previoustripstore daysbetweentrips #1????? 1 2-Jan-12???? a??? 1????????? <NA>????????????? <NA>?????????????? NA A.K. Hi, I have a very quick question.. I have a data which has sales per category per trip of each customer at different store locations, like below..(dataset1 frome xcel attachment) CustID TripDate Store Bread Butter Milk Eggs 1 2-Jan-12 a 2 0 2 1 1 6-Jan-12 c 0 3 3 0 1 9-Jan-12 a 3 3 0 0 1 31-Mar-13 a 3 0 0 0 2 31-Aug-12 a 0 3 3 0 2 24-Sep-12 a 3 3 0 0 2 25-Sep-12 b 3 0 0 0 Here i have shown 4 items and their sales per customer per trip at each store... How...

...apply (Rolf Turner)   52. Re: Sapply (hadley wickham)   53. Aggregating irregular time series (R_help Help)   54. Re: SVM coefficients (Steve Lianoglou)   55. Re: [R-SIG-Finance] Aggregating irregular time series       (Gabor Grothendieck)   56.  Quadratcount image plot colors (phil smart)   57. RE xcel - two problems - Running RExcel & Working Directory       error (Raoul)   58. Re : Re:  Best R text editors? (Wolfgang RAFFELSBERGER)   59. clarificatin on validate.ols method='cross' (Dylan Beaudette)   60. Re: RE xcel - two problems - Running RExcel & Working       Directory error...