title: Using awk to split column, count occurrences
body: <p>I have an input file in the form:</p>
  
  <pre><code>type   count
  "apples, oranges, bananas"   3  
  oranges   5  
  "apples, bananas"   10  
  "oranges, bananas"   2
  </code></pre>
  
  <p>and I am trying to calculate the total number of apples, oranges, and bananas in the file (the first column is comma-separated). So the output should look something like:</p>
  
  <pre><code>apples   13  
  oranges   10  
  bananas   15  
  </code></pre>
  
  <p>I am having trouble coming up with a simple awk expression to sum over the unique elements of the split column. Any thoughts?</p>