Crazy Monkey is a recent startup started by the $3$ friends from IIT Delhi. The company deals with apparel and trending millennium clothing and accessories.

The company wants to expand across India through an online web market and various offline stores. Still, before taking this step, they wanted to be double sure regarding the demand and the sector they should target. The company has a limited cash reserve and they want to utilize it in the best possible way.

The company has hired you as an External Data Analyst and wanted you to help them with the following questions:

You are given a dictionary that consists of various orders that were placed. Each order consists of the customer$\_$id as the key of the dictionary with the values consisting of another dictionary. For each customer, you have been provided with the details of the customer in a dictionary with the name of the customer, email, phone number, and the product ordered by the customer$($in a list with the product code$).$

Orders Dictionary

orders $=\{\text{'}$U$123\text{'}$:$\{\text{'}$name$\text{'}$:'Sumit Shukla', 'email':$\text{'}$ss@gmail.com', 'phone':$8608538199,$ 'product':$[\text{'}$p$1\text{'},\text{'}$p$2\text{'},\text{'}$p$5\text{'}]\},\text{'}$U$121\text{'}$:$\{\text{'}$name$\text{'}$:'Ajay', 'email':$\text{'}$aj@gmail.com', 'phone':$7708538199,$ 'product':$[\text{'}$p$5\text{'},\text{'}$p$2\text{'},\text{'}$p$5\text{'}]\},\text{'}$U$124\text{'}$:$\{\text{'}$name$\text{'}$:'Vijay', 'email':$\text{'}$vj@gmail.com', 'phone':$870853819,$ 'product':$[\text{'}$p$1\text{'},\text{'}$p$2\text{'},\text{'}$p$3\text{'}]\},\text{'}$U$126\text{'}$:$\{\text{'}$name$\text{'}$:'Rahul', 'email':$\text{'}$rh$\_$gmail.com', 'phone':$8607858189,$ 'product':$[\text{'}$p$1\text{'},\text{'}$p$5\text{'},\text{'}$p$5\text{'}]\},\text{'}$U$183\text{'}$:$\{\text{'}$name$\text{'}$:'Shree', 'email':'shree@gmail.com', 'phone':$8908938159,$ 'product':$[\text{'}$p$1\text{'},\text{'}$p$1\text{'},\text{'}$p$1\text{'}]\},\text{'}$U$143\text{'}$:$\{\text{'}$name$\text{'}$:'shivani', 'email':'shivani@gmail', 'phone':$855853019,$ 'product':$[\text{'}$p$5\text{'},\text{'}$p$2\text{'},\text{'}$p$5\text{'}]\},\text{'}$U$188\text{'}$:$\{\text{'}$name$\text{'}$:'vidhya', 'email':$\text{'}$vi@hotmail.com', 'phone':$6608538169,$ 'product':$[\text{'}$p$1\text{'},\text{'}$p$3\text{'},\text{'}$p$4\text{'}]\},\text{'}$U$187\text{'}$:$\{\text{'}$name$\text{'}$:'jaya', 'email':$\text{'}$jm@gmail.com', 'phone':$1111111111,$ 'product':$[\text{'}$p$3\text{'},\text{'}$p$2\text{'},\text{'}$p$5\text{'}]\},\text{'}$U$154\text{'}$:$\{\text{'}$name$\text{'}$:'ojas', 'email':$\text{'}$oj$.$com', 'phone':$8917755621,$ 'product':$[\text{'}$p$1\text{'},\text{'}$p$2\text{'},\text{'}$p$2\text{'}]\},\text{'}$U$177\text{'}$:$\{\text{'}$name$\text{'}$:'anil', 'email':$\text{'}$an@gmail.com', 'phone':$7894561230,$ 'product':$[\text{'}$p$1\text{'},\text{'}$p$2\text{'},\text{'}$p$1\text{'}]\}\}$

Per$\_$product$\_$cost Dictionary

pp $=\{\text{'}$p$1\text{'}$:$500,\text{'}$p$2\text{'}$:$150,\text{'}$p$3\text{'}$:$100,\text{'}$p$4\text{'}$:$750,\text{'}$p$5\text{'}$:$612\}$

Questions

Find the number of customers in the orders dictionary. $(3$ Marks$)$

Find the number of unique products$($product code$)$ that we ordered. $(3$ Marks$)$

Each email is defined in the following format username@hostname.com, find the customer ids for which the email address was in the wrong format. $(4$ Marks$)$

Each phone number is considered valid if it has $10$ digits. find the customer ids that have invalid phone numbers. Note: In order to skip filling up the details, some customers have used $1$ for $10$ times as their phone number. These phone numbers are also considered invalid. $(5$ Marks$)$

Which customer has provided both email and phone number as wrong? $($non$-$code$)(3$ Marks$)$

Find the count of orders for each product$\_$id$.$ Create a dictionary with the product$\_$id as the key and the number of times the product was ordered. $(2$ Marks$)$

Use the dictionary created in the last question to find the product$\_$id which was ordered the maximum number of times. $(2$ Marks$)$

You are given the per$\_$product$\_$cost dictionary with the cost of each product. Find the total revenue generated by the company. $(5$ Marks$)$

Create a dictionary with the customer$\_$id and total cost ordered by the customer. $(2$ Marks$)$

Find the customer$\_$id with the minimum order value. $(1$ Marks$)$