title: make new column using value_counts in dataframe pandas
body: <p>i am using below formula to get value count froma. column in  a dataframe:</p>
  <pre><code>new_data = df['item'].value_counts()
  </code></pre>
  <p>which give me below result</p>
  <pre><code>Apples                    3
  Green bananas             2
  Bananas                   1
  Oranges                   1
  </code></pre>
  <p>what i want is to get output for every item count in in new column like the below excel example</p>
  <p><a href="https://i.stack.imgur.com/x7DW1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/x7DW1.png" alt="example" /></a></p>
  <p>Any help or guidance is appreciated.
  Thank you</p>