title: counting the frequency of value in a column
body: <p>I have data with different Projects that have Pathway A-E and Likelihood either "unlikely", "possible" or "likely". The data looks like this (but with many more projects - so more rows):</p>
  
  <pre><code>   Project   Pathway   Likelihood
  1    Red        A       unlikely
  2    Red        B       possible
  3    Red        C       likely
  4    Red        D       possible
  5    Red        E       possible
  6    Blue       A       possible
  7    Blue       B       unlikely
  8    Blue       C       possible
  9    Blue       D       possible
  10   Blue       E       unlikely
  11   Green      A       unlikely
  12   Green      B       possible
  13   Green      C       likely
  14   Green      D       possible
  15   Green      E       possible
  16   Yellow     A       unlikely
  17   Yellow     B       unlikely
  18   Yellow     C       possible
  19   Yellow     D       possible
  20   Yellow     E       likely
  </code></pre>
  
  <p>For each Pathway, I want to count the number of "unlikely", "likely" &amp; "possible" from the Likelihood column, so that I can make a dataframe with each Pathway as a row and unlikely, possible and likely as columns.</p>
  
  <p>Does anyone know the best way to do this?</p>
  
  <p>Thanks in advance!</p>