Customer Analysis

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:

• customer_id
• gender
• most_recent_sale
• order_count

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

Example:

Input:

import pandas as pd

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

customer_df = pd.DataFrame(customers)

Output: