Re: [R] Run time error when executing sqlQuery using the 64-bit version of R with 64-bit RODBC package in a Solaris 10 Sparc machine.

2010-01-20 Thread Eric Ma
Wow, this is as much hand-holding as one can expect, and for a R newbie it is unbelievable and invaluable! Thanks again for all this help Marc! Here is the screen print of my entire R session: .Machine$sizeof.pointer [1] 8 library(RODBC) conn - odbcConnect(dsn='qdblocal', uid = ciqxf, pwd

[R] Question about many-to-one merge

2010-01-20 Thread hongwei
I have spent a whole afternoon searching for the solution, but got nothing so far. It should be a simple problem. I have two datasets to merge. The first one just contains two ID columns and it looks like: FromID ToID 1 2 1 3 2 1 2 3 3 1 3

Re: [R] S3 tutorial

2010-01-20 Thread Steve Lianoglou
Hi, On Wed, Jan 20, 2010 at 6:05 PM, Peng Yu pengyu...@gmail.com wrote: On Wed, Jan 20, 2010 at 5:04 PM, Peng Yu pengyu...@gmail.com wrote: I don't find a tutorial on S3. Bengtsson.pdf cites MASS (1999 edition). However, I don't think that MASS (2002 edition) clearly explain what S3 is and

Re: [R] standardizing one variable by dividing each value by the mean - but within levels of a factor

2010-01-20 Thread Dimitri Liakhovitski
Thanks a lot for your helpful suggestion! Dimitri On Wed, Jan 20, 2010 at 5:56 PM, Chuck Cleland cclel...@optonline.net wrote: On 1/20/2010 5:37 PM, Dimitri Liakhovitski wrote: Hello! I have a data frame with a factor and a numeric variable:

Re: [R] Question about many-to-one merge

2010-01-20 Thread William Dunlap
-Original Message- From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of hongwei Sent: Wednesday, January 20, 2010 2:38 PM To: r-help@r-project.org Subject: [R] Question about many-to-one merge I have spent a whole afternoon searching for the

Re: [R] Question about many-to-one merge

2010-01-20 Thread David Winsemius
On Jan 20, 2010, at 5:37 PM, hongwei wrote: I have spent a whole afternoon searching for the solution, but got nothing so far. It should be a simple problem. I have two datasets to merge. The first one just contains two ID columns and it looks like: FromID ToID 1 2 1

Re: [R] Yet another question about importing Excel *.xls files

2010-01-20 Thread Gabor Grothendieck
On Wed, Jan 20, 2010 at 6:01 PM, Jerry Floren jerry.flo...@state.mn.us wrote: Next, I tried Gabor's code, which is so much more compact: ### Start of Gabor's code ### library(gdata) DF - read.xls(U, pattern = SAMPLE, as.is = TRUE) ##  End of Gabor's code ## Is U the directory and path? Is

Re: [R] Matrices with randomly generated entries

2010-01-20 Thread GlenB
Why not just use matrix(runif(9),nrow=3) ? -- View this message in context: http://n4.nabble.com/Matrices-with-randomly-generated-entries-tp1018777p1024617.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org

[R] x,y plot question (two sets of labels)

2010-01-20 Thread Jonathan Greenberg
I'm trying to figure out the best way to do a scatterplot using the following data as an example: plothelp_x=1:10 plothelp_A1=sin(plothelp_x) plothelp_A2=tan(plothelp_x) plothelp_B=c(A,B,C,A,B,C,A,B,C,A) (note that all 4 of these vectors have 10 entries each) What I would like is to have two

Re: [R] Yet another question about importing Excel *.xls files

2010-01-20 Thread Gabor Grothendieck
It may also be that path names with spaces in them are not supported. Try it using a path that has no spaces in it. On Wed, Jan 20, 2010 at 6:43 PM, Gabor Grothendieck ggrothendi...@gmail.com wrote: On Wed, Jan 20, 2010 at 6:01 PM, Jerry Floren jerry.flo...@state.mn.us wrote: Next, I tried

Re: [R] Merge and join data

2010-01-20 Thread GlenB
Specifically, your setup of the data makes all the columns factors, so to make Peter's code work you need to make the relevant columns numeric first. -- View this message in context: http://n4.nabble.com/Merge-and-join-data-tp1018729p1025642.html Sent from the R help mailing list archive at

Re: [R] Printing RVector

2010-01-20 Thread GlenB
Does *cat(v[0])* produce what you need? -- View this message in context: http://n4.nabble.com/Printing-RVector-tp1018770p1025909.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list

Re: [R] Greek letters on a multi-line plot title

2010-01-20 Thread Jason Rupert
David, Thank you very much for your response. Is there any chance you can provide your example where mtext is used? I also tried to use mtext, but I did not have any luck, so any help with the example below working with mtext or otherwise is greatly appreciated. Thanks again, Jason

Re: [R] standardizing one variable by dividing each value by the mean -but within levels of a factor

2010-01-20 Thread Dimitri Liakhovitski
One follow up question - the proposed solution was (notice - this time I am introducing one NA in data frame x) x-data.frame(factor=c(b,b,d,d,e,e),values=c(1,NA,10,20,100,200)) x$std.via.ave-ave(x$values, x$factor, FUN=function(x)x/mean(x)) I compared the result to my own clumsy solution:

Re: [R] S3 tutorial

2010-01-20 Thread Peng Yu
On Wed, Jan 20, 2010 at 5:30 PM, Steve Lianoglou mailinglist.honey...@gmail.com wrote: Hi, On Wed, Jan 20, 2010 at 6:05 PM, Peng Yu pengyu...@gmail.com wrote: On Wed, Jan 20, 2010 at 5:04 PM, Peng Yu pengyu...@gmail.com wrote: I don't find a tutorial on S3. Bengtsson.pdf cites MASS (1999

Re: [R] x,y plot question (two sets of labels)

2010-01-20 Thread Peter Alspach
Tena koe Jonathan There are lots of ways - using base graphics or lattice or ggplot. As a start, using base graphics: plot(plothelpX, plothelpA2, col=factor(plothelpB)) points(plothelpX, plothelpA1, col=factor(plothelpB)) You'll also need the pch argument to plot and, presumably, xlab, ylab

Re: [R] Greek letters on a multi-line plot title

2010-01-20 Thread David Scott
Jason Rupert wrote: David, Thank you very much for your response. Is there any chance you can provide your example where mtext is used? I also tried to use mtext, but I did not have any luck, so any help with the example below working with mtext or otherwise is greatly appreciated. Thanks

Re: [R] Data Manipulation

2010-01-20 Thread Peter Rote
Thank you Dieter, but i still have a problem to write to file. The problem is the slash in file names (Aerospace/Defense Products Services ). If i want it to C:/ab/ so C:/ab/AdvertisingAgencies.txt is ok but C:/ab/Aerospace/Defense-MajorDiversified.txt is not head(AlexETF)

[R] Problems completely reading in a large sized data set

2010-01-20 Thread Robin Jeffries
I have been through the help file archives a number of times, and still cannot figure out what is wrong. I have a tab-delimited text file. 76Mb, so while it's large.. it's not -that- large. I'm running Win7 x64 w/4G RAM and R 2.10.1 When I open this data in Excel, i have 27 rows and 450932 rows,

Re: [R] Data Manipulation

2010-01-20 Thread Peter Rote
by the way how do i change the output 1016 Advertising Agencies CMM 1803 Advertising Agencies FMCN 2427 Advertising Agencies IPG 3093 Advertising Agencies MWW 3372 Advertising Agencies OMC 4809 Advertising Agencies VCLK 4832 Advertising Agencies VISN 5005 Advertising Agencies WPPGY 5089

[R] Using spec.ls to interpolate very long time series

2010-01-20 Thread Martin Berg
I have an very long, irregularly spaced time series (and I'm also new to spectral analysis, so please be patient.) I want to use spec.ls as an interpolator and then use the output to reconstruct the time series via inverse fft. But so far I've been having difficulty doing this.

Re: [R] Data Manipulation

2010-01-20 Thread Rolf Turner
A name such as ``Aerospace/Defense etc.'' is certainly not a legal file name under unix-alike systems, and I suspect it would not be even under Windoze. Even if it is, you shouldn't use it! Change the name to ``Aerospace-Defense Products Services'' or something like that, for goodness sake.

[R] (no subject)

2010-01-20 Thread teurlai magali
Hi is there a way in R to create a new column vector with the numbers of 2 others columns simply appended? Example : I have a column with provinces codes (1 to 19) I have a second column with districts codes (1 to ##, depending on the province) I want to create a third column with a code that

Re: [R] (no subject)

2010-01-20 Thread Henrique Dallazuanna
transform(DF, District_Unique = paste(Province, District, collapse = '')) On Thu, Jan 21, 2010 at 12:34 AM, teurlai magali teurlai...@yahoo.fr wrote: Hi is there a way in R to create a new column vector with the numbers of 2 others columns simply appended? Example : I have a column with

Re: [R] (no subject)

2010-01-20 Thread David Winsemius
On Jan 20, 2010, at 9:34 PM, teurlai magali wrote: Hi is there a way in R to create a new column vector with the numbers of 2 others columns simply appended? Example : I have a column with provinces codes (1 to 19) I have a second column with districts codes (1 to ##, depending on the

Re: [R] R.oo installation warnings?

2010-01-20 Thread Henrik Bengtsson
Hi, don't worry about those setGenericS3()/setMethodS3(0 warnings - they are just informative. I am aware of that last warning: Warning: package 'R.oo' claims to be built under R version 2.10.0 but is missing some help files and needs to be re-installed but it does not go away when you

Re: [R] Question about many-to-one merge

2010-01-20 Thread hongwei
Oh, yes, my bad. Merge works! I guess the reordering automatically made by Merge made me confused. I wrote my code using Merge several months ago, and just didn't feel it right today. Thanks anyway! -- View this message in context:

Re: [R] Question about many-to-one merge

2010-01-20 Thread hongwei
btw, the re-order and swap make it much clearer, so thanks again! -- View this message in context: http://n4.nabble.com/Question-about-many-to-one-merge-tp1018811p1037860.html Sent from the R help mailing list archive at Nabble.com. __

[R] (Solved) Problems completely reading in a large sized data set

2010-01-20 Thread Robin Jeffries
I'm not quite sure why, but reading in the *sorted* data (imported into Excel, sorted, written to a text file) worked perfectly fine with read.delim(). Thanks to those that replied! -Robin [[alternative HTML version deleted]] __

[R] question about Software for Data analysis book

2010-01-20 Thread Erin Hodgess
Dear R People: I'm sure that this is a very silly question, but I'm reading the Software for Data analysis book by John Chambers, and I can't find the Declination data that he refers to on page 15 in the book. I did all of the usual stuff: library(help=SoDA) ??Declination looked for it online

Re: [R] concatenate 2 column vectors

2010-01-20 Thread teurlai magali
Sorry I forgot the subject in my previous post Here is an example of data : province and district code of 4 locations datatry=matrix(c(8,12,3,3,1,1,16,1),4,2) colnames(datatry)-c(PROCODE,DISCODE) DISCODE is not unique for each location (there is a distrcit nb 1 in each province) I want to

Re: [R] (no subject)

2010-01-20 Thread David Winsemius
On Jan 20, 2010, at 11:10 PM, Tena Sakai wrote: Hi, When I emulate what's suggested I get an error (shown below). What does this mean? Thank you. Province - c(1, 1, 13) District - c(1, 2, 2) df$Distric_Unique - with(df, paste(Province, District, sep=.) ) Error in eval(substitute(expr),

Re: [R] concatenate 2 column vectors

2010-01-20 Thread milton ruser
Hi Magali, I confess that I still not figured out what you want, but try this: datatry2=transform(datatry,DIS=as.numeric(as.character(paste(datatry[,1],datatry[,2],sep= bests milton On Wed, Jan 20, 2010 at 11:14 PM, teurlai magali teurlai...@yahoo.frwrote: Sorry I forgot the subject in

Re: [R] concatenate 2 column vectors

2010-01-20 Thread David Winsemius
On Jan 20, 2010, at 11:14 PM, teurlai magali wrote: Sorry I forgot the subject in my previous post Here is an example of data : province and district code of 4 locations datatry=matrix(c(8,12,3,3,1,1,16,1),4,2) colnames(datatry)-c(PROCODE,DISCODE) cbind( datatry, paste(datatry[,

Re: [R] concatenate 2 column vectors

2010-01-20 Thread teurlai magali
datatry2=transform(datatry,DIS=as.numeric(paste(datatry[,1],datatry[,2],sep=))) It works like this !! You understood perfectly well what I needed ;-) Thanks to all that answered Magali --- En date de : Jeu 21.1.10, milton ruser milton.ru...@gmail.com a écrit : De: milton ruser

Re: [R] question about Software for Data analysis book

2010-01-20 Thread David Winsemius
On Jan 20, 2010, at 11:10 PM, Erin Hodgess wrote: Dear R People: I'm sure that this is a very silly question, but I'm reading the Software for Data analysis book by John Chambers, and I can't find the Declination data that he refers to on page 15 in the book. I did all of the usual stuff:

[R] how to give the index with some given index ?

2010-01-20 Thread Carrie Li
Dear R-helpers, I have a question about giving index. Suppose that I have a vector say, id=1:5, and each of them have some given index but some of them may share the same index Now, I have another vector, and I want to give it a index based what just defined. # 5 subjects test1=1:5 #

[R] how to give the index with some given index ?

2010-01-20 Thread Carrie Li
Dear R-helpers, I have a question about giving index. Suppose that I have a vector say, id=1:5, and each of them have some given index but some of them may share the same index Now, I have another vector, and I want to give it a index based what just defined. # 5 subjects test1=1:5 #

Re: [R] Memory usage in read.csv()

2010-01-20 Thread nabble . 30 . miller_2555
Hi Jim Gabor - Apparently, it was most likely a hardware issue (shortly after sending my last e-mail, the computer promptly died). After buying a new system and restoring, the script runs fine. Thanks for your help! On Tue, Jan 19, 2010 at 2:02 PM, jim holtman - jholt...@gmail.com

[R] how to give the index with some given index ?

2010-01-20 Thread Carrie Li
Dear R-helpers, I have a question about giving index. Suppose that I have a vector say, id=1:5, and each of them have some given index but some of them may share the same index Now, I have another vector, and I want to give it a index based what just defined. # 5 subjects test1=1:5 #

[R] superimpose histogram and fitted gamma pdf

2010-01-20 Thread Roslina Zakaria
Hi r-users,   I try to draw histogram (in terms of probabilty) and superimpose with the gamma pdf. Using this code below I can get the plots BUT the y scale for the density is out of scale.  How do I change the y-axis scale to max 1?  Another thing, how I do draw smooth line rather that points?

Re: [R] superimpose histogram and fitted gamma pdf

2010-01-20 Thread Rainer M Krug
On Thu, Jan 21, 2010 at 8:47 AM, Roslina Zakaria zrosl...@yahoo.com wrote: Hi r-users, I try to draw histogram (in terms of probabilty) and superimpose with the gamma pdf. Using this code below I can get the plots BUT the y scale for the density is out of scale. How do I change the y-axis

Re: [R] Data Manipulation

2010-01-20 Thread Dieter Menne
Peter Rote wrote: but i still have a problem to write to file. The problem is the slash in file names (Aerospace/Defense Products Services ). If i want it to C:/ab/ so C:/ab/AdvertisingAgencies.txt is ok but C:/ab/Aerospace/Defense-MajorDiversified.txt is not As Rolf said, the

Re: [R] permutations from vectors out of a matrix

2010-01-20 Thread Meyners, Michael, LAUSANNE, AppliedMathematics
Well, seems it's an assignment, so you should REALLY get them on your own and not enquire the list. Foolish me... M. -Original Message- From: einohr2...@web.de [mailto:einohr2...@web.de] Sent: Mittwoch, 20. Januar 2010 19:32 To: Meyners,Michael,LAUSANNE,AppliedMathematics;

<    1   2