学校周边无人零售智能货柜商品需求分析数据

通过研究以及过往经验发现，不同生活场景下人们消费的商品类型也有很大差别，比如学校周边的主要消费的商品为零食、文具等，而工厂周边的主要消费的商品为饮料、泡面等，所以不同场景下人们的商品需求是无人零售智能货柜行业的一个重要关注点。本数据对各个学校周边无人零售智能货柜的售卖情况进行分析，从消费者对不同商品类别的选择中，可以得出不同商品类别的售卖占比，体现学校场景中商品的消费需求情况，帮助充实无人零售智能货柜的企业优化不同类型商品的投放比重，指导各商家在学校场景的智能货柜上合理分配不同类型商品的优惠方式、优惠力度及新品投放方案。
1、提取了统计区间内无人零售智能货柜有商品售出的数据，包含学校、货柜编号、商品类别、售卖数量四个字段，对统计区间内的数据聚合，其中数量字段为统计区间内本货柜该商品类型的累计交易件数，对售卖数量及商品类别字段进行分析，2、同类商品售卖数量是通过SUMIFS函数对相同商品类别的售卖数量的求和；3、商品售卖总数量是通过SUM函数将数据统计范围内所有售卖数量求和；4、同类商品售卖数量占比=同类商品售卖数量/售卖总数量*100%；5、商品需求等级运用了ABC分类法，对同类商品售卖数量占比≥40%的，给予“A级”的评价，对40%＞同类商品售卖数量占比≥20%区间的，给予“B级”的评价，同类商品售卖数量占比＜20%的，给予“C级”的评价。

Based on research and practical experience, it is found that the types of goods consumed by people vary significantly across different living scenarios. For instance, the main consumer goods around schools are snacks and stationery, while those surrounding factories are primarily beverages and instant noodles. Therefore, commodity demand in different scenarios is a critical focus for the unmanned retail smart vending cabinet industry. This dataset analyzes the sales performance of unmanned retail smart vending cabinets around schools. By examining consumers' selections of different commodity categories, the sales proportion of each category can be obtained, which reflects the commodity consumption demand in school scenarios. This helps enterprises in the unmanned retail smart vending cabinet industry optimize the placement proportion of different types of goods, and guide merchants to reasonably allocate preferential measures, discount intensity and new product launch plans for smart vending cabinets in school scenarios.
1. Data of unmanned retail smart vending cabinets with successful sales within the statistical interval are extracted, including four fields: school, vending cabinet ID, commodity category and sales quantity. Data within the statistical interval are aggregated, where the quantity field refers to the cumulative number of transaction pieces of this commodity category for the specific vending cabinet within the interval. Analysis is conducted on the sales quantity and commodity category fields.
2. The sales quantity of the same commodity category is calculated by summing the sales quantities of identical commodity categories using the SUMIFS function.
3. The total sales quantity is calculated by summing all sales quantities within the statistical range using the SUM function.
4. The sales proportion of the same commodity category = (sales quantity of the same commodity category / total sales quantity) * 100%.
5. The commodity demand grade is evaluated using the ABC classification method: commodities with a sales proportion ≥ 40% are rated as "Grade A", those with a sales proportion in the interval of 20% ≤ proportion < 40% are rated as "Grade B", and commodities with a sales proportion < 20% are rated as "Grade C".

搜集汇总

背景与挑战

背景概述

该数据集包含学校周边无人零售智能货柜的商品售卖数据，涵盖商品类别、售卖数量及需求等级等信息，用于分析学校场景下的商品消费需求，帮助企业优化商品投放策略。数据规模为12131条，每月更新一次。