Extract data such as the number of transactions per capita, the amount of transactions per capita, the proportion of online transactions, and return transactions. , and carry out the required analysis.

Links:/s/1k24vpp1atzlc-qujowopna

Extraction code: 8aic method 1:

Method 2:

The top three customers who returned the most goods in 20 18 had three transactions, with a total amount of 63 1, and online returns accounted for 100%.

Step 1: select three customers with the largest total return amount in 20 18 years by grouping and aggregation, as well as their respective return amount and return times.