Scenario:

CompanyBCD, a retail company, has compiled detailed data on its customers and the products they have purchased.

This data includes lists of customer names, products, product prices, and corresponding barcodes.

Notably, the barcodes are structured in a way that the starting numbers indicate different product segments.

CompanyBCD aims to use this data for customer segmentation to refine its marketing strategies and enhance customer service.

Data Overview:

Customers: A list of $20$ customer names.

Products: A list of $20$ product names.

Prices: A list of prices for each product.

Barcodes: Each product has a unique barcode.

#Please Run this cell

$$

customers $=[$

"Emma Johnson", "Liam Smith", "Olivia Williams", "Noah Brown",

"Ava Garcia", "William Jones", "Sophia Miller", "James Davis",

"Isabella Rodriguez", "Benjamin Martinez", "Mia Hernandez",

"Lucas Moore", "Amelia Jackson", "Henry Taylor", "Evelyn Lee",

"Mason Wilson", "Harper Anderson", "Ethan Young", "Ella Martin",

"Alexander White"

$]$

$$

products $=[$

"Luxury Watch", "Silicone Wristband", "Weightlifting Set", "Perfume",

"Professional Camera", "Comic Book", "Designer Handbag", "Paperback Novel",

"Gym Membership", "Skincare Set", "Gourmet Coffee Maker", "Toy Train Set",

"High$-$end Laptop", "Cotton T$-$shirt", "Fitness Bootcamp", "Wireless Earbuds",

"Yoga Mat", "Running Shoes", "Smartphone", "Sunglasses"

$]$

$$

prices $=[$

$299\mathrm{.}99,19\mathrm{.}99,499\mathrm{.}99,39\mathrm{.}99,999\mathrm{.}99,24\mathrm{.}99,249\mathrm{.}99,14\mathrm{.}99,$

$199\mathrm{.}99,49\mathrm{.}99,89\mathrm{.}99,29\mathrm{.}99,1499\mathrm{.}99,9\mathrm{.}99,299\mathrm{.}99,59\mathrm{.}99,$

$34\mathrm{.}99,79\mathrm{.}99,1299\mathrm{.}99,44\mathrm{.}99$

$]$

$$

barcodes $=[$

$"2000001","2000002","3000003","2000004",$

$"1000005","2000006","2000007","2000008",$

$"3000009","2000010","1000011","2000012",$

$"1000013","2000014","3000015","1000016",$

$"3000017","3000018","1000019","2000020"$

$]$

$$

print $("$customers:$",$ customers$)$

print$()$

print $("$products:$",$ products$)$

print$()$

print $("$prices:$",$ prices$)$

print$()$

print $("$barcodes:$",$ barcodes$)$

customers: $[\text{'}$Emma Johnson', 'Liam Smith', 'Olivia Williams', 'Noah Brown', 'Ava Garcia', 'William Jones', 'Sophia Miller', 'James Davis', 'Isabella Rodriguez', 'Benjamin Martinez', 'Mia Hernandez', 'Lucas Moore', 'Amelia Jackson', 'Henry Taylor', 'Evelyn Lee', 'Mason Wilson', 'Harper Anderson', 'Ethan Young', 'Ella Martin', 'Alexander White'$]$

products: $[\text{'}$Luxury Watch', 'Silicone Wristband', 'Weightlifting Set', 'Perfume', 'Professional Camera', 'Comic Book', 'Designer Handbag', 'Paperback Novel', 'Gym Membership', 'Skincare Set', 'Gourmet Coffee Maker', 'Toy Train Set', 'High$-$end Laptop', 'Cotton T$-$shirt', 'Fitness Bootcamp', 'Wireless Earbuds', 'Yoga Mat', 'Running Shoes', 'Smartphone', 'Sunglasses'$]$

prices: $[299\mathrm{.}99,19\mathrm{.}99,499\mathrm{.}99,39\mathrm{.}99,999\mathrm{.}99,24\mathrm{.}99,249\mathrm{.}99,14\mathrm{.}99,199\mathrm{.}99,49\mathrm{.}99,89\mathrm{.}99,29\mathrm{.}99,1499\mathrm{.}99,9\mathrm{.}99,299\mathrm{.}99,59\mathrm{.}99,34\mathrm{.}99,79\mathrm{.}99,1299\mathrm{.}99,44\mathrm{.}99]$

barcodes: $[\text{'}2000001\text{'},\text{'}2000002\text{'},\text{'}3000003\text{'},\text{'}2000004\text{'},\text{'}1000005\text{'},\text{'}2000006\text{'},\text{'}2000007\text{'},\text{'}2000008\text{'},\text{'}3000009\text{'},\text{'}2000010\text{'},\text{'}1000011\text{'},\text{'}2000012\text{'},\text{'}1000013\text{'},\text{'}2000014\text{'},\text{'}3000015\text{'},\text{'}1000016\text{'},\text{'}3000017\text{'},\text{'}3000018\text{'},\text{'}1000019\text{'},\text{'}2000020\text{'}]$

To use the lists, please run the above cell

Question$-1$

The below pseudocode analyzes the price data and categorize both products and customers into specific groups based on their price points in the following categories:

Budget: Prices under $50$ USD.

Economy: Prices between $50$ USD and $100$ USD.

Mid$-$Range: Prices between $100$ USD and $500$ USD.

Premium: Prices between $500$ USD and $1000$ USD.

Luxury: Prices over $1000$ USD.

Convert the pseudocode to a Python loop and show your Python code. Display the result as a category table, including related product names and customer names.

pseudocode for question$-1$

Initialize a counter i to $0$

For each item in the list of prices: Retrieve the product name associated with the current item from the list of products Retrieve the customer name associated with the current item from the list of customers

If the price of the item is less than $50$ USD:

Display a message indicating that it's a "Budget" purchase:

"Budget: Prices under $50$ USD $-$ Customer: $[$customer$\_$name$]-$ Product: $[$product$\_$name$]"$

ElseIf the price is between $50$ USD and $99$ USD:

Display a message indicating it's an "Economy" purchase:

"Economy: Prices between $50$ USD and $100$ USD $-$ Customer: $[$customer$\_$name$]-$ Product: $[$product$\_$name$]"$

ElseIf the price is between $100$ USD and $499$ USD:

Display a message indicating it's a "Mid$-$Range" purchase:

"Mid$-$Range: Prices between $100$ USD and $500$ USD $-$ Customer: $[$customer$\_$name$]-$ Product: $[$product$\_$name$]"$

ElseIf the price is between $500$ USD and $999$ USD:

Display a message indicating it's a "Premium" purchase:

"Premium: Prices between $500$ USD and $1000$ USD $-$ Customer: $[$customer$\_$name$]-$ Product: $[$product$\_$name$]"$

Else:

Display a message indicating it's a "Luxury" purchase:

"Luxury: Prices over $1000$ USD $-$ Customer: $[$customer$\_$name$]-$ Product: $[$product$\_$name$]"$

Increment the counter i by $1$

End For