Sandwich Analytics: A Dataset Comprising One Year’s Weekly Sales Data Correlated with Crime, Demographics, and Weather

Data collected from a quick-serve sandwich chain over one year provide opportunity for market, sociographic, meteorologic, and other factors impacting sales. The weekly sales table contains over 140,000 rows which each represent summary statistics for the sales of an individual menu item in one store during one week of the year. The data were collected from the point-of-sale system of 19 stores. Secondary data regarding weather patterns, population, location, competition, and crime were gathered and integrated with the original data set. Version 2 includes three corrections. First, two stores had one week of data where the date did not correspond to the beginning of the week. Those dates have been corrected to be standard with the rest of the data set. Second, several entries in the weather data did not match. These have been dropped. Finally, the date formats were standardized between weather and sales data for easier connection.

本数据集采集自某快餐三明治连锁品牌为期一年的运营数据，可用于探究市场、社会人口特征、气象及其他因素对销售额的影响。周度销售数据表包含超过14万条记录，每条记录对应年度内某一周内单家门店单款菜单单品的销售汇总统计值。该数据采集自19家门店的销售点（Point-of-Sale, POS）系统。研究人员同时收集了天气模式、人口规模、门店区位、竞争环境及犯罪率等二手数据，并将其与原始数据集进行整合。V2版本包含三处修正：其一，两家门店曾存在某一周数据的日期未匹配周起始标准的问题，现已修正为与数据集其余数据一致的标准格式；其二，部分不匹配的天气数据条目已被移除；其三，统一了天气数据与销售数据的日期格式，以方便二者的关联对接。