浙江区域不同种类茶叶销售数据

通过收集线上平台茶叶销售数据，可评估在浙江区域内不同种类茶叶销售情况，并通过消费者购买不同种类的茶叶判断茶叶销售比例，实现后续在该区域内更有针对性投入线上推广流量的产品，实现区域针对性产品销售；也为茶叶种植户种植菜叶品类提供决策依据。根据购买时间，取出对应时间数据，然后通过茶叶种类进行数据透视，绿茶比例=绿茶销售量/2024年4月-6月总量，黑茶比例=黑茶销售量/2024年4月-6月总量 ，红茶比例=红茶销售量/2024年4月-6月总量，乌龙茶比例=乌龙茶销售量/2024年4月-6月总量，白茶比例=白茶销售量/2024年4月-6月总量，黄茶比例=红黄销售量/2024年4月-6月总量，计算出区域内各品类茶叶销售量占比情况。

By collecting online tea sales data, the sales performance of different tea categories in the Zhejiang region can be evaluated. By analyzing consumers' purchases of various tea types, the sales proportion of each tea category can be determined, which enables more targeted allocation of online promotional traffic for products in this region to achieve precise regional product sales. This dataset also provides decision-making basis for tea growers when selecting tea varieties to plant.

Specifically, corresponding time-based data is extracted according to purchase time, followed by data pivoting based on tea types. The sales proportion of each category is calculated as follows:
- Green tea proportion = Sales volume of green tea / Total sales volume from April to June 2024
- Dark tea proportion = Sales volume of dark tea / Total sales volume from April to June 2024
- Black tea proportion = Sales volume of black tea / Total sales volume from April to June 2024
- Oolong tea proportion = Sales volume of oolong tea / Total sales volume from April to June 2024
- White tea proportion = Sales volume of white tea / Total sales volume from April to June 2024
- Yellow tea proportion = Sales volume of yellow tea / Total sales volume from April to June 2024
Ultimately, the sales proportion of each tea category in the region is obtained.