title: Collect information by the specific name from different data
body: <p>I have some csv files with the data. I loaded them:</p>
  
  <pre><code>tbl = list.files(pattern="*.csv")
  list_of_data = lapply(tbl, read.csv)
  </code></pre>
  
  <p>How the data looks like:</p>
  
  <p>First csv:</p>
  
  <pre><code>              Exp1  Exp2  Exp3
  Morgan.1       11    23    22
  Catrine.2      14    33    55
  Markus.1       ger   32    12
  </code></pre>
  
  <p>Second csv:</p>
  
  <pre><code>              Exp1  Exp2  Exp3
  Morgan.2       17    nex   23
  Catrine.1      15    23    15
  Markus.7       11    ger   11
  </code></pre>
  
  <p>I would like to make a single csv file of those data. How to find a data for Morgan (ignore something what's after the dot) in different csv files and put them in one file.</p>
  
  <p>Prefered output:</p>
  
  <pre><code>           Exp1  Exp2  Exp3  Exp1  Exp2  Exp3
  Morgan     17    nex   23    11    23    22
  Catrine    14    33    55    15    23    15
  </code></pre>
  
  <p>I am pretty sure that I have to make a loop to collect all of the data but let me know how to do it for a single name etc.</p>
  
  <p>That's what I did to get a list of all of the "names" in one table:</p>
  
  <pre><code>all_data = do.call(rbind.fill, list_of_data)
  data_rd &lt;- subset(transform(all_data, X = sub("\\..*", "", X)), 
         !duplicated(X))
  </code></pre>