Ein eingebundener Text mit undefiniertem Zeichensatz wurde abgetrennt. Name: nicht verf?gbar URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20130829/427d0faf/attachment.pl>
Hi, Try: dat1<- read.table(text=" V1 V2 V3 2 6 8 4 3 4 1 9 8 ",sep="",header=TRUE) dat2<- read.table(text=" V1 V2 V3 6 8 4 2 0 7 8 1 3 ",sep="",header=TRUE) res1<- as.matrix(dat1-dat2) res1 #??? V1 V2 V3 #[1,] -4 -2? 4 #[2,]? 2? 3 -3 #[3,] -7? 8? 5 res2<-t(t(dat1)-colMeans(dat2)) res2 #??????????? V1 V2???????? V3 #[1,] -3.333333? 3? 3.3333333 #[2,] -1.333333? 0 -0.6666667 #[3,] -4.333333? 6? 3.3333333 A.K. Hi there I've got two datasets of the following form (just an example, the real dataset got a lot more columns) dataset1 V1 V2 V3 2 6 8 4 3 4 1 9 8 and dataset 2 V1 V2 V3 6 8 4 2 0 7 8 1 3 First, I'd like to calculate the following: V1 from dataset1 minus V1 from dataset2, than V2 from dataset1 minus V2 from dataset2 ... and so on (always Vn-Vn, where n=1,2,....n) and safe the solution-vectors in a new matrix. Second I'd like to run other functions over the two matching columns (for example: V1 from dataset1 minus mean(V1) from dataset2, V2 from dataset1 minus mean(V2) from dataset2,...). So I'm looking for a simple solution that always takes the matching columns from the different datasets and than I can just change the function for the two. Thank you for your help! Kind regards
Hi, Using the same datasets: dat1<- read.table(text=" V1 V2 V3 2 6 8 4 3 4 1 9 8 ",sep="",header=TRUE) dat2<- read.table(text=" V1 V2 V3 6 8 4 2 0 7 8 1 3 ",sep="",header=TRUE) sapply(seq_len(ncol(dat1)),function(i) cor(dat1[,i],dat2[,i],method="spearman")) #[1] -1.0000000? 0.5000000 -0.8660254 #or ?diag(cor(dat1,dat2,method="spearman")) #??????? V1???????? V2???????? V3 #-1.0000000? 0.5000000 -0.8660254 A.K. ----- Original Message ----- From: laro <l_rohner at gmx.ch> To: r-help at r-project.org Cc: Sent: Friday, August 30, 2013 12:52 PM Subject: Re: [R] calculate with different columns from different datasets Thank you a lot A.K.! One more question: I'd like to compute the Spearman's rank correlation coefficients for V1 (from dat1) and V1 (from dat2) and so on... Do you know how to do that? I managed to write the Pearson's correlation product moment coefficient with your sapply-approach, but I have no idea how to rank it. Kind regards -- View this message in context: http://r.789695.n4.nabble.com/calculate-with-different-columns-from-different-datasets-tp4674918p4675034.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.