title: How to count word frequency in python dataframe?
body: <p>I uploaded an excel text file. I want to count the number of times each word occurs, for instance: </p>
  
  <p>Output:</p>
  
  <pre><code>was 2
  report 1
  county 5
  increase 2
  </code></pre>
  
  <p>Code:</p>
  
  <pre><code> news = pd.read_excel('C:\\Users\\farid-PC\\Desktop\\Tester.xlsx')
   pd.set_option('display.max_colwidth', 1000)
   print(news)
   #implement word counter?
  </code></pre>
  
  <p>Current Output:</p>
  
  <pre><code>   Text
  0  Trump will drop a bomb on North Korea
  1  Building a wall on the U.S.-Mexico border will take literally years
  2  Wisconsin is on pace to double the number of layoffs this year.
  3  Says John McCain has done nothing to help the vets.
  4  Suzanne Bonamici supports a plan that will cut choice for Medicare 
  </code></pre>
  
  <p>Any help will be appreciated. </p>