title: join files based on one column and different orders in R or python
body: <p>I have 3 tab separated file like the following 3 examples:</p>
  
  <p>example files:</p>
  
  <pre><code>AB  45.2    4.56    0.21
  FG  78.1    54.1    36.1
  HG  98.1    25.0    12.6
  TR  1.2 3.25    65.1
  
  
  TR  5.2 41.6    10.21
  HG  8.1 23.1    56.1
  FG  9   32.0    32.6
  AB  12.2    31.25   5.1
  
  
  HG  15.2    21.6    20.21
  TR  31.1    32.1    66.1
  AB  12.1    12.0    62.6
  FG  11.3    31.25   54.1
  </code></pre>
  
  <p>the 1st column in all of them has similar items but in different order. I want to join the files based on the 1st column and make a new file like the expected output:</p>
  
  <p>expected output</p>
  
  <pre><code>AB  45.2    4.56    0.21    12.2    31.25   5.1 12.1    12.0    62.6
  FG  78.1    54.1    36.1    9   32.0    32.6    11.3    31.25   54.1
  HG  98.1    25.0    12.6    8.1 23.1    56.1    15.2    21.6    20.21
  TR  1.2 3.25    65.1    5.2 41.6    10.21   31.1    32.1    66.1
  </code></pre>
  
  <p>I tried to use <code>join</code> function in <code>R and pandas</code> but they do not return the expected output. do you know how I can do that in python or R?</p>