similar to: merge two data frame based on equal and unequal comparisons

Displaying 20 results from an estimated 800 matches similar to: "merge two data frame based on equal and unequal comparisons"

2018 Mar 10
1
error message from sqldf
Dear R users, I got the following error message from running sqldf code in R. do you know how to fix it? I read the sqldf package instruction and did not find a solution. Thank you, Ding chr10 <- sqldf("select * from manifest where CHR==10") UCN3cpg <- sqldf("select * from chr10 where MAPINFO between 5405573 and 5407594), overwrite = TRUE") Error: Table chr10
2001 Jun 25
1
Linking R to GIS
Dear All, Has anyone worked with linking R to both ArcView and MapInfo GIS systems? My desire is to capture object selection from GIS and pass to R and to return spatially based statistical model results from R to GIS. If both could simultaneously access the same data file this would be a bonus. My inclination is to put together some routines based on ODBC linking but thought I would seek like
2011 Feb 05
2
Help!!! from R beginner
Hello, I'm trying to add a column to the following data frame. The new column will contain "black" when the 5th column(if_TE_related) is "TE_related", or "orange" when the 4th column is " " (space). "chromo" "MSU_locus" "end5" "end3" "if_TE_related" "chr04" "LOC_Os04g01006" 1032
2012 Jun 21
2
Simple Question?
Greetings, I am new to R, but trying to put in the time to learn. I have read the R manual and several other introductory texts; however, there is nothing like actually putting it into practice. So here is my problem, and its more of a learning exercise for myself than anything else, but I'm stuck and getting extremely frustrated that I can't figure it out. I'm trying to make a
2008 Feb 06
4
inserting text lines in a dat frame
Hi Jim I am trying to prepare a bed file to load as accustom track on the UCSC genome browser. I have a data frame that looks like the one below. > x V1 V2 V3 1 chr1 11255 55 2 chr1 11320 29 3 chr1 11400 45 4 chr2 21680 35 5 chr2 21750 84 6 chr2 21820 29 7 chr2 31890 46 8 chr3 32100 29 9 chr3 52380 29 10 chr3 66450 46 I would like to insert the following 4 lines at the beginning:
2012 Jul 02
1
apply with multiple conditions
Hello all, I have written a for loop to act on a dataframe with close to 3million rows and 6 columns and I would like to pass it to apply() to speed the process up (I let the loop run for 2 days before stopping it and it had only gone through 200,000 rows) but I am really struggling to find a way to pass the arguments. Below are the loop and the head of the dataframe I am working on. Any hints
2007 May 31
3
Venn diagram
Hello, I am a total beginner with ?R? and found a package ?venn? to create a venn diagram. The problem is, I cannot create the vectors required for the diagram. The manual say: "R> venn(accession, libname, main = "All samples") where accession was a vector containing the codes identifying the RNA sequences, and libname was a vector containing the codes identifying the
2001 Nov 07
4
Mapping in R - in the common sense
Dear R people, I am wondering how difficult it would be to produce graphs based on maps in R (like "a county is red where x is high"). I reckon this requires the coordinates for the polygons that make up the map and also a mapping to a set of identifiers to assign colours, hatches, etc. Would it be possible to pass R a vector graphics of the map and back out the polygon definitions
2004 Aug 19
3
Do you know if you can map a large minimum spanning tree in R?
Thanks Mike. My data has longitude and latitude coords and I used distAB {clim.pact} then mst {ape} to calculate my minimum spanning tree. The nodes are telecoms sites from all over Australia. My goal is to determine the minimum cost of linking them via cabling, and I'm starting by calculating the distance "as the crow flies", but will probably eventually need to calculate the
2012 Jan 18
2
Table Intersection
I've got two tables.... first one(table1): ID chrom start end Ex1 2 152 180 Ex2 10 2000 2220 Ex3 15 3000 4000 second one ( table2): chrom location name 2 160 Alv 2 190 GNN 2 100
2012 Sep 15
2
qplot: plotting precipitation data
Dear list, I wish to plot chromatin precipitation data: I would like to have a rectangles (x:end-start, y:peak) but I do not have an idea how to define x (in terms of qplot syntax) and to choose the correct geom. mydata is a subset of a larger file. > mydata chrom start end peak 1 chr11 5291000 5291926 8 2 chr11 10988025 10988526 7 3 chr11 11767950 11768676 8 4
2018 Mar 12
0
Package gamlss used inside foreach() and %dopar% fails to find an object
Hello Mikis: Thanks a lot, it worked. Could you tell me what the problem was? Regards, Nik ----- Original Message ----- From: r-help-request at r-project.org To: "r-help" Sent: Sunday, March 11, 2018 6:00:02 AM Subject: R-help Digest, Vol 181, Issue 11 Send R-help mailing list submissions to r-help at r-project.org To subscribe or unsubscribe via the World Wide Web, visit
2009 Feb 17
2
Chromatogram deconvolution and peak matching
Hi, I'm trying to match peaks between chromatographic runs. I'm able to match peaks when they are chromatographed with the same method, but not when there are different methods are used and spectra comes in to play. While searching I found the ALS package which should be usefull for my application, but I couldn't figure it out. I made some dummy chroms with R, which mimic my actual
2012 Mar 02
2
回复: Bayesian Hidden Markov Models
Dear Oscar,   Thanks for your help.It's so nice of you to explain this package to me.   Best Regards,   James LAN 发件人: Oscar Rueda [via R] <ml-node+s789695n4431468h14@n4.nabble.com> 收件人: monkeylan <lanjinchi@yahoo.com.cn> 发送日期: 2012年2月29日, 星期三, 下午 9:21 主题: Re: Bayesian Hidden Markov Models Dear James, The distances are normalized between zero and 1, so in your case all of
2011 Apr 13
1
strategy for writing out file with lines header initiated with comment sign
Dear all, I have data.frame object in R. I want to export it in tab-delimited file with several lines of header initiated with comment sign (#). I do not know how to do that in R. Could you please give helps on this problem? Thanks in advance. Best, Jian-Feng, ################################################################## The lines I want to write in the header lines look like, with words
2010 Apr 29
1
merged files
Hi, i have two files (file1.txt and file2.txt) which i would like to merge, based on certain criteria, i.e. it combines data based on matching geneID and exons. i have used the merge option, but it does not give me the desired outcome. merged.txt shows the result i would like. *File1. txt* ** AffyProbe ProbeType Flag GeneSymbol GeneID Exons Chrom Strand Affytart AffyEnd 1
2004 Sep 24
3
Error with repeat lines() in function
I have a function that does some plotting. I then add lines to the plot. If executed one line at a time, there is not a problem. If I execute the function, though, I get: Error in ans[[1]] : subscript out of bounds This always occurs after the second lines command, and doesn't happen with all of my data points (some do not have errors). Any ideas? Thanks, Sean
2006 Dec 07
6
Response To Form Submission Hanging
Hello, I am using Mechanize to post a form to a website. When I do this by hand in my browser the response takes about 35s to come back (it''s a long page full of tables and graphics). When I do this with Mechanize, the server starts to respond and then appears to hang. The obvious conclusion is that my code is wrong but I am reasonably sure that I haven''t altered it
2011 Oct 27
2
Simple time series question with zoo
New user here. My goal is pull daily averages from a long dataset. I've been working with some code I got from this list from https://stat.ethz.ch/pipermail/r-help/2009-March/191302.html The code how I have been using it is as follows: library(zoo) library(chron) DB<-read.table("/Users/me/Desktop/R/data.csv", sep=",", header=TRUE, as.is =TRUE) z<-zoo(LTER6$temp,
2008 Feb 20
1
DNAcopy package output data
Hello R Developers I am using DNACopy package http://bioconductor.org/packages/1.9/bioc/html/DNAcopy.html I am not able to figure out how to (if at all possible) to modify output format, namely, I am getting the following: "ID" "chrom" "loc.start" "loc.end" "num.mark" "seg.mean" Is it a way to get also median and standard deviation?