Re: [R] RODBC sqlSave / append problem (windows XP, R 2.13.2)

2012-02-17 Thread taby gathoni
Hi MJ, Thanks alot for this. I will try and revert.   Taby An idea not coupled with action will never get any bigger than the brain cell it occupied. Arnold Glasgow .. Attempt something large enough that failure is guaranteed…unless God steps in!

Re: [R] RODBC sqlSave / append problem (windows XP, R 2.13.2)

2012-02-16 Thread taby gathoni
Hi Mj, did you get a solution for this? I am  having the same error  Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test, : missing columns in 'data' I would appreciate if you can share the solution with me. Kind regards, Taby From:

[R] warning with cut2 function

2011-10-11 Thread taby gathoni
Dear r user, please find my attached sample of the dataset i  am using to create a crosstable and eventually plot a histogram from the output. I am using  the cut2 function to create bins, about 7 of them using the code after reading the data: cluster - cut2(cross_val$value, g=7) I get the

[R] [Heuristic [Auto Search Error in phi[[y]] : attempt to select less than one element

2011-07-21 Thread taby gathoni
Dear R-users,  I have about 32 variables and am attempting to analysis any interactions   using the package deal. I am getting the error [Heuristic [Auto Search Error in phi[[y]] : attempt to select less than one element Could you please assist in solving this, my code is as follows:

[R] interaction between categorical variables

2011-06-21 Thread taby gathoni
Dear R-users, I need some  assistance. I am running some interactive variables for categorical variables. I have dgen(2 levels converted to dummy variables)  and dtoe(4-levels also converted to  dummy variables). So I have worked with them in two ways: i created a variable X1 = dgen*dtoe 

[R] plotting line graphs for output from crosstabs function

2011-04-14 Thread taby gathoni
Hi R-users, This is a generic question, is there a way to plot a line graph for the output from crosstable function? one of the inputs to the crosstab function is categorical. Taby -- [[alternative HTML version deleted]] __

[R] plotting line graphs for output from crosstabs function

2011-04-13 Thread taby gathoni
Hi R-users, This is a generic question, is there a way to plot a line graph for the output from crosstable function? one of the inputs to the crosstab function is categorical. Taby -- [[alternative HTML version deleted]] __

Re: [R] random sampling with levels and with replacement

2011-04-11 Thread taby gathoni
in this case) next time. Best regards, Andreas taby gathoni schrieb: Dear all, i have a dataset of about 400 records , with a variable that has  two levels 40 bad and 360 good among other variables,how do i come up  with10 random samples that have the composition of as the main sample

[R] random sampling with levels and with replacement

2011-04-08 Thread taby gathoni
Dear all, i have a dataset of about 400 records , with a variable that has  two levels 40 bad and 360 good among other variables,how do i come up  with10 random samples that have the composition of as the main sample  but maintaining the 40 bad 360 good with replacement, i recently discovered

Re: [R] random sampling with levels and with replacement

2011-04-08 Thread taby gathoni
Thanks Daniel, Its a long way but it will work. --- On Fri, 4/8/11, Daniel Malter dan...@umd.edu wrote: From: Daniel Malter dan...@umd.edu Subject: Re: [R] random sampling with levels and with replacement To: r-help@r-project.org Date: Friday, April 8, 2011, 10:08 AM If you want

Re: [R] calculating AUCs for each of the 1000 boot strap samples

2011-03-18 Thread taby gathoni
); there is a better chance of someone helping you.  Just because I could help with one aspect does not mean I necessarily can (or have the time to) help with more. Further comments are inline below. On 3/16/2011 10:45 PM, taby gathoni wrote: Hi Brian, Thanks for this comment I will action

[R] calculating AUCs for each of the 1000 boot strap samples

2011-03-16 Thread taby gathoni
Hallo, I modified a code given by Andrija, a contributor in the list  to achieve two objectives: create 1000 samples from a list of 207 samples with each of the samples cointaining 20 good and 20 bad. THis i have achievedcalcuate AUC each of the 1000 samples, this i get an error. Please see

Re: [R] Fw: random sampling steps in R with replacement

2011-03-14 Thread taby gathoni
] Fw: random sampling steps in R with replacement To: taby gathoni tab...@yahoo.com Cc: R help r-help@r-project.org Date: Thursday, March 10, 2011, 12:05 PM Hi Taby,   this is not best solution for sure but it will give you, maybe, some ideas :) I am also looking forward to see other solutions

