Here is a sample of my data for one month (i can't provide more) :
<style type="text/css">
.tg {border-collapse:collapse;border-spacing:0;}
.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;
overflow:hidden;padding:10px 5px;word-break:normal;}
.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;
font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}
.tg .tg-0lax{text-align:left;vertical-align:top}
</style>
<table class="tg">
<thead>
<tr>
<th class="tg-0lax">CREATEDDATE</th>
<th class="tg-0lax">ISCONVERTED</th>
</tr>
</thead>
<tbody>
<tr>
<td class="tg-0lax">08 August 20</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">01 January 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">01 January 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">01 January 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">01 January 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">01 January 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">01 January 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">01 January 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">01 January 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">01 January 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">01 January 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">01 January 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">01 January 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">0</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
<tr>
<td class="tg-0lax">02 February 21</td>
<td class="tg-0lax">1</td>
</tr>
</tbody>
</table>
The column ISCONVERDED
take [0 or 1]
: if it's converted or not.
What i would like to do is to groupe by date, for each date I will have the percent when ISCONVERTED
= '1'
and the purcent when ISCONVERTED
= '0'
, like this :
| CREATEDDATE | ISCONVERTED |
|-----------------|-------------|
| 01 January 21 | 1.000000 |
| 02 February 21 | 0.676471 |
| 02 February 21 | 0.323529 |
| 03 March 21 | 0.598909 |
| 03 March 21 | 0.401091 |
| 04 April 21 | 0.646900 |
| 04 April 21 | 0.353100 |
| 05 May 21 | 0.678363 |
| 05 May 21 | 0.321637 |
| 06 June 21 | 0.729231 |
| 06 June 21 | 0.270769 |
| 07 July 21 | 0.646586 |
| 07 July 21 | 0.353414 |
| 08 August 20 | 1.000000 |
| 08 August 21 | 0.553247 |
| 08 August 21 | 0.446753 |
| 09 September 21 | 0.597911 |
| 09 September 21 | 0.402089 |
I tried this piece of code :
df= df.groupby(['CREATEDDATE'])['ISCONVERTED'].value_counts(normalize = True)
The result shown like this :
Have you any idea, how i could resolve this ?
CodePudding user response:
Not sure what's missing from your current solution. If you just need a DataFrame, you can reset the index so that:
df= df.groupby(['CREATEDDATE'])['ISCONVERTED'].value_counts(normalize = True).rename('RATIO').reset_index()
If you'd rather have only two columns as shown in your question you just need to then remove the ISCONVERTED column:
df= df.groupby(['CREATEDDATE'])['ISCONVERTED'].value_counts(normalize = True).rename('RATIO').reset_index()
del df['ISCONVERTED']
CodePudding user response:
I can't replicate your data, but If I understand you correctly, would something along the below work?
out = df.merge(df.groupby('CREATEDDATE').agg({'ISCONVERTED': 'sum'})\
.rename({'ISCONVERTED':'conversions_per_month'},axis=1)\
.reset_index(),
how='left',on='CREATEDDATE').reset_index()
out.assign(percentage=out['ISCONVERTED'].div(out['conversions_per_month'])).fillna(0)
>>> out
index CREATEDDATE ISCONVERTED conversions_per_month percentage
0 0 Jan-21 1 1 1.0
1 1 Feb-21 1 1 1.0
2 2 Feb-21 0 1 0.0
3 3 Mar-21 1 2 0.5
4 4 Mar-21 1 2 0.5
5 5 Apr-21 0 0 0.0
6 6 Apr-21 0 0 0.0
7 7 May-21 1 1 1.0
8 8 May-21 0 1 0.0
9 9 Jun-21 1 1 1.0
10 10 Jun-21 0 1 0.0
11 11 Jul-21 0 1 0.0
12 12 Jul-21 1 1 1.0
13 13 Aug-20 1 1 1.0
14 14 Aug-21 1 2 0.5
15 15 Aug-21 1 2 0.5
16 16 Sep-21 0 0 0.0
17 17 Sep-21 0 0 0.0
CodePudding user response:
You can try to do this in that way:
df = df.groupby(['CREATEDDATE'])['ISCONVERTED'].value_counts(normalize = True).unstack(fill_value=0)
df = pd.DataFrame(df.to_records())
df = df.melt(id_vars=['CREATEDDATE']).sort_values(by='CREATEDDATE', ascending=True).reset_index(drop=True)
df = df.rename(columns={'variable':'VALUE', 'value':'PERCENTAGE'})
expected_output = df[['CREATEDDATE','PERCENTAGE']]
The output looks as you've been expected:
CREATEDDATE PERCENTAGE
0 01 January 21 0.00
1 01 January 21 1.00
2 02 February 21 1.00
3 02 February 21 0.00
4 03 March 21 0.30
5 03 March 21 0.70
6 04 April 21 1.00
7 04 April 21 0.00
8 05 May 21 1.00
9 05 May 21 0.00
10 06 June 21 0.50
11 06 June 21 0.50
12 07 July 21 1.00
13 07 July 21 0.00
14 08 August 20 1.00
15 08 August 20 0.00
16 08 August 21 0.00
17 08 August 21 1.00
18 09 September 21 0.25
19 09 September 21 0.75