[R] R -SQL
Hello, I've got a problem in a sql query! for(j in 1:length(criteria$Title)) { graphe_par<-sqlQuery(channel,"select q.type,crit.Title, r.Value from criteria crit, reply r,question_reply qr, question q, question_criteria qc, form_question fq where qr.reply=r.ID and qr.question=q.ID and qc.question=q.ID and crit.ID=qc.criteria and fq.question=q.ID and fq.form=4 and crit.Title=" & criteria$Title[j] &";") } > criteria$Title [1] Content Logistic Trainer Supply User contribution Levels: Content Logistic Supply Trainer User contribution The error is: Error in "select q.type,crit.Title, r.Value from criteria crit, reply r,question_reply qr, question q, question_criteria qc, form_question fq where qr.reply=r.ID and qr.question=q.ID and qc.question=q.ID and crit.ID=qc.criteria and fq.question=q.ID and fq.form=4 and crit.Title=" & : operations are possible only for numeric or logical types In addition: Warning message: & not meaningful for factors in: Ops.factor("select q.type,crit.Title, r.Value from criteria crit, reply r,question_reply qr, question q, question_criteria qc, form_question fq where qr.reply=r.ID and qr.question=q.ID and qc.question=q.ID and crit.ID=qc.criteria and fq.question=q.ID and fq.form=4 and crit.Title=", please help me, Thanks a lot! Sabine - ils, photos et vidéos ! [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] hello
I would like to donc an AFC (factoriel correspondance analysis) and I know that on Splus, the function to do that is afc(data). But on R??? is it acm? That a lot! Sabine - ils, photos et vidéos ! [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] plot 3D
Is it possible to do a graphic in 3D? This is my source: but this one is on 2D and at moment variables put on other variables, so it is difiicult to differentiate them visibly. plot(corresp(data,nf=2),xlim=c(-1,1),ylim=c(-1,1)); Thanks Sabine - ils, photos et vidéos ! [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] Barplot2 Title
Hello, I would like to know if it's possible to modify the name of groups of bar because on my barplot2, I have 5 groups of bars and one of them is called "User Contributes" and when I save the plot "User contributes" is to big so I don't have it on my plot! Is it pssible to put the name vertically! Thanks! Sabine - ils, photos et vidéos ! [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] Similarity between variables
Hi, I would like to know the similarity between variables, but I don't exactly how begin and as from what dataframe or matrix! I have a matrix where in row I have 'Good', 'Medium','Bad' and in columns I have my Criterions ! What function and package should I use? Thanks a lot Sabine - ils, photos et vidéos ! [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] Polar Graph
Hi, I would like to do a polar graph (=star graph) ! is that graph existing on R? Because more softwares can do that but I don't found it on R! Thanks Sabine - ils, photos et vidéos ! [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] htlm3D made4
Hi, I would like to know if people have found the package made4 to load! I would like the .zip If you have the @ on internet to load it please give me it! Thanks a lot, Sabine - [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] matrix
hi, is it possible to create a matrix with one row and according to add a row? in fact, at present, I'm doing an algorithm which fill a matrix. On the web site of CRAN, the package basic is impossible to be load! can you tell me where i can found it! Thanks Sabine - [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] color on barplot
Hello, On my barplot, I have on the axis y, the names of the rows of my matrix r_mat! is it possible to change the color of these names on my barplot? barplot2(t(r_mat),beside=TRUE,horiz=TRUE,plot.grid=TRUE,xlab="R",font.lab=4,las=2,xlim=c(0,1)) thanks, Sabine - [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] plot3d
hello, to use the function plot3d, i should use the package R.basic! plot3d {R.basic} If people know exactly a site to load this package, please give me the URL! Thanks Sabine - [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] plot(corresp(data)...)
hi, My code: data<-matrix(data=c(0.425,0.5,0.75,0.125,0.25,0.475,0.375,0.25,0.625,0.5,0.1,0.125,0,0.25,0.25),nrow=3,ncol=5,byrow=TRUE, dimnames=list(c("Good","Medium","Bad"),c("Content","Logistic","Trainer","Supply","User contribution"))) plot(corresp(data,nf=2),xlim=c(-1,1),ylim=c(-1,1)); The plot is illegible, I want to do this in 3d, but I don't know how! please help me, send me source if you can! thanks Sabine - [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] Is it possible to get the first letter of a word?
Hi, I would to get the first letter of a word like: > title_cat TitleCat 1 Training I would like T from Training! Thnaks a lot for your help Sabine - Téléchargez le ici ! [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] barplot legend
Hi, Is it possible ti put the legend out of a barplot? tanks Sabine - [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] compare two lists with differents levels
Hi, I would like to compare 2 lists resulted from a sql query! bu there are different levels, so when I want to do: release1<-sqlQuery(channel,paste("select distinct c.ID,c.Title TitleCrit from category cat, category_criteria cc, criteria c, question_criteria qc, question q, form_question fq, form f, release_form rf, release r, product_release pr, product p where cat.ID=cc.category and cc.criteria=c.ID and c.ID=qc.criteria and qc.question=q.ID and fq.question=q.ID and fq.form=f.ID and f.ID=rf.form and rf.release=r.ID and r.ID=pr.release and pr.product=p.ID and r.ID='",param1,"';",sep="")) release2<-sqlQuery(channel,paste("select distinct c.ID,c.Title TitleCrit from category cat, category_criteria cc, criteria c, question_criteria qc, question q, form_question fq, form f, release_form rf, release r, product_release pr, product p where cat.ID=cc.category and cc.criteria=c.ID and c.ID=qc.criteria and qc.question=q.ID and fq.question=q.ID and fq.form=f.ID and f.ID=rf.form and rf.release=r.ID and r.ID=pr.release and pr.product=p.ID and r.ID='",param2,"';",sep="")) data_NA<-matrix(data=0,nrow=length(release$Title),ncol=length(formv$TitleCrit),byrow=TRUE, dimnames=list(as.factor(release$Title),paste(as.factor(formv$TitleCrit),"(",formv$first_letter,")",sep=""))) for (i in 1:length(formv$TitleCrit)) { for(k in 1: length(release1$TitleCrit)) { if(formv$TitleCrit[i]==release1$TitleCrit[k]) { data_NA[1,formv$TitleCrit[[i]]]<-1 } else{data_NA[1,formv$TitleCrit[[i]]]<-NA} } } for (i in 1:length(formv$TitleCrit)) { for(k in 1: length(release2$TitleCrit)) { if(formv$TitleCrit[i]==release2$TitleCrit[k]) { data_NA[2,formv$TitleCrit[[i]]]<-1 } else{data_NA[2,formv$TitleCrit[[i]]]<-NA} } } On R: Error in Ops.factor(formv$TitleCrit[i], release2$TitleCrit[k]) : level sets of factors are different How can I compare these 2 lists? Thanks SABINE - [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] function par(mfrow....)
Hi, I have made 3 barplots differents in the some window plot with the function par(mfrow), but is it possible to give different dimension to this 3 parts. for example, I want the first part smaller than the others. I have attached my plot! thanks Sabine - __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] choice of graph
Hi, It's about 2 weeks that I think about a graph to translate my datas. But I don't have an really idea. I 'm going to expose you my problem: I have a questionnaire with 15 questions and you have more possibilties to answer to these. For example: The trainer is competent: Yes No I have learn a lot at the training: Bad Quit bad Medium Good Quit good etc I would like to represent all my question on the same plot and differentiate the different type of answer possible. On my first impression, I had doing a classification of the different type of answer and doing a barplot, but my responsable don't want a classification but want to see all the question with their own type of answer. I have attached my first idea! Can you please help me? Thanks a lot Sabine - __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] delete a row from a matrix
Hi, I would like to know if it's possible to delete a rox from a matrix? > fig [,1] [,2] [,3] [,4] [1,]01 0.0 0.2 [2,]01 0.2 0.8 [3,]01 0.8 1.0 [4,]01 NA NA [5,]01 NA NA I would like to delete the 2 rows with NA! Thanks Sabine - [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] text on some lines
Hi, I would like to write text on 2 lines for example. For example, if you have a long sentence and you want to cut it at the 45 caracter and put the continuation underneath! Is it possible? Thanks Sabine - [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] sqlQuery
Hello, (sqlQuery(channel, "select * from..")) I would like to know if it's possible to put a file name in the parameters of the function 'sqlQuery' instead of putting the query . If it's possible, what kind of extension for my file have I need? That's for your help Sabine [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] Downloading the basic package
Hi, I search the basic package via internet! could you please help me if you have found it! Thanks Sabine [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] Connection problem to MySQL
Hello, I've got a problem about my connection to my database. My first problem is when I load the package MySQL (after loading DBI package), I've got this message: " change FPU control word from 8001f to 9001f " After that I would like to do the connection: > con<-dbConnect(MySQL(), user="pegase",pass="*",dbname="pegase",host="++") Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect [EMAIL PROTECTED] on dbname "pegase") (for security I have hiden th pass and the host) Releases that I'm using: R 2.1.0 RMySQL 0.5-5 DBI 0.1-9 MySQL 4.1.8-nt After most research on the net, I have found your email! I hope that you can help me! Thanks a lot for your help Sabine [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html