[R] RODBC conectar MySQL con R

Hola, Alguno ha usado el paquete RODBC para acceder a una BBDD MySQL desde R en Windows? Qu'e mas tengo que hacer a parte de: 1) Aniadir el Driver de MySQL a la lista de User DSN en Control panel -> Administrative tools -> Data Sources(ODBC) 2) Testear que funciona la conexion 2) Ejecutar: ch <-

[R] R2PPT - Insert data.frame

Hi all, When using the package R2PPT I am able to create a presentation, add slides, add title, add text. But when it comes to insert data.frame with the function PPT.AddDataFrame the result is everything but nice. I may need to define the data.frame in some way that power point interprets it bet

[R] Problem with getFX function

Hi everyone, Following this post: http://r.789695.n4.nabble.com/currency-conversion-function-tt906056.html#a906061 I was trying to run the code: foo <- function(from, to, date){ url <- " http://www.oanda.com/convert/classic?script=..%2Fconvert%2Fclassic&language=en&value=1 " params

[R] Subset of Data Frame using the date

Hello, I have a data frame with one column set as the date with function as.Date. In example: data.frame( "Date" = c("2009-09-01","2009-09-02","2009-09-03","2009-09-04", "2009-09-05"), "Data" = c( 10:14 ) ) Date Data 2009-09-01 10 2009-09-02 11 2009-09-03 12 2009-09-04 13 Is there

[R] Outlier detection from trayectory data

Hi all, I am trying to analyze data coming from trajectories of moving objects. It can be take as a two dimension time serie. The only method I've found is this: http://figment.cse.usf.edu/~sfefilat/data/papers/TuAT10.41.pdf Anyone know if this method is already implemented in R of if there is a

Re: [R] 1st R Conferences in Spain!!

/r-help-es Best regards!! 2009/10/7 Usuario R > Hi all, > > I would like to announce that the firsts *R Conferences for the Spanish R > community* will be taken place in University of Murcia on 26 and 27th of > November. > > You can have all the information

[R] 1st R Conferences in Spain!!

Hi all, I would like to announce that the firsts *R Conferences for the Spanish R community* will be taken place in University of Murcia on 26 and 27th of November. You can have all the information in the web page: http://www.ereros.org/where you can also subscribe and send your talk proposals t

[R] Argument problem in function wrapper

Dear all, we are writing a wrapper for the nls function in library stats. We are having a problem with one of the arguments (weightsArgument) which seems not to reach nls even if we explicitly assign it in the function call. We are attaching the simplest code reproducing the error and the output c

[R] Argument problem in function wrapper

Dear all, we are writing a wrapper for the nls function in library stats. We are having a problem with one of the arguments (weightsArgument) which seems not to reach nls even if we explicitly assign it in the function call. We are attaching the simplest code reproducing the error and the output c

[R] Comparing elements of a vector, grouped by values in other vector.

Hi, I have the following vectors: v1 <- rep( LETTERS[ 1:4 ], each = 5) v2 <- c( letters[ 1:10 ], letters[ 1:10 ] ) Notice that: > tapply( B, A, I ) $A [1] "a" "b" "c" "d" "e" $B [1] "f" "g" "h" "i" "j" $C [1] "a" "b" "c" "d" "e" $D [1] "f" "g" "h" "i" "j" Here we can see there are two

Re: [R] power.t.test formula

e = "two.sample", sd = NULL)$sd > > n1 <- round( power.t.test( n = NULL, delta = FC, sig.level = alfa,power = power, type = "two.sample", sd = sd1)$n) Error in uniroot(function(n) eval(p.body) - power, c(2, 1e+07)) : f() values at end points not of opposite sign

[R] power.t.test formula

Hi, Does anyone of you knows a reference for the formula used in power.t.test function? And also why it uses the Student's distribution instead of Normal. (I know both of them can be used but don't see whether choose one or the other) Thank you. Regards [[alternative HTML version deleted

Re: [R] Help with ANOVA p-values

Hi, you can try something like: summary( zzz.aov )[[1]][ "Pr(>F)" ] Regards 2009/4/14 Amit Patel > > Hi > I have done ANOVA on a dataset (See Below) but am having problems > retreiving the p-value. I am assuming that Pr(>F) is the p-value but cannot > get this value or in fact any other value

[R] Discussion on hosting of local user group web portals under r-project

Hi all, Driven by the success of R, a number of local R users groups have been formed in several places (London, NY, etc.). We are also currently considering setting up our own local group in Spain. We have found that setting up a web page in order to centralise the information relevant to the gr

Re: [R] Sum of character vector

Hi, This: sum(data[,1]=="GG") may not work because you have some NA in your data. Try this: sum( data[ , 1 ] == "GG", na.rm = TRUE ) Regards 2009/3/30 David A.G > > Dear list, > > I am trying to evaluate how many elements in a vector equal a certain > value. The vectors are the columns of a

Re: [R] How to rotate axis labels? 2009

Hi, What you want is done with argument srt of par function. See ?par and then look for srt argument. Regards 2009/3/26 Jonas Stein > Hi, > > while searching for a solution i found many solutions in the internet. > But the postings seemed to be many years old and the workaround was a > dirty

Re: [R] 2D plot with colors from 3rd variable?

Hi, Are your variable numerical? If so, you can do what you want by just define the color as the variable (col = variable3). Colors in R can be defined by numbers, so each number will corresponds to one color. In example: plot( iris[, 1], iris[, 2], col = iris[,3]) Regards 2009/3/18 Josh

Re: [R] Save the elements of an atomic vector to a text fil

Hi, take a look to ?write.table regards 2009/3/13 johnhj > > Hii, > > I will save the elements of the vector median<-with(x, tapply(V3, grup, > median)). The output of this vector is: > > 25 50 75 100 125 150 175 200 225 250 275 300 325 350 375 > 400 425 450 475 500 > 17

Re: [R] (no subject)

Hi Arnaud, is very simple: > unique( datos) Regards 2009/3/10 > > Dear R users, > > I have a table with the following form > > STATION X Y > 1-7030 > 1-7030 > 1-7030 > 2-7229 > 2-7229 > 2-7229 > 2-722

Re: [R] dotplot

Hi, I think you need to set the parameter pch to 19. - pch=19: solid circle, - pch=20: bullet (smaller circle), - pch=21: circle, - pch=22: square, - pch=23: diamond, - pch=24: triangle point-up, - pch=25: triangle point down. Regards 2009/3/4 Veerappa Chetty > Hi,I wou

Re: [R] How to reuse my self function?

Hi, I think you just have to call it with the correct arguments inside test2 function. So the arguments for test1 functions should be consider to be also arguments of test2 function. test2 <- function( test1arguments, test2arguments ){ ... value <- test1( test1arguments ) ... } Re

[R] Reshape

Hi all, I would like to transform to long format a matrix which has only information about individuals and a value for each individual. I would like to have it in ling format with more information related to groups, so ell values and individuals are repeated for each group. Let me show the exampl