I have 2 tables,T1 and T2. There are 4 columns of T1 and 2 columns of T2 T2 1. 990334. G000021 2. 844047. G000025 3. 281739. G000037 4 280903. G002615 5 418546. G004657 The data in T1 V1 V2 V3 V4 1 T00015 AFP1 human G004657 2 T00035 AP-2alphaA human G002615 3 T00036 AP-4 human G003918 4 T00040 AR human G004953 5 T00045 COUP-TF2 human G004656 I want to construct T3 that has all the columns of T1 and T2 with the common GOO$$$$ (common elements of column 4 of T1 and column 2 of T2.). I used "match" but it did not work. T3 should look like where G002615 and G004657 are common. T00015 AFP1 human G004657 418546. T00035 AP-2alphaA human G002615 280903. any help would be appreciated. [[alternative HTML version deleted]]
Try ?merge Ted. On 25-Mar-08 22:32:29, Kris Ghosh wrote:> I have 2 tables,T1 and T2. There are 4 columns of T1 and 2 columns of > T2 > T2 > > 1. 990334. G000021 > 2. 844047. G000025 > 3. 281739. G000037 > 4 280903. G002615 > 5 418546. G004657 > > The data in T1 > V1 V2 V3 V4 > 1 T00015 AFP1 human G004657 > 2 T00035 AP-2alphaA human G002615 > 3 T00036 AP-4 human G003918 > 4 T00040 AR human G004953 > 5 T00045 COUP-TF2 human G004656 > > > I want to construct T3 that has all the columns of T1 and T2 with the > common > GOO$$$$ (common elements of column 4 of T1 and column 2 of T2.). I > used > "match" but it did not work. > > T3 should look like where G002615 and G004657 are common. > > T00015 AFP1 human G004657 418546. > T00035 AP-2alphaA human G002615 280903. > > any help would be appreciated. > > [[alternative HTML version deleted]] > > ______________________________________________ > 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.-------------------------------------------------------------------- E-Mail: (Ted Harding) <Ted.Harding at manchester.ac.uk> Fax-to-email: +44 (0)870 094 0861 Date: 25-Mar-08 Time: 22:55:39 ------------------------------ XFMail ------------------------------
Hey everyone, For my research, I needed a peak detector algorithm that can spot peaks in an intensity graph. The excel http://www.nabble.com/file/p16313309/sample%2Bdata.xls sample data that I've attached contains columns of such intensity graphs. I came found an algorithm developed by the http://www.bioconductor.com Bioconductor team and was excited to test it out on my own data. However, it is written in R. With my own programming experience being Matlab and having little experience with programming to begin with, I've hit a bit of a road block and need whatever help you guys can offer. I need to run my data through this algorithm and see what kind of peaks are detected. How do I format my excel data to a .rda format that the algorithm can work with? The algorithm can be found http://www.bioconductor.org/packages/bioc/html/MassSpecWavelet.html here . To load the package, enter: source("http://bioconductor.org/biocLite.R") biocLite("MassSpecWavelet") library(MassSpecWavelet) The package comes with a sample data that is VERY similar to my own data (which is why I think it will work for my project) To load the packaged example data and see what the package does, enter: data(exampleMS) SNR.Th <- 3 peakInfo <- peakDetectionCWT(exampleMS, SNR.Th=SNR.Th) majorPeakInfo = peakInfo$majorPeakInfo peakIndex <- majorPeakInfo$peakIndex plotPeak(exampleMS, peakIndex, main=paste('Identified peaks with SNR >', SNR.Th)) Any help you guys can offer will be greatly appreciated. Thanks! -- View this message in context: http://www.nabble.com/Newbie-question-tp16313309p16313309.html Sent from the R help mailing list archive at Nabble.com.