Displaying 20 results from an estimated 10000 matches similar to: "arguments in merge() not accepted"
2008 May 14
2
dataframes to a list
Hi R,
I have the data frames, data1, data2....data50. Now I want to put all of
these in a single list. But,
>list(data1, data2,.........data50) is very big to write. How do I then
do it?
Thanks,
Shubha
This e-mail may contain confidential and/or privileged i...{{dropped:13}}
2009 Nov 06
1
probem on merge data
Hi there,
data1<-matrix(data=c(1,1.2,1.3,"3/23/2004",1,1.5,2.3,"3/22/2004",2,0.2,3.3,"4/23/2004",3,1.5,1.3,"5/22/2004"),nrow=4,ncol=4,byrow=TRUE)
data1<-data.frame(data1)
names(data1)<-c("areaid","x","y","date")
data1
areaid x y date
1 1 1.2 1.3 3/23/2004
2 1 1.5 2.3 3/22/2004
3 2
2011 Oct 07
2
Merge dataframes
Hello,
I am having some problems to use the 'merge' function. I'm not sure if I got
its working right.
What I want to do is:
1) Suppose I have a dataframe like:
height width
1 1.1 2.3
2 2.1 2.5
3 1.8 1.9
4 1.6 2.1
5 1.8 2.4
2) And I generate a second
2009 Feb 26
2
Merge question
Hi:
I am a new R user. I have the following question and would appreciate your input
Data1 (data frame 1)
p1,d1,d2 (p1 is text and d1 and d2 are numeric)
xyz,10,25
Data2 (data frame 2)
p1,d1,d2
xyz,11,15
Now I want to create a new data frame that looks like so below. The fields d1 and s2 are summed by the product key.
Data3
p1,d1,d2
xyz,21 (sum of 10 from Data1 and 11 from Data2),40 (sum of 25
2009 Aug 18
1
function merge()
Hi,
Actually, i use the function merge like this:
(Data1 <- Data1[1:7,1:3])
Policy.Number AXA.Entity Country
1 1060000077 BNL BNL
2 4001023 CH BNL
3 1060000006 UK BNL
4 4001025 CH BNL
5 6.00E+13 USA BNL
6 6100001 UK BNL
7 4001028 USA BNL
> Data2 <-
2008 Aug 21
1
problem merging two data sets ( one with a header and one without)
I have two set of data, Data1 and Data2 . Data1 has a header and Data2 does
not. I would like to merge the two data sets after removing some columns
from data2 .
I am having a problem merging so I had to write and read final data and
specify the ?header=F? so the merge can be done by?V1?. Is there a way to
avoid this step. The problem is when I do cbind the FinalData has different
column names
2011 Feb 11
1
Using merge
Hi,
I have two tables and I need to merge both. I use the merge command, but
in this way the name must be exactly. How I can make to compare
independently of upper or lower-case?
Look:
data1<-data.frame(journal=c("Ecology","Environmental
Entomology","Neotropical Biology And Conservation"))
2010 Jan 27
2
Merge: sort=F not preserving order?
Hello,
I have the following data1 (index are chars):
?? ?index
1 ?008823
2 ?012689
3 ?004503
4 ?002991
5 ?012689
6 ?002845
7 ?012689
8 ?012395
9 ?012689
10 009302
11 002845
12 006669
13 008823
14 009302
15 025340
16 012689
and data2 in this format (index2 are chars):
?? ? ? index2 ? ? ?tic
1 ? ? 001003 ? ? ANTQ
2 ? ? 001004 ? ? AIR
3 ? ? 001009 ? ? ABSI
4 ? ? 001011 ? ? ACSE
etc
I am
2006 Feb 22
2
Merging data
Hello all,
I am fairly new to R and am trying to bring together data from multiple sources. Here is one problem that I cannot seem to crack – I hope somebody can help. Let me simplify the problem: Let’s say I have two datasets: DATA1 and DATA2. I would like to work with all the cases in DATA2. I have additional variables on these cases in DATA1, which is a larger data set with many
2008 Jun 03
2
merge two data sets
I would like to merge ?data1 ?that contains 100 unique ID?s with another
data set ?data 2? with 150 ID?s and the age of those individuals ( the ID in
data1 is a subset of the ID in data 2) I would like to merge these data1
with data2 and have the result of the merge to have the ID ordered as in
data1.
Can this be done in R?
--
View this message in context:
2003 Apr 10
6
How to plot several graphs in a single 2-D figure?
Hi, R-listers
I tried to plot several graphs in a sigle x-y coordinate settings, like the
following:
|(y) s
| ****** s
| ***** s
| sssssssssssssssssss
|_______________________________(x)
where "*" and "s" denote two diffrent plots.
However, when I used
plot(data1); % data1 is the data points of "*"
2008 Jun 05
1
problems with reading the data and merge
I have a problem with reading a file data.txt that has a header
Each row has the individual ID and then some data that are letter and
numbers such as 00
If I read the file as
data<-read.table("data.txt",sep='\t', header=T)
write.table(data,file="data1.txt", sep='\t', quote=F, col.names=T,
row.names=F)
data1.txt looks different than data.txt. In
2009 Nov 13
2
why the same values cannot be judged to be the same in R
Hi Rusers,
I found sometimes that the same values cannot be judged to be the same in
R. Anybody knows the probelm? I think i ignored some minor detail. Thanks.
Here is the example.
############
data1<-matrix(data=c(1,1.2,1.3,"3/23/2004",1,1.5,2.3,"3/22/2004",2,0.2,3.3,"4/23/2004",3,1.5,1.3,"5/22/2004"),nrow=4,ncol=4,byrow=TRUE)
2010 Sep 06
1
combining collumns for data.frames
Hi
This question is far less simple than the title suggests, please read carefully, thanks.
I have 2 sets of data, both read into R
>data1<-read.table ("1.txt", header=T, sep="\t")
>data2<-read.table ("2.txt", header=T, sep="\t")
>data1
Taxon stage1 stage2 stage3 stage4
T1 0 0 1 1
T2 0
2011 Nov 16
3
plotting a double y axis when x and y lengths differ
Hello All,
Many thanks to the help I have received so far.
Here is an example data set I hope to plot
Data1
Year Data SE
1 2005 2 0.01
2 2006 4 0.01
3 2007 5 0.01
4 2008 2 0.01
5 2009 3 0.01
6 2010 6 0.01
Data2
Year Data SE
1 2006 32 1
2 2007 100 2
3 2008 60 4
4 2009 67 3
5 2010 8 1
Notice Data2 has one less years worth of data than Data1 (which is my
2008 Jun 04
4
merging 3 data sets at once
Hi All,
I am looking into merging 3 data sets I know how to do that by merging data1
with data2 and then merging the result with data 3. I was wondering if it
can be done all at once so I tried,
M<-merge(data1,data2,data3, by=?ID?)
It does not work!
Any ideas?
--
View this message in context: http://www.nabble.com/merging-3-data-sets-at-once-tp17658873p17658873.html
Sent from the R help
2010 May 28
1
Match 2 vectors
Hi,
I have 2 dataframes of unequal length, and I would like to match a
factor to them so that both dataframes will have the same number of
rows.
example:
# create the 2 dataframes with unequal length
data1 <- data.frame(letters, 1:26)[-c(5,10,19:21),]
data2 <- data.frame(letters, 1:26)[-c(6,9,15:18),]
data2a <- match(data1[,1], data2[,1])
data2b <- data2[data2a,]
When I match
2008 Nov 04
1
fuse_setlk_cbk error
I'm building a two node cluster to run vserver systems on. I've setup
glusterfs with this config:
# node a
volume data-posix
type storage/posix
option directory /export/cluster
end-volume
volume data1
type features/posix-locks
subvolumes data-posix
end-volume
volume data2
type protocol/client
option transport-type tcp/client
option remote-host
2012 May 27
3
Problem with strptime
Hello Forum,
I have a problem with the strptime function. With the ''data1'' dataset below
it works fine, but with the ''data2'' dataset something goes wrong (see final
line below). Both data1 and data2 are in exactly the same original format,
the only difference is that they span different dates. Please help, since it
is driving me nuts! Many thanks.
Best
2002 Dec 05
1
Passing options as lists
Hi,
I apologize if this has previously been posted. I've just subscribed to the
R-help digest.
I'm writing a plotting function that uses layout() to plot several different
plots on the same device. This function uses plot(), image(), and a custom
function that uses text(). Each cell of the layout needs different par()
parameters, so what I'd like to do is pass them as lists: