title: Make a table from 2 columns
body: <p>I'm fairly new on Python.</p>
  
  <p>I have 2 columns on a dataframe, columns are something like: </p>
  
  <pre><code>db = pd.read_excel(path_to_file/file.xlsx)
  db = db.loc[:,['col1','col2']]
  
  col1  col2
  C     4
  C     5
  A     1
  B     6
  B     1
  A     2
  C     4
  </code></pre>
  
  <p>I need them to be like this:</p>
  
  <pre><code>   1 2 3 4 5 6
  A  1 1 0 0 0 0
  B  1 0 0 0 0 1
  C  0 0 0 2 1 0
  </code></pre>
  
  <p>so they act like rows and columns and values refer to the number of coincidences.</p>