title: Create Pandas DataFrame from 2 tuple lists with common first elements
body: <p>I currently have 2 lists of tuples, both of which have the same information on the first element of the tuple. I'm trying to see if there is a way to &quot;Join&quot; these two tuple lists in a dataframe based on their common elements. Something like an SQL JOIN on a common column.</p>
  <p>Lists are something like this:</p>
  <pre><code>listA = [(0, A), (1, B), (2, C)]
  listB = [(0, G), (1, H), (2, I)]
  </code></pre>
  <p>and what I'm trying to achieve is a dataframe that looks something like this:</p>
  <pre><code>Col1  Col2  Col3
   0      A     G
   1      B     H
   2      C     I
  </code></pre>
  <p>Ideally, I dont want to &quot;extract&quot; the first element of a single list into a separete one and use that as the first column. I really want this &quot;Join on the common column&quot; functionality. The reason being that Im not sure that the tuples match on every single place and so I would like that be cared for automatically (like in SQL).</p>