[R] Help with merge function

2013-04-26 Thread Catarina Ferreira
Dear all, I'm trying to merge 2 dataframes, but I'm not being entirely successful and I can't understand why. Dataframe x1 State_prov Shape_name bob2009 bob 2010 bob2011 Nova ScotiaAnnapolis 0 0 1 Nova ScotiaAntigonish0

Re: [R] Help with merge function

2013-04-26 Thread Rui Barradas
Hello, The following seems to do the trick. x1 - structure(list(State_prov = c(Nova Scotia, Nova Scotia, Nova Scotia ), Shape_name = c(Annapolis, Antigonish, Gly), bob2009 = c(0L, 0L, NA), bob2010 = c(0L, 0L, NA), bob2011 = c(1L, 0L, NA)), .Names = c(State_prov, Shape_name, bob2009, bob2010,

Re: [R] Help with merge function

2013-04-26 Thread Catarina Ferreira
Hello, Thank you for your help. However the dataframes I gave you were only examples, the actual dataframes are very big. Does this mean I have to write every range of data for each variable?? On Fri, Apr 26, 2013 at 2:25 PM, Rui Barradas ruipbarra...@sapo.pt wrote: Hello, The following

Re: [R] Help with merge function

2013-04-26 Thread arun
-project.org Cc: Sent: Friday, April 26, 2013 1:10 PM Subject: [R] Help with merge function Dear all, I'm trying to merge 2 dataframes, but I'm not being entirely successful and I can't understand why. Dataframe x1 State_prov    Shape_name  bob2009  bob 2010  bob2011 Nova Scotia    Annapolis

Re: [R] Help with merge function

2013-04-26 Thread Rui Barradas
Hello, I don't understand the question, what range? I've just changed the 'all' argument to 'all.y', without doing anything special to the variables. Can you explain what you mean? Rui Barradas Em 26-04-2013 19:30, Catarina Ferreira escreveu: Hello, Thank you for your help. However the

Re: [R] Help with merge function

2013-04-26 Thread arun
#3 Nova Scotia    Gly   0   0  NA   2   1 A.K. From: Catarina Ferreira catferre...@gmail.com To: arun smartpink...@yahoo.com Sent: Friday, April 26, 2013 2:23 PM Subject: Re: [R] Help with merge function Hello, I didn't realize

Re: [R] Help with merge function

2013-04-26 Thread arun
...@yahoo.com Sent: Friday, April 26, 2013 4:20 PM Subject: Re: [R] Help with merge function here they are. As you see the NS_update is data for only 1 province and I want it to add this data to the bigger file (data), merging the common columns and adding the new columns. But what it is doing