The final dataframe will look like this:Final dataframeExploratory Data Analysis(Source)Highest number of orders and money spent on purchasesTop 5 customers with most number of ordersTop 5 customers with highest money spentIn E-Commerce world, we often want to know which customers — where they come from—place the most orders and spend the most money as they drive the sales of companies.From the results we observe that most orders are made in the UK and customers from Netherlands spend the highest amount of money in their purchases.How many orders (per month)?Number of orders for different monthsOverall, we consider that the company receives the highest number of orders in November 2011 since we do not have the full month of data for December 2011.How many orders (per day)?Number of orders for different daysSurprisingly, there are no transactions on Saturday throughout the whole period ( 1st Dec 2010–9th Dec 2011)..Reasons behind are left for discussion as the dataset and its context are limited.We also spot a trend where the number of orders received by the company tends to increases from Monday to Thursday and decrease afterward.How many orders (per hour)?Number of orders for different hoursIn terms of hours, there are no transactions after 8:00pm until the next day at 6:00am.Besides, we notice that the company receives the highest number of orders at 12:00pm..????Discover transactional patterns for each CountryTop 5 countries with most number of ordersNumber of orders in each country (with UK)Number of orders in each country (without UK)As expected, the company receives the highest number of orders in the UK (since it is a UK based company).To better discern the trend, UK is removed for clearer comparison among other countries..As a result, the TOP 5 countries (including UK) that place the highest number of orders are as below:United KingdomGermanyFranceIreland (EIRE)SpainTop 5 countries with highest money spentTotal money spent by each country (with UK)Total money spent by each country (without UK)As the company receives the highest number of orders from customers in the UK, it is natural to see that customers in the UK spend the most on their purchases.Same as before, UK is removed for clearer comparison among other countries..The TOP 5 countries (including UK) that spend the most money on purchases are as below:United KingdomNetherlandsIreland (EIRE)GermanyFranceResults from EDAThe customer with the highest number of orders comes from the United Kingdom (UK)The customer with the highest money spent on purchases comes from NetherlandsThe company receives the highest number of orders from customers in the UK (since it is a UK-based company)..Therefore, the TOP 5 countries (including UK) that place the highest number of orders are as follow → United Kingdom, Germany, France, Ireland (EIRE), SpainAs the company receives the highest number of orders from customers in the UK (since it is a UK-based company), customers in the UK spend the most on their purchases.. More details