title: Rbind and merge in R
body: <p>So I have this big list of dataframes, and some of them have matching columns and others do not. I want to rbind the ones with matching columns and merge the others that do not have matching columns (based on variables Year, Country). However, I don't want to go through all of the dataframes by hand to see which ones have matching columns and which do not.</p>
  
  <p>Now I was thinking that it would look something along the lines of this:</p>
  
  <pre><code>myfiles = list.files(pattern="*.dta")
  dflist &lt;- lapply(myfiles, read.dta13)
  
  for (i in 1:length(dflist)){
  
    if colnames match
      put them in list and rbindlist.
    else put them in another list and merge.
  }    
  </code></pre>
  
  <p>Apart from not knowing how to do this in R exactly, I'm starting to think this wouldn't work after all.</p>
  
  <p>To illustrate consider 6 dataframes:</p>
  
  <pre><code>Dataframe 1:                          Dataframe 2:
  
  Country Sector Emp              Country   Sector Emp
  Belg      A     35                NL        B     31
  Aus       B     12                CH        D     45
  Eng       E     18                RU        D     12
  
  Dataframe 3:                      Dataframe 4:
  Country Flow    PE               Country  Flow PE   
  NL        6     13                 ...    ...   ... 
  HU        4     11                 ...    ...
  LU        3     21                 ...
  
  Dataframe 5:              dataframe 6:
  
  Country Year Exp          Country Year Imp 
   GER     02   44           BE      00   34
   GER     03   34           BE      01   23
   GER     04   21           BE      02   41 
  </code></pre>
  
  <p>In this case I would want to rbind (dataframe 1,dataframe2) and rbind(dataframe 3, dataframe 4), and I would like to merge dataframe 5 and 6, based on variables  country and year. So my output would be several rbinded/merged dataframes..</p>