基于食物留样情况统计的食堂食品安全风险数据

基于食物留样情况统计的食堂食品安全风险指数是一个创新的量化工具，可用于评估食物留样异常操作可能对食品安全造成的风险程度。
1.食堂可以通过本数据了解当前食堂食品安全的整体风险状况，及时发现潜在的食品安全问题，指数的变化也可以实时反映食堂食品安全追溯工作的质量和稳定性，结合对异常天数和异常原因的分析，食堂可以及时做出针对性的措施。2.餐饮监管部门可以利用本数据作为监管食堂食品安全的依据之一，可通过指数的变化及时发现食品安全风险较高的食堂，提前进行干预和指导。3.食堂或和监管机构可以将本数据对外披露公开，体现本单位或本地区对食品追溯工作的重视和承诺，有利于增强用餐者的信任。4.保险公司可根据本数据提前识别目标食堂客户的投保风险，从而确定相关保险产品的定价，如食品安全责任险。5.本数据还能为食物留样机厂家对设备进行功能改进或提升提供依据。1.数据抽取和预处理：
（1）数据抽取：在自研的5G智慧食安工业物联网数字化管理平台数据库中抽取相关食堂的食物留样数据，包括日期、食堂编号、所在地区、留样数量是否满足要求、留样重量是否满足要求、留样温度是否满足要求。（2）数据预处理：对抽取的数据进行清洗，去除重复、错误或无关的信息，以便后续的分析和建模。
2.基于食物留样情况统计数据预测食堂食品安全风险数据：
（1）当日留样状态判定：若留样数量、留样重量、留样温度出现一次“否”，则判定为“异常”，反之则判定为“正常”；（2）计算近30天留样异常总天数和三种原因分别的异常天数：利用CountIf函数分别对近30日留样状态为异常的天数和近30日留样数量、重量和温度状态为异常的天数进行累加；（3）建立食堂食品安全风险评估模型：基于食物留样情况统计的食堂食品安全风险指数=近30日留样异常总天数×a+近30日留样数量异常天数×b+近30日留样重量异常天数×c+近30日留样温度异常天数×d；a~d为对应的系数，根据不同原因对食品安全追溯工作的影响程度确定，属于我司商业秘密，故不作详细列举。

The canteen food safety risk index based on food sample retention statistics is an innovative quantitative tool for evaluating the risk degree of food safety issues that may be caused by abnormal food sample retention operations.
1. Canteens can use this data to understand the overall risk status of current canteen food safety, timely detect potential food safety problems. The changes of the index can also reflect the quality and stability of the canteen's food safety traceability work in real time. Combined with the analysis of abnormal days and abnormal causes, canteens can promptly take targeted measures.
2. Food safety supervision departments can use this data as one of the basis for supervising canteen food safety. They can timely discover canteens with high food safety risks through the changes of the index, and carry out early intervention and guidance.
3. Canteens or regulatory agencies can disclose this data publicly, demonstrating the attention and commitment of their unit or region to food traceability work, which is conducive to enhancing the trust of diners.
4. Insurance companies can use this data to identify the insurance risks of target canteen customers in advance, so as to determine the pricing of relevant insurance products, such as food safety liability insurance.
5. This data can also provide a basis for food sample retention equipment manufacturers to improve or upgrade their equipment functions.
1. Data extraction and preprocessing:
(1) Data extraction: Extract food sample retention data of relevant canteens from the database of the self-developed 5G smart food safety industrial IoT digital management platform, including date, canteen number, location, whether the number of retained samples meets the requirements, whether the weight of retained samples meets the requirements, and whether the temperature of retained samples meets the requirements.
(2) Data preprocessing: Clean the extracted data to remove duplicate, incorrect or irrelevant information for subsequent analysis and modeling.
2. Prediction of canteen food safety risk data based on food sample retention statistics:
(1) Daily sample retention status judgment: If any one of the sample retention quantity, weight and temperature is "No", it is judged as "Abnormal"; otherwise, it is judged as "Normal".
(2) Calculate the total number of abnormal days in the past 30 days and the number of abnormal days for each of the three causes: Use the COUNTIF function to accumulate the number of days with abnormal sample retention status in the past 30 days and the number of days with abnormal sample retention quantity, weight and temperature in the past 30 days respectively.
(3) Establish a canteen food safety risk assessment model: The canteen food safety risk index based on food sample retention statistics = total number of abnormal days in the past 30 days × a + number of abnormal days for sample retention quantity in the past 30 days × b + number of abnormal days for sample retention weight in the past 30 days × c + number of abnormal days for sample retention temperature in the past 30 days × d. a~d are corresponding coefficients, which are determined according to the impact degree of different causes on food safety traceability work, and are trade secrets of our company, so they will not be listed in detail.

搜集汇总

数据集介绍

特点

该数据集记录了食堂食物留样的详细情况，包括留样日期、食堂编号、留样数量、重量、温度等指标，并计算食品安全风险指数，用于评估食堂食品安全风险。数据每日更新，适用于食堂自我监管、餐饮监管部门监督等多种场景。