[R] value of W seems to be suspicious in the mann-whitney wilcox related test. what could be the problem

2011-03-14 Thread taby gathoni
my output is as follows:  wilcox.test(main_samp$SCORE~main_samp$GENDER, conf.int = TRUE)     Wilcoxon rank sum test with continuity correction data:  main_samp$SCORE by main_samp$GENDER W = 2780.5, p-value = 0.04829 alternative hypothesis: true location shift is not equal to 0 95 percent

Re: [R] value of W seems to be suspicious in the mann-whitney wilcox related test. what could be the problem

2011-03-14 Thread taby gathoni
, in general, and isn't restricted to [0,1] Abhijit On 3/14/2011 11:07 AM, taby gathoni wrote: my output is as follows:  wilcox.test(main_samp$SCORE~main_samp$GENDER, conf.int = TRUE)         Wilcoxon rank sum test with continuity correction data:Â

[R] random sampling steps in R

2011-03-10 Thread taby gathoni
Dear all, Could someone assist me in random sampling steps/code in R? I have a main sample of 42 males and 165 females and I want to come up with about 1000 samples of 20 males and 20 females from this main sample. While at it, i would also like to come up Accuracy Ratios (ARs) with

[R] Fw: random sampling steps in R with replacement

2011-03-10 Thread taby gathoni
Please note is with replacement From: taby gathoni tab...@yahoo.com To: R help r-help@r-project.org Sent: Thursday, March 10, 2011 11:53 AM Subject: [R] random sampling steps in R Dear all, Could someone assist me in random sampling steps/code in R? I have a main sample of 42 males and 165

[R] problem in installing Rattle in R 2.12.1.0

2011-02-14 Thread taby gathoni
Hi all, Please help, I am getting an error when I try installing rattle. Error in as.GType(type) : Cannot convert RGtkBuilder to GType I have already installed gtk-2.12.9-win32-2  and gtk2-runtime-2.22.0-2010-10-21-ash and restarted R as instructions require. Please assist me Taby

[R] problem in merging

2011-02-07 Thread taby gathoni
Hi all, I am having this error while trying to merge about 2 dataframes m_merge = merge(m_accts,m_op, by.y=CUST_ID,by.x=FORACID,all.y=TRUE,all.x=TRUE) Error: cannot allocate vector of size 10.0 Mb Taby [[alternative HTML version deleted]]

[R] personal details appearing on google such after I pose a question in the R-help forum

2011-01-03 Thread taby gathoni
Hi all, Out of curiosity I googled my name yesterday to just see what new information  in the web there is associated with me. To  my surprise, I found in addition to the  questions i have posted on this forum, my email address and my signature details (name, address, telephone number) seem

[R] Panel Data Analysis in R

2010-12-29 Thread taby gathoni
Dear All, Can anyone provide me with reference notes(or steps) towards analysis of  (un)balanced panel data in R. Thank you! Kind regards, Tabitha Mundia , Project Management Office, Equity Bank Limited,P.O. Box 75104-00200 Head Office, Upper hill, NHIF

[R] transposing panel data

2010-12-20 Thread taby gathoni
I am currently trying to transpose some large panel data set ie transposing multiple rows in into a single column. instead the transpose functionality transposes all rows into columns. my sample data set looks like below: ACCT_NUM ACCOUNT_NAME TRAN_AMT DATE EMPLOYER

[R] Error: package 'RODBC' was built before R 2.10.0: please re-install it

2010-12-16 Thread taby gathoni
Hi all, Am trying to install RODBC so that I can read excel 2007 files directly into R without converting into .csv or .txt formats. I am getting the  error: Error: package 'RODBC' was built before R 2.10.0: please re-install it The reason why i want to read the files directly is because  i