You’re given a dataframe containing sales data from a grocery store chain with columns for customer ID, gender, and date of sale.

Create a new dataset with summary level information on their purchases including the columns:

<ul>
<li><code>customer_id</code></li>
<li><code>gender</code></li>
<li><code>most_recent_sale</code></li>
<li><code>order_count</code></li>
</ul>

<code>most_recent_sale</code> should display the date of the customer’s most recent purchase. <code>order_count</code> should display the total number of purchases that the customer has made.

Example:

Input:

<pre><code class="language-python"><pre tabindex="0" class="chroma"><code>import pandas as pd

customers = {
&#34;customer_id&#34; : [5156, 2982, 1011, 3854, 2982],
&#34;gender&#34; : [&#34;m&#34;, &#34;f&#34;, &#34;m&#34;, &#34;f&#34;, &#34;f&#34;], 
&#34;date of sale&#34; : [&#34;2021-01-04&#34;, &#34;2021-02-15&#34;, &#34;2021-03-01&#34;, &#34;2021-03-21&#34;, &#34;2021-04-12&#34;]
}

customer_df = pd.DataFrame(customers)
</code></pre></code></pre>

Output:

<table>
<thead>
<tr>
<th>customer_id</th>
<th>gender</th>
<th>most_recent_sale</th>
<th>order_count</th>
</tr>
</thead>

<tbody>
<tr>
<td>1011</td>
<td>m</td>
<td>2021-03-01</td>
<td>1</td>
</tr>

<tr>
<td>2982</td>
<td>f</td>
<td>2021-04-12</td>
<td>2</td>
</tr>

<tr>
<td>3854</td>
<td>f</td>
<td>2021-03-21</td>
<td>1</td>
</tr>
</tbody>
</table>

Create a new dataset with summary level information on customer purchases.

Customer Analysis

Comments