title: Need to have a pie chart representation of data in an excel file using Python
body: <p>Need to have a pie chart representation of data in an excel file using Python.
  I have a column as 
  |<strong>Values</strong>|
  |Yes|
  |No|
  |Yes|
  |Yes|
  |No|</p>
  
  <p>I want to have above values(Yes / No) represented as a pie chart on the basis of counts of their occurrence with the help of Python. Please suggest.</p>
  
  <p>EDITED:
  One thing that needs to be denoted i.e. Counts of Yes and Counts of No. (Better if we can have that in %). Currently it is drawing a pie chart but no counts. I am attaching a screenshot for reference.<a href="https://i.stack.imgur.com/imgcH.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/imgcH.jpg" alt="enter image description here"></a></p>