title: Frequency of Words in Column of Strings
body: <p>I'm looking for a query that will allow me to</p>
  <p>Imagine this is the table, &quot;News_Articles&quot;, with two columns: &quot;ID&quot; &amp; &quot;Headline&quot;. How can I make a result from this showing</p>
  <p><strong>NEWS_ARTICLES</strong></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>Headline</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>0001</td>
  <td>Today's News: Local Election Today!</td>
  </tr>
  <tr>
  <td>0002</td>
  <td>COVID-19 Rates Drop Today</td>
  </tr>
  <tr>
  <td>0003</td>
  <td>Today's the day to shop local</td>
  </tr>
  </tbody>
  </table>
  </div>
  <ol>
  <li>One word per row (from the headline column)</li>
  <li>A count of how many unique IDs it appears in</li>
  <li>A count of how many total times the word appears in the whole dataset</li>
  </ol>
  <p><strong>DESIRED RESULT</strong></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Word</th>
  <th>Unique_Count</th>
  <th>Total_Count</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Today</td>
  <td>3</td>
  <td>4</td>
  </tr>
  <tr>
  <td>Local</td>
  <td>2</td>
  <td>2</td>
  </tr>
  <tr>
  <td>Election</td>
  <td>1</td>
  <td>1</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Ideally, we'd like to remove any conjunctions from the words as well (see &quot;Today's&quot; above is counted as &quot;Today&quot;).</p>
  <p>I'd also like to be able to remove filler words such as &quot;the&quot; or &quot;a&quot;. Ideally this would be through some existing library but if not, I can always manually remove the ones I see with a where clause.</p>
  <p>I would also change all characters to lowercase if needed.</p>
  <p>Thank you!</p>