title: How to pivot dataframe string value with Python
body: <p>i have some trouble with Pivot (Seem like Pivot in excel). i tried it so many times but i have no idea. Please anyone help me.</p>
  <p>Below is a sample data.</p>
  <pre><code>Date report     Result
  01/11/2020      Achieved
  01/11/2020      Achieved
  02/11/2020      Failed
  02/11/2020      Failed
  02/11/2020      Achieved
  03/11/2020      Achieved
  </code></pre>
  <p>Then result that i need to make it as below</p>
  <pre><code>Date report      Result
  01/11/2020       100.00%
  02/11/2020       33.33%
  03/11/2020       100.00%
  </code></pre>
  <p>Remark : The percentage result comes from Countif('Date report' and 'Achieved')/Countif('Date report')</p>