作业3：附件数据集.zip 10.12MB
jfzjclyzml资源文件列表:
作业3：附件数据集.zip 大约有5个文件 
作业3：附件数据集/附件1：盒马超市会员信息表.xlsx 6.5MB - 作业3：附件数据集/附件2：销售流水表.xlsx 499.01KB
- 作业3：附件数据集/附件3：会员消费明细表.xlsx 1.45MB
- 作业3：附件数据集/附件4：商品信息表.xlsx 2.18MB
- 作业3：附件数据集/附件5：数据解释说明.docx 15.2KB
<link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/base.min.css" rel="stylesheet"/><link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css" rel="stylesheet"/><link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89539603/raw.css" rel="stylesheet"/><div id="sidebar" style="display: none"><div id="outline"></div></div><div class="pf w0 h0" data-page-no="1" id="pf1"><div class="pc pc1 w0 h0"><img alt="" class="bi x0 y0 w1 h1" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89539603/bg1.jpg"/><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">附件<span class="_ _0"> </span><span class="ff2">1<span class="_"> </span></span>盒马超市的会员信息表<span class="ff2">(194761<span class="_"> </span></span>行<span class="ff2">)</span></div><div class="t m0 x1 h2 y2 ff2 fs0 fc0 sc0 ls0 ws0">kh: <span class="_"> </span><span class="ff1">会员卡号，是会员的唯一标志</span></div><div class="t m0 x1 h2 y3 ff2 fs0 fc0 sc0 ls0 ws0">csny: <span class="_"> </span><span class="ff1">会员的出生年月</span></div><div class="t m0 x1 h2 y4 ff2 fs0 fc0 sc0 ls0 ws0">xb: <span class="_"> </span><span class="ff1">性别，</span>0<span class="_"> </span><span class="ff1">表示女士，</span>1<span class="_"> </span><span class="ff1">表示男士</span></div><div class="t m0 x1 h2 y5 ff2 fs0 fc0 sc0 ls0 ws0">djsj: <span class="_"> </span><span class="ff1">会员入会登记时间</span></div><div class="t m0 x1 h2 y6 ff1 fs0 fc0 sc0 ls0 ws0">附件<span class="_ _0"> </span><span class="ff2">2<span class="_"> </span></span>近几年的销售流水表（<span class="ff2">10415<span class="_"> </span></span>行）</div><div class="t m0 x1 h2 y7 ff2 fs0 fc0 sc0 ls0 ws0">djh: <span class="_"> </span><span class="ff1">单据号</span>(<span class="ff1">相同的单据号可能不是同一笔消费产生，不是唯一标识</span>)</div><div class="t m0 x1 h2 y8 ff2 fs0 fc0 sc0 ls0 ws0">spbm: <span class="_"> </span><span class="ff1">商品编码</span></div><div class="t m0 x1 h2 y9 ff2 fs0 fc0 sc0 ls0 ws0">sj: <span class="_"> </span><span class="ff1">商品售价</span></div><div class="t m0 x1 h2 ya ff2 fs0 fc0 sc0 ls0 ws0">sl: <span class="_"> </span><span class="ff1">销售数量</span></div><div class="t m0 x1 h2 yb ff2 fs0 fc0 sc0 ls0 ws0">je: <span class="_"> </span><span class="ff1">消费金额</span></div><div class="t m0 x1 h2 yc ff2 fs0 fc0 sc0 ls0 ws0">dtime: <span class="_"> </span><span class="ff1">消费产生的时间</span></div><div class="t m0 x1 h2 yd ff2 fs0 fc0 sc0 ls0 ws0">syjh: <span class="_"> </span><span class="ff1">收银机号</span></div><div class="t m0 x1 h2 ye ff1 fs0 fc0 sc0 ls0 ws0">附件<span class="_ _0"> </span><span class="ff2">3<span class="_"> </span></span>会员消费明细表（<span class="ff2">17340<span class="_"> </span></span>行）</div><div class="t m0 x1 h2 yf ff2 fs0 fc0 sc0 ls0 ws0">kh: <span class="_"> </span><span class="ff1">会员卡号<span class="_ _1"></span>（有的卡号在附件一中找不到对应会员，<span class="_ _1"></span>是由于该会员是其他分店的会员到本</span></div><div class="t m0 x1 h2 y10 ff1 fs0 fc0 sc0 ls0 ws0">店消费，所以会员信息不在附件一中。我们只针对附件一中的会员进行管理）</div><div class="t m0 x1 h2 y11 ff2 fs0 fc0 sc0 ls0 ws0">dtime: <span class="_"> </span><span class="ff1">会员消费产生的时间</span></div><div class="t m0 x1 h2 y12 ff2 fs0 fc0 sc0 ls0 ws0">spbm: <span class="_"> </span><span class="ff1">商品编码</span></div><div class="t m0 x1 h2 y13 ff2 fs0 fc0 sc0 ls0 ws0">sl: <span class="_"> </span><span class="ff1">销售数量</span></div><div class="t m0 x1 h2 y14 ff2 fs0 fc0 sc0 ls0 ws0">sj: <span class="_"> </span><span class="ff1">商品售价</span></div><div class="t m0 x1 h2 y15 ff2 fs0 fc0 sc0 ls0 ws0">je: <span class="_"> </span><span class="ff1">消费金额</span></div><div class="t m0 x1 h2 y16 ff2 fs0 fc0 sc0 ls0 ws0">spmc: <span class="_"> </span><span class="ff1">商品名称</span></div><div class="t m0 x1 h2 y17 ff2 fs0 fc0 sc0 ls0 ws0">jf: <span class="_"> </span><span class="ff1">此次消费的会员积分</span></div><div class="t m0 x1 h2 y18 ff2 fs0 fc0 sc0 ls0 ws0">syjh: <span class="_"> </span><span class="ff1">收银机号</span></div><div class="t m0 x1 h2 y19 ff2 fs0 fc0 sc0 ls0 ws0">djh: <span class="_"> </span><span class="ff1">单据号</span>(<span class="ff1">相同的单据号可能不是同一笔消费产生</span>)</div><div class="t m0 x1 h2 y1a ff2 fs0 fc0 sc0 ls0 ws0">gzbm: <span class="_"> </span><span class="ff1">柜组编码</span></div><div class="t m0 x1 h2 y1b ff2 fs0 fc0 sc0 ls0 ws0">gzmc: <span class="_"> </span><span class="ff1">柜组名称</span></div><div class="t m0 x1 h2 y1c ff1 fs0 fc0 sc0 ls0 ws0">附件<span class="_ _0"> </span><span class="ff2">4 <span class="_"> </span></span>商品信息表（<span class="ff2">24170<span class="_"> </span></span>行）</div><div class="t m0 x1 h2 y1d ff2 fs0 fc0 sc0 ls0 ws0">spbm: <span class="_"> </span><span class="ff1">商品编码</span></div><div class="t m0 x1 h2 y1e ff2 fs0 fc0 sc0 ls0 ws0">spmc: <span class="_"> </span><span class="ff1">商品名称</span></div><div class="t m0 x1 h2 y1f ff2 fs0 fc0 sc0 ls0 ws0">splm: <span class="_"> </span><span class="ff1">商品类目</span></div><div class="t m0 x1 h2 y20 ff2 fs0 fc0 sc0 ls0 ws0">ppbm: <span class="_"> </span><span class="ff1">品牌编码</span></div><div class="t m0 x1 h2 y21 ff2 fs0 fc0 sc0 ls0 ws0">lbbm: <span class="_"> </span><span class="ff1">类别编码</span></div><div class="t m0 x1 h2 y22 ff2 fs0 fc0 sc0 ls0 ws0">jxs: <span class="_"> </span><span class="ff1">进项税</span></div><div class="t m0 x1 h2 y23 ff2 fs0 fc0 sc0 ls0 ws0">xxs: <span class="_"> </span><span class="ff1">销项税</span></div><div class="t m0 x1 h2 y24 ff2 fs0 fc0 sc0 ls0 ws0">wsjj: <span class="_"> </span><span class="ff1">无税进价</span></div><div class="t m0 x1 h2 y25 ff2 fs0 fc0 sc0 ls0 ws0">hsjj: <span class="_"> </span><span class="ff1">含税进价</span></div><div class="t m0 x1 h2 y26 ff2 fs0 fc0 sc0 ls0 ws0">sj: <span class="_"> </span><span class="ff1">售价</span></div><div class="t m0 x1 h2 y27 ff2 fs0 fc0 sc0 ls0 ws0">jlrq: <span class="_"> </span><span class="ff1">记录日期</span></div><div class="t m0 x1 h2 y28 ff2 fs0 fc0 sc0 ls0 ws0">csbm: <span class="_"> </span><span class="ff1">厂商编码</span></div><div class="t m0 x1 h2 y29 ff2 fs0 fc0 sc0 ls0 ws0">gzbm: <span class="_"> </span><span class="ff1">柜组编码</span></div></div><div class="pi" data-data='{"ctm":[1.611830,0.000000,0.000000,1.611830,0.000000,0.000000]}'></div></div> 相关资源