title: Problems of merging excel files by row
body: <p><a href="https://i.stack.imgur.com/Hy2x0.jpg" rel="nofollow noreferrer">enter image description here</a>I have imported 90 excel files by creating a directory (dir) and using (lapply). All of the excel files have 5 similar variables and different numbers of observations.  Then I applied (map_dfr) to combine all the files into one file but I found that the new data frame has 10 variables and unfortunately, some observations have appeared as variable names. What might be the possible reason and solution for this ?</p>
  
  <p>setwd("F:\Spring 2019\Thesis_data\Kam_Thesis\data\nontidal_water_level")</p>
  
  <p>nontidal_list &lt;- dir(pattern= ".xlsx", full.names = T)</p>
  
  <p>nontidal_wl &lt;- lapply(nontidal_list, read_excel)</p>
  
  <p>nontide_dfr &lt;- map_dfr(nontidal_list, read_excel)</p>