title: Finding count of substring in a column in pandas dataframe and getting the wrong answer
body: <p>So I need to find the count of &quot;tropical&quot; and &quot;fruity&quot; in description column of wines table in kaggle mini course on pandas.</p>
  <p>Here is what ive written :</p>
  <pre><code>count_t = reviews.description.str.count(&quot;tropical&quot;).sum()
  count_f = reviews.description.str.count(&quot;fruity&quot;).sum()
  descriptor_counts = pd.Series([count_t, count_f], index = ['tropical', 'fruity'])
  print(descriptor_counts)
  </code></pre>
  <p>The output I am getting for this is :</p>
  <pre><code>tropical    3703
  fruity      9259
  dtype: int64
  </code></pre>
  <p>The solution given on kaggle is :</p>
  <pre><code>n_trop = reviews.description.map(lambda desc: &quot;tropical&quot; in desc).sum()
  n_fruity = reviews.description.map(lambda desc: &quot;fruity&quot; in desc).sum()
  descriptor_counts = pd.Series([n_trop, n_fruity], index=['tropical', 'fruity'])
  print(descriptor_counts)
  </code></pre>
  <p>and output for this correct snippet by kaggle is :</p>
  <pre><code>tropical    3607
  fruity      9090
  dtype: int64
  </code></pre>
  <p>Why is my code snippet giving a different count than the suggested solution and why is there a difference in count ?</p>