title: I want to combine data frames of different lengths and not getting repeated values or na
body: <p>I am fresh in R and looked a lot in the web but could not find the answer to what I am pursuing.</p>
  
  <p>I have 4 data frames with different lengths and columns. I want to put all the columns side by side without getting NA or duplicated values as I am getting now with the code below:</p>
  
  <pre><code>summBC &lt;- summary %&gt;% 
    group_by(BuildingClass) %&gt;% 
    summarise(TotalTIV=sum(as.numeric(TotalTIV))) #Pivot table on Building class
  
  summOC &lt; -summary %&gt;% 
    group_by(OccupancyType) %&gt;% 
    summarise(TotalTIV=sum(as.numeric(TotalTIV))) #Pivot table on Occupancy type
  
  summCY &lt;- summary %&gt;% 
    group_by(City) %&gt;% 
    summarise(TotalTIV=sum(as.numeric(TotalTIV))) #Pivot table on City
  
  summCR &lt;- summary %&gt;% 
    group_by(Cresta) %&gt;% 
    summarise(TotalTIV=sum(as.numeric(TotalTIV))) #Pivot table on Cresta
  
  pt &lt;- data.frame(summBC,summOC,summCY,summCR)
  </code></pre>
  
  <p>Any help would be appreciated.</p>