Customer purchase behaviour analysis for Urban Threads

Urban Threads is a rapidly growing boutique clothing retailer headquartered in the United States. Founded in $2010,$ the company has carved out a niche by catering primarily to young adults aged $18$ to $35,$ offering trendy, urban$-$style fashion that reflects the latest trends in streetwear, casual, and contemporary apparel. Urban Threads distinguishes itself from larger retail chains by focusing on a curated selection of clothing, accessories, and footwear designed to appeal to fashion$-$conscious young consumers who value individuality, quality, and affordability.

$3\mathrm{.}1$ Customer demographics and purchasing behaviour

Category: Age and gender analysis

$3\mathrm{.}1$

$\mathrm{.}1$ What is the average age of customers across different product categories $($e$.$g$.,$ Clothing, Footwear, Accessories$),$ and how does purchasing behaviour differ between male and female customers? $(5)$

Task: Calculate the average age of customers for each product category. Group the dataset by gender and compare average purchase amounts across product categories. Provide visual representations to showcase any significant differences.

$3\mathrm{.}2$

Product and sales performance

Category: Top$-$selling product categories and review impact

$3\mathrm{.}2\mathrm{.}1$

Which product categories generate the highest revenue for Urban Threads, and how do customer review ratings impact purchase amounts? Do higher$-$rated products result in higher sales? $(5)$

Task: Calculate the total revenue generated by each product category. Compare purchase amounts across products based on their review ratings $($group them as $<3\mathrm{.}0,3\mathrm{.}04\mathrm{.}0,>4\mathrm{.}0)$ and analyse whether higher$-$rated products drive more revenue.