ods_jky_trades_detail_tmp.ipynb · Demik/python文档

加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

文件

该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。

克隆/下载

ods_jky_trades_detail_tmp.ipynb 69.93 KB

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "041d624d",
   "metadata": {},
   "outputs": [],
   "source": [
    "from odps import ODPS\n",
    "o = ODPS(access_id='LTAI5tCjrfshCzPeakLYkpUT', \n",
    "         secret_access_key='tsCNcebbuAFfsJid9P9NZVInJjCkXO', \n",
    "         project='dev_dataworks', \n",
    "         end_point='https://service.odps.aliyun.com/api')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "7c4e2fcf",
   "metadata": {},
   "outputs": [],
   "source": [
    "t_config = o.get_table('ods_data_acquisition_config_info')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "0e811633",
   "metadata": {},
   "outputs": [],
   "source": [
    "corp_ids = []\n",
    "with t_config.open_reader() as rd:\n",
    "    for c in rd:\n",
    "        corp_ids.append(c.corp_id)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "cbfd4b03",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "85ef4e9f6da547aba8f454a377901f27",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "TransientProgressBar(value=0.0)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "03c47c6a1f7448978dd227731037b553",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "InstancesProgress()"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "02d46a3992fc4d2cb838c746172b2664",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "HTMLNotifier()"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "76784ea23b32430a9659fef5bf0d6cea",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "TransientProgressBar(value=0.0)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "5a19861f53e049ae9737f05daeaf4a83",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "InstancesProgress()"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "9137984c02fa47a2b0b36f138b75d1b0",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "HTMLNotifier()"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# 加载店铺、仓库数据\n",
    "# 店铺\n",
    "from odps.df import DataFrame\n",
    "shop_df = DataFrame(o.get_table('dim_store_shop'))\n",
    "shop_df_cached = shop_df.to_pandas()\n",
    "# 仓库\n",
    "warehouse_df = DataFrame(o.get_table('dim_sc_warehouse'))\n",
    "warehouse_df_cached = warehouse_df.to_pandas()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "6633ea22",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 吉客云 销售单明细表和销售单明细临时表\n",
    "t_jky_trade_detail = o.get_table('ods_jky_trade_order_detail')\n",
    "t_jky_trade_detail_tmp = o.get_table('ods_jky_trade_order_detail_tmp')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "e7e55200",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "odps.Schema {\n",
       "  goods_id                                  bigint                      # 货品id\n",
       "  trade_no                                  string                      # 订单编号\n",
       "  shop_type_code                            string                      # 销售平台编号\n",
       "  goods_no                                  string                      # 货品编号\n",
       "  goods_name                                string                      # 货品名称\n",
       "  spec_id                                   bigint                      # 规格id\n",
       "  spec_name                                 string                      # 规格名称\n",
       "  barcode                                   string                      # 条码\n",
       "  sell_count                                decimal(38,18)              # 数量\n",
       "  unit                                      string                      # 单位\n",
       "  sell_price                                decimal(38,18)              # 单价\n",
       "  sell_total                                decimal(38,18)              # 总金额\n",
       "  cost                                      decimal(38,18)              # 货品成本\n",
       "  discount_total                            decimal(38,18)              # 优惠金额\n",
       "  discount_point                            int                         # 抵扣积分\n",
       "  tax_fee                                   decimal(38,18)              # 税额\n",
       "  share_favourable_fee                      decimal(38,18)              # 分摊金额\n",
       "  estimate_weight                           decimal(38,18)              # 预估重量\n",
       "  goods_memo                                string                      # 货品备注\n",
       "  cate_name                                 string                      # 货品类别\n",
       "  brand_name                                string                      # 品牌\n",
       "  goods_tags                                string                      # 货品标签\n",
       "  is_fit                                    string                      # 组合装标记 \n",
       "  is_gift                                   string                      # 赠品标记\n",
       "  discount_fee                              decimal(38,18)              # 优惠\n",
       "  tax_rate                                  decimal(38,18)              # 税率\n",
       "  estimate_goods_volume                     decimal(38,18)              # 预估体积（单个货品）\n",
       "  is_presell                                string                      # 是否预售货品标记1是0否\n",
       "  customer_price                            decimal(38,18)              # 终端销售单价\n",
       "  customer_total                            decimal(38,18)              # 终端销售金额\n",
       "  trade_goods_no                            string                      # 交易编号\n",
       "  trade_goods_name                          string                      # 交易名称\n",
       "  trade_goods_spec                          string                      # 交易规格\n",
       "  trade_goods_unit                          string                      # 交易单位\n",
       "  source_trade_no                           string                      # 网店订单号 \n",
       "  source_subtrade_no                        string                      # 网店子订单好\n",
       "  plat_code                                 string                      # 平台代码\n",
       "  plat_goods_id                             string                      # 平台商品id\n",
       "  subtrade_id                               string                      # 商品明细id（唯一）\n",
       "  trade_id                                  bigint                      # 订单ID\n",
       "  gmt_create                                datetime                    # 创建时间\n",
       "  gmt_modified                              datetime                    # 最后修改时间\n",
       "  shop_id                                   string                      # 店铺id\n",
       "  shop_name                                 string                      # 店铺名称\n",
       "  shop_code                                 string                      # 店铺编码\n",
       "  warehouse_code                            string                      # 仓库编码\n",
       "  warehouse_name                            string                      # 仓库名称\n",
       "}\n",
       "Partitions {\n",
       "  corpid                                    string                      # 钉钉corpID\n",
       "  ds                                        string                      \n",
       "}"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "t_jky_trade_detail.schema"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "id": "b5c958d3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "odps.Schema {\n",
       "  goods_id                                  bigint                      # 货品id\n",
       "  goods_no                                  string                      # 货品编号\n",
       "  goods_name                                string                      # 货品名称\n",
       "  spec_id                                   bigint                      # 规格id\n",
       "  spec_name                                 string                      # 规格名称\n",
       "  barcode                                   string                      # 条码\n",
       "  sell_count                                decimal(38,18)              # 数量\n",
       "  unit                                      string                      # 单位\n",
       "  sell_price                                decimal(38,18)              # 单价\n",
       "  sell_total                                decimal(38,18)              # 总金额\n",
       "  cost                                      decimal(38,18)              # 货品成本\n",
       "  discount_total                            decimal(38,18)              # 优惠金额\n",
       "  discount_point                            int                         # 抵扣积分\n",
       "  tax_fee                                   decimal(38,18)              # 税额\n",
       "  share_favourable_fee                      decimal(38,18)              # 分摊金额\n",
       "  estimate_weight                           decimal(38,18)              # 预估重量\n",
       "  goods_memo                                string                      # 货品备注\n",
       "  cate_name                                 string                      # 货品类别\n",
       "  brand_name                                string                      # 品牌\n",
       "  goods_tags                                string                      # 货品标签\n",
       "  is_fit                                    string                      # 组合装标记 \n",
       "  is_gift                                   string                      # 赠品标记\n",
       "  discount_fee                              decimal(38,18)              # 优惠\n",
       "  tax_rate                                  decimal(38,18)              # 税率\n",
       "  estimate_goods_volume                     decimal(38,18)              # 预估体积（单个货品）\n",
       "  is_presell                                string                      # 是否预售货品标记1是0否\n",
       "  customer_price                            decimal(38,18)              # 终端销售单价\n",
       "  customer_total                            decimal(38,18)              # 终端销售金额\n",
       "  trade_goods_no                            string                      # 交易编号\n",
       "  trade_goods_name                          string                      # 交易名称\n",
       "  trade_goods_spec                          string                      # 交易规格\n",
       "  trade_goods_unit                          string                      # 交易单位\n",
       "  source_trade_no                           string                      # 网店订单号 \n",
       "  source_subtrade_no                        string                      # 网店子订单号\n",
       "  plat_code                                 string                      # 平台代码\n",
       "  plat_goods_id                             string                      # 平台商品id\n",
       "  sub_trade_id                              string                      # 商品明细id（唯一）\n",
       "  trade_id                                  bigint                      # 订单ID\n",
       "  trade_no                                  string                      # 订单编号\n",
       "  shop_type_code                            string                      # 销售平台编号\n",
       "  gmt_create                                datetime                    # 创建时间\n",
       "  gmt_modified                              datetime                    # 最后修改时间\n",
       "  shop_id                                   string                      # 店铺id\n",
       "  shop_no                                   string                      # 店铺编码\n",
       "  shop_name                                 string                      # 店铺名称\n",
       "  warehouse_code                            string                      # 仓库编码\n",
       "  warehouse_name                            string                      # 仓库名称\n",
       "}\n",
       "Partitions {\n",
       "  corpid                                    string                      # 钉钉corpID\n",
       "  ds                                        string                      \n",
       "}"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "t_jky_trade_detail_tmp.schema"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "id": "a65ea985",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "corpid='dingf6c7a2573e10174a35c2f4657eb6378f',ds='20210920'\n",
      "corpid='dingf6c7a2573e10174a35c2f4657eb6378f',ds='20210921'\n",
      "corpid='dingf6c7a2573e10174a35c2f4657eb6378f',ds='20210922'\n",
      "corpid='dingf6c7a2573e10174a35c2f4657eb6378f',ds='20210923'\n"
     ]
    }
   ],
   "source": [
    "for p in t_jky_trade_detail.partitions:\n",
    "    print(p)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "a766a109",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "odps.Schema {\n",
       "  id                          string          \n",
       "  sid                         string          \n",
       "  source_shop_id              int64           \n",
       "  shop_no                     string          \n",
       "  shop_name                   string          \n",
       "  address                     string          \n",
       "  contact                     string          \n",
       "  zip                         string          \n",
       "  mobile                      string          \n",
       "  telno                       string          \n",
       "  email                       string          \n",
       "  website                     string          \n",
       "  is_disabled                 int32           \n",
       "  modified                    datetime        \n",
       "  created                     datetime        \n",
       "  corp_id                     string          \n",
       "}"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shop_df.schema"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "id": "13715e5f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "当前分区:corpid=ding27403c4844e446f635c2f4657eb6378f,ds=20210920\n",
      "是否存在分区:False\n",
      "当前分区:corpid=dingf6c7a2573e10174a35c2f4657eb6378f,ds=20210920\n",
      "是否存在分区:True\n",
      "当前分区:corpid=dingf6c7a2573e10174a35c2f4657eb6378f,ds=20210920,记录数:8000\n",
      "删除当前分区:corpid=dingf6c7a2573e10174a35c2f4657eb6378f,ds=20210920\n"
     ]
    },
    {
     "ename": "AttributeError",
     "evalue": "'Record' object has no attribute 'sub_trade_id'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-85-22be695dc3c3>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m     59\u001b[0m                 \u001b[0mr2\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtrade_no\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mr1\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtrade_no\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     60\u001b[0m                 \u001b[0mr2\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtrade_id\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mr1\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtrade_id\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 61\u001b[1;33m                 \u001b[0mr2\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0msub_trade_id\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mr1\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0msub_trade_id\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     62\u001b[0m                 \u001b[0mr2\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mgmt_create\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mr1\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mgmt_create\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     63\u001b[0m                 \u001b[0mr2\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mgmt_modified\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mr1\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mgmt_modified\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\Anaconda3\\lib\\site-packages\\odps\\types.py\u001b[0m in \u001b[0;36m__getattr__\u001b[1;34m(self, item)\u001b[0m\n\u001b[0;32m    452\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mhasattr\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'_name_indexes'\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mand\u001b[0m \u001b[0mitem\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_name_indexes\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    453\u001b[0m             \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_by_name\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 454\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mobject\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m__getattribute__\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mitem\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    455\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    456\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0m__setattr__\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mAttributeError\u001b[0m: 'Record' object has no attribute 'sub_trade_id'"
     ]
    }
   ],
   "source": [
    "ds = '20210920'\n",
    "for c_id in corp_ids:\n",
    "    pt = 'corpid='+c_id+',ds='+ds\n",
    "    print('当前分区:%s' % pt)\n",
    "\n",
    "    exist_pt = t_jky_trade_detail.exist_partition(pt)\n",
    "    print('是否存在分区:%s' % exist_pt)\n",
    "\n",
    "    if exist_pt:\n",
    "        with t_jky_trade_detail.open_reader(partition=pt) as reader:\n",
    "            print('当前分区:%s,记录数:%s' % (pt,reader.count))\n",
    "            # 临时表如果存在当前分区,先删除分区，再创建新分区,达到数据覆写的目的\n",
    "            t_jky_trade_detail_tmp.delete_partition(pt,if_exists=True)\n",
    "            print('删除当前分区:%s' % pt)\n",
    "            \n",
    "            tmp_list = []\n",
    "            total_count = 0\n",
    "\n",
    "            for r1 in reader:\n",
    "                r2 = t_jky_trade_detail_tmp.new_record()\n",
    "                \n",
    "                r2.goods_id = r1.goods_id\n",
    "                r2.goods_no = r1.goods_no                          \n",
    "                r2.goods_name = r1.goods_name                         \n",
    "                r2.spec_id = r1.spec_id                             \n",
    "                r2.spec_name = r1.spec_name                           \n",
    "                r2.barcode = r1.barcode                             \n",
    "                r2.sell_count = r1.sell_count                          \n",
    "                r2.unit = r1.unit                               \n",
    "                r2.sell_price = r1.sell_price                          \n",
    "                r2.sell_total = r1.sell_total                          \n",
    "                r2.cost = r1.cost                               \n",
    "                r2.discount_total = r1.discount_total                       \n",
    "                r2.discount_point = r1.discount_point                     \n",
    "                r2.tax_fee = r1.tax_fee                            \n",
    "                r2.share_favourable_fee = r1.share_favourable_fee                 \n",
    "                r2.estimate_weight = r1.estimate_weight                    \n",
    "                r2.goods_memo = r1.goods_memo                          \n",
    "                r2.cate_name = r1.cate_name                           \n",
    "                r2.brand_name = r1.brand_name                           \n",
    "                r2.goods_tags = r1.goods_tags                          \n",
    "                r2.is_fit = r1.is_fit                              \n",
    "                r2.is_gift = r1.is_gift                             \n",
    "                r2.discount_fee = r1.discount_fee                        \n",
    "                r2.tax_rate = r1.tax_rate                             \n",
    "                r2.estimate_goods_volume = r1.estimate_goods_volume                \n",
    "                r2.is_presell = r1.is_presell                          \n",
    "                r2.customer_price = r1.customer_price                      \n",
    "                r2.customer_total = r1.customer_total                      \n",
    "                r2.trade_goods_no = r1.trade_goods_no                       \n",
    "                r2.trade_goods_name = r1.trade_goods_name                     \n",
    "                r2.trade_goods_spec = r1.trade_goods_spec                     \n",
    "                r2.trade_goods_unit = r1.trade_goods_unit                    \n",
    "                r2.source_trade_no = r1.source_trade_no                      \n",
    "                r2.source_subtrade_no = r1.source_subtrade_no                  \n",
    "                r2.plat_code = r1.plat_code                         \n",
    "                r2.plat_goods_id = r1.plat_goods_id                       \n",
    "                r2.subtrade_id = r1.subtrade_id    \n",
    "                r2.trade_no = r1.trade_no\n",
    "                r2.trade_id = r1.trade_id  \n",
    "                r2.sub_trade_id = r1.sub_trade_id\n",
    "                r2.gmt_create = r1.gmt_create                          \n",
    "                r2.gmt_modified = r1.gmt_modified  \n",
    "                r2.shop_type_code = r1.shop_type_code\n",
    "                r2.shop_id = r1.shop_id                           \n",
    "                r2.shop_no = r1.shop_code\n",
    "                r2.shop_name = r1.shop_name                         \n",
    "                r2.warehouse_code = r1.warehouse_code                      \n",
    "                r2.warehouse_name = r1.warehouse_name                                        \n",
    "                \n",
    "#                 print(r1)\n",
    "                print('-----------------')\n",
    "                \n",
    "                print(r2)\n",
    "                break            \n",
    "                \n",
    "                \n",
    "                # 数据添加到集合中\n",
    "                tmp_list.append(r2)\n",
    "                total_count += 1\n",
    "\n",
    "                 # 集合元素大于指定数或遍历结束时，就写入:每5000条数据就写入\n",
    "                result = total_count==reader.count or len(tmp_list)==5000 \n",
    "\n",
    "                # 集合元素大于指定数，就写入:每5000条数据就写入\n",
    "                if result:\n",
    "                    with t_jky_trade_detail_tmp.open_writer(partition=pt,create_partition=True) as writer:\n",
    "                        writer.write(tmp_list)\n",
    "                        print('写入数据数:%s' % len(tmp_list))\n",
    "                        tmp_list = []\n",
    "                \n",
    "            print('执行完毕')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "92c28279",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>sid</th>\n",
       "      <th>source_warehouse_id</th>\n",
       "      <th>warehouse_no</th>\n",
       "      <th>warehouse_name</th>\n",
       "      <th>warehouse_type</th>\n",
       "      <th>warehouse_type_name</th>\n",
       "      <th>address</th>\n",
       "      <th>contact</th>\n",
       "      <th>telno</th>\n",
       "      <th>mobile</th>\n",
       "      <th>is_disabled</th>\n",
       "      <th>created</th>\n",
       "      <th>modified</th>\n",
       "      <th>corp_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b38c2e7d-fa89-4d8c-b075-c42242bd9886</td>\n",
       "      <td>aole2</td>\n",
       "      <td>110</td>\n",
       "      <td>001</td>\n",
       "      <td>云山快仓--合肥仓</td>\n",
       "      <td>20</td>\n",
       "      <td>外部链路型</td>\n",
       "      <td>合肥市锦绣大道5092号3楼</td>\n",
       "      <td>王明亮</td>\n",
       "      <td>17891918818</td>\n",
       "      <td>17891918818</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-12-28 10:02:04</td>\n",
       "      <td>2020-12-28 10:02:04</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9cd3998c-8018-4578-a0d2-fc18c68971b8</td>\n",
       "      <td>None</td>\n",
       "      <td>1171017489393058944</td>\n",
       "      <td>YC100</td>\n",
       "      <td>京东云交易虚拟仓</td>\n",
       "      <td>2</td>\n",
       "      <td>委外托管</td>\n",
       "      <td>宏鼎云璟汇</td>\n",
       "      <td>得成</td>\n",
       "      <td>15914483322</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>dbda25c4-30ac-41c1-a058-d50ebdf6a609</td>\n",
       "      <td>aole2</td>\n",
       "      <td>5</td>\n",
       "      <td>Y01</td>\n",
       "      <td>云山快仓--广州花都</td>\n",
       "      <td>11</td>\n",
       "      <td>奇门仓储</td>\n",
       "      <td>广州市花都区宏发路1号（云仓仓储）</td>\n",
       "      <td>梁晓杭</td>\n",
       "      <td>13416192275</td>\n",
       "      <td>13416192275</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-06-13 10:50:52</td>\n",
       "      <td>2021-02-02 13:45:52</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4e0b6de8-8e40-4e73-b30a-76fe91df5e97</td>\n",
       "      <td>None</td>\n",
       "      <td>1163024700422258944</td>\n",
       "      <td>YC008</td>\n",
       "      <td>合肥JITX云仓(固)</td>\n",
       "      <td>2</td>\n",
       "      <td>委外托管</td>\n",
       "      <td>锦绣大道5092号</td>\n",
       "      <td>得成</td>\n",
       "      <td>15914483322</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>57036bc9-275d-4d70-9b05-626a79797900</td>\n",
       "      <td>aole2</td>\n",
       "      <td>9</td>\n",
       "      <td>06</td>\n",
       "      <td>代发仓</td>\n",
       "      <td>1</td>\n",
       "      <td>普通仓库</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2016-07-08 15:53:08</td>\n",
       "      <td>2017-08-03 09:01:34</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>8ce96f37-b658-4454-a8a2-65af2c787851</td>\n",
       "      <td>None</td>\n",
       "      <td>1160660421956600064</td>\n",
       "      <td>ZY005</td>\n",
       "      <td>东蓓工厂仓(固)</td>\n",
       "      <td>1</td>\n",
       "      <td>自建自用</td>\n",
       "      <td>东成路128号之二</td>\n",
       "      <td>贾召全</td>\n",
       "      <td>15914638528</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>81433f21-d13b-417e-bfde-5fda66f24c79</td>\n",
       "      <td>aole2</td>\n",
       "      <td>116</td>\n",
       "      <td>YSHN-19</td>\n",
       "      <td>云山快仓--花都（艺晟）</td>\n",
       "      <td>20</td>\n",
       "      <td>外部链路型</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2021-01-07 15:42:36</td>\n",
       "      <td>2021-01-07 16:34:41</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>e4565e08-4836-4961-aa9f-84e5d1b90663</td>\n",
       "      <td>None</td>\n",
       "      <td>1160873149716497280</td>\n",
       "      <td>T001</td>\n",
       "      <td>停用仓库</td>\n",
       "      <td>1</td>\n",
       "      <td>自建自用</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>f2449026-4dee-464d-8c93-89d43c00eb73</td>\n",
       "      <td>aole2</td>\n",
       "      <td>117</td>\n",
       "      <td>YZXNC001</td>\n",
       "      <td>有赞虚拟仓</td>\n",
       "      <td>1</td>\n",
       "      <td>普通仓库</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2021-01-12 11:09:30</td>\n",
       "      <td>2021-01-12 11:09:30</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>95d890b6-c35d-425b-9dd3-abca22f15449</td>\n",
       "      <td>None</td>\n",
       "      <td>1184816864298173696</td>\n",
       "      <td>YC200</td>\n",
       "      <td>云交易抖音虚拟仓</td>\n",
       "      <td>2</td>\n",
       "      <td>委外托管</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>c18ec925-5877-473f-b6b4-b3d3518dac06</td>\n",
       "      <td>aole2</td>\n",
       "      <td>118</td>\n",
       "      <td>TMXNC01</td>\n",
       "      <td>天猫虚拟仓</td>\n",
       "      <td>1</td>\n",
       "      <td>普通仓库</td>\n",
       "      <td></td>\n",
       "      <td>苏剑勇</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2021-01-21 09:56:47</td>\n",
       "      <td>2021-01-21 09:56:47</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5aec5499-b20e-4eaf-ad16-5675d06fc302</td>\n",
       "      <td>None</td>\n",
       "      <td>1189819543943414400</td>\n",
       "      <td>CP-145</td>\n",
       "      <td>宁波芬德家居用品有限公司</td>\n",
       "      <td>3</td>\n",
       "      <td>供应商虚拟仓</td>\n",
       "      <td>西园路10号A211室</td>\n",
       "      <td>刘军</td>\n",
       "      <td>18958307567</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>68aac285-873d-40c1-8bf8-bb698e0d1a5e</td>\n",
       "      <td>aole2</td>\n",
       "      <td>77</td>\n",
       "      <td>JDC</td>\n",
       "      <td>京东仓POP</td>\n",
       "      <td>1</td>\n",
       "      <td>普通仓库</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2018-09-19 16:41:48</td>\n",
       "      <td>2020-09-07 09:34:27</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>f2ab5f93-8913-4ab9-a3cd-cc55bb482437</td>\n",
       "      <td>None</td>\n",
       "      <td>1143266390452241024</td>\n",
       "      <td>YC004</td>\n",
       "      <td>中山JITX云仓(固)</td>\n",
       "      <td>2</td>\n",
       "      <td>委外托管</td>\n",
       "      <td>东成路1号</td>\n",
       "      <td>得成</td>\n",
       "      <td>15914483322</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>6b4f9226-8624-4423-9204-367d6916d392</td>\n",
       "      <td>aole2</td>\n",
       "      <td>79</td>\n",
       "      <td>JDZY</td>\n",
       "      <td>京东自营仓</td>\n",
       "      <td>1</td>\n",
       "      <td>普通仓库</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2018-09-20 13:30:37</td>\n",
       "      <td>2020-09-07 09:34:27</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>40015f9c-454a-40a2-af1a-2809309f8eae</td>\n",
       "      <td>None</td>\n",
       "      <td>1144218602545185408</td>\n",
       "      <td>YC006</td>\n",
       "      <td>花都艺晟云仓</td>\n",
       "      <td>2</td>\n",
       "      <td>委外托管</td>\n",
       "      <td>宏发路1号十一号仓收货一部</td>\n",
       "      <td>梁晓杭</td>\n",
       "      <td>13416192275</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>a19a9a51-8b10-410f-b6b4-174252bad18a</td>\n",
       "      <td>aole2</td>\n",
       "      <td>80</td>\n",
       "      <td>KLZY</td>\n",
       "      <td>考拉自营</td>\n",
       "      <td>1</td>\n",
       "      <td>普通仓库</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2018-12-28 16:32:20</td>\n",
       "      <td>2020-09-07 09:34:27</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>af7bc36e-100e-4972-ab67-6381698bcea1</td>\n",
       "      <td>None</td>\n",
       "      <td>1133231872668402176</td>\n",
       "      <td>YC002</td>\n",
       "      <td>花都云山快仓</td>\n",
       "      <td>2</td>\n",
       "      <td>委外托管</td>\n",
       "      <td>宏发路1号</td>\n",
       "      <td>梁晓杭</td>\n",
       "      <td>13416192275</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>a3e2a6e8-4263-41cd-a0b2-e45201cfc5c1</td>\n",
       "      <td>aole2</td>\n",
       "      <td>85</td>\n",
       "      <td>YSAH</td>\n",
       "      <td>云山快仓--安徽仓</td>\n",
       "      <td>11</td>\n",
       "      <td>奇门仓储</td>\n",
       "      <td>安徽省亳州市蒙城县宇兴华东仓</td>\n",
       "      <td>王军旗</td>\n",
       "      <td>17368808728</td>\n",
       "      <td>17368808728</td>\n",
       "      <td>0</td>\n",
       "      <td>2019-09-17 15:28:18</td>\n",
       "      <td>2021-02-02 13:45:52</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>653e87ab-21bc-4be1-ac1d-b606c295524b</td>\n",
       "      <td>None</td>\n",
       "      <td>1135466798305771904</td>\n",
       "      <td>YC003</td>\n",
       "      <td>合肥云山快仓</td>\n",
       "      <td>2</td>\n",
       "      <td>委外托管</td>\n",
       "      <td>锦绣大道5092号</td>\n",
       "      <td>程宝安</td>\n",
       "      <td>18255133250</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>f81004bf-bd82-4240-b2b3-d79d3ec89eaf</td>\n",
       "      <td>aole2</td>\n",
       "      <td>102</td>\n",
       "      <td>TMCS</td>\n",
       "      <td>天猫超市</td>\n",
       "      <td>1</td>\n",
       "      <td>普通仓库</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2020-04-25 14:30:30</td>\n",
       "      <td>2021-02-02 13:45:52</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>d4321744-1999-4dc8-bc2c-6775bf9d7492</td>\n",
       "      <td>aole2</td>\n",
       "      <td>104</td>\n",
       "      <td>WPH-JITX</td>\n",
       "      <td>唯品会JITX仓</td>\n",
       "      <td>20</td>\n",
       "      <td>外部链路型</td>\n",
       "      <td>广东省中山市东升镇东成路128号</td>\n",
       "      <td>董意</td>\n",
       "      <td>18680157531</td>\n",
       "      <td>18680157531</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-05-08 11:18:52</td>\n",
       "      <td>2021-02-02 13:45:52</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2207ccb8-d876-4ad5-9952-dd20522bac27</td>\n",
       "      <td>aole2</td>\n",
       "      <td>105</td>\n",
       "      <td>ATJDZY</td>\n",
       "      <td>奥童京东自营仓</td>\n",
       "      <td>1</td>\n",
       "      <td>普通仓库</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2020-05-08 18:05:01</td>\n",
       "      <td>2021-02-02 13:45:52</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>cd3db647-9b1f-4b5f-b273-bbf4ca0c95d4</td>\n",
       "      <td>aole2</td>\n",
       "      <td>108</td>\n",
       "      <td>Y01CC</td>\n",
       "      <td>花都售后仓</td>\n",
       "      <td>11</td>\n",
       "      <td>奇门仓储</td>\n",
       "      <td>广州市花都区宏发路1号（云仓仓储）</td>\n",
       "      <td>梁晓杭</td>\n",
       "      <td>13416192275</td>\n",
       "      <td>13416192275</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-09-14 15:37:53</td>\n",
       "      <td>2021-02-02 13:45:52</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>bb17e48c-30cb-4a76-b6c1-d6837dd4f5d9</td>\n",
       "      <td>aole2</td>\n",
       "      <td>63</td>\n",
       "      <td>ZSSH</td>\n",
       "      <td>中山售后仓</td>\n",
       "      <td>11</td>\n",
       "      <td>奇门仓储</td>\n",
       "      <td>中山市 东升镇 东成路 128号   4楼</td>\n",
       "      <td>张扬超</td>\n",
       "      <td>18022325962</td>\n",
       "      <td>18022325962</td>\n",
       "      <td>0</td>\n",
       "      <td>2018-05-14 09:36:00</td>\n",
       "      <td>2021-03-22 16:12:06</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>93579552-4684-4210-9c11-f50695d23345</td>\n",
       "      <td>aole2</td>\n",
       "      <td>89</td>\n",
       "      <td>SNZY</td>\n",
       "      <td>苏宁自营仓</td>\n",
       "      <td>1</td>\n",
       "      <td>普通仓库</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2019-12-09 09:54:21</td>\n",
       "      <td>2021-02-02 13:45:52</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>d3ba9dd2-057e-470d-ba5e-9726d42ba8db</td>\n",
       "      <td>None</td>\n",
       "      <td>1154880900413818112</td>\n",
       "      <td>ZY004</td>\n",
       "      <td>供应商虚拟仓(固)</td>\n",
       "      <td>1</td>\n",
       "      <td>自建自用</td>\n",
       "      <td>宏鼎云璟汇</td>\n",
       "      <td>黄铭润</td>\n",
       "      <td>19925675949</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>056ac633-1dac-4a62-b166-53fba7cc8560</td>\n",
       "      <td>aole2</td>\n",
       "      <td>122</td>\n",
       "      <td>002</td>\n",
       "      <td>云山快仓--合肥仓次品库</td>\n",
       "      <td>20</td>\n",
       "      <td>外部链路型</td>\n",
       "      <td>合肥市锦绣大道5092号3楼</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2021-02-25 14:30:18</td>\n",
       "      <td>2021-02-25 14:30:52</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>cf4a1e4c-a51e-4bcc-b008-7e13e5f3eab6</td>\n",
       "      <td>None</td>\n",
       "      <td>1140472018611896576</td>\n",
       "      <td>ZY001</td>\n",
       "      <td>星逸中山售后仓</td>\n",
       "      <td>1</td>\n",
       "      <td>自建自用</td>\n",
       "      <td>105国道</td>\n",
       "      <td>得成</td>\n",
       "      <td>15914483322</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>06f04fe9-74f1-432a-8b19-38873bd83fdd</td>\n",
       "      <td>aole2</td>\n",
       "      <td>125</td>\n",
       "      <td>YHSY</td>\n",
       "      <td>益海塑业</td>\n",
       "      <td>1</td>\n",
       "      <td>普通仓库</td>\n",
       "      <td></td>\n",
       "      <td>闫璞</td>\n",
       "      <td></td>\n",
       "      <td>17753920160</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-03-13 17:53:57</td>\n",
       "      <td>2021-03-17 13:51:41</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>6026d1c5-00f0-49f5-8239-55f6da7620f6</td>\n",
       "      <td>None</td>\n",
       "      <td>1140502621067116928</td>\n",
       "      <td>ZY002</td>\n",
       "      <td>京东虚拟自营仓</td>\n",
       "      <td>1</td>\n",
       "      <td>自建自用</td>\n",
       "      <td>宏鼎云璟汇</td>\n",
       "      <td>得成</td>\n",
       "      <td>15914483322</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>a2294850-d720-444e-ac09-fdc0b06c3ad1</td>\n",
       "      <td>aole2</td>\n",
       "      <td>78</td>\n",
       "      <td>WPHC</td>\n",
       "      <td>唯品会仓</td>\n",
       "      <td>1</td>\n",
       "      <td>普通仓库</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2018-09-19 16:42:09</td>\n",
       "      <td>2020-09-07 09:34:27</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1f4389a9-f1c2-46ef-a664-db6f0895f4ad</td>\n",
       "      <td>None</td>\n",
       "      <td>1144218155897946752</td>\n",
       "      <td>YC005</td>\n",
       "      <td>花都源美云仓</td>\n",
       "      <td>2</td>\n",
       "      <td>委外托管</td>\n",
       "      <td>宏发路1号十一号仓收货一部</td>\n",
       "      <td>梁晓杭</td>\n",
       "      <td>13416192275</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>6f9f0b08-968d-4f50-99c9-1d707d545342</td>\n",
       "      <td>aole2</td>\n",
       "      <td>82</td>\n",
       "      <td>ZSZH</td>\n",
       "      <td>中山综合仓</td>\n",
       "      <td>11</td>\n",
       "      <td>奇门仓储</td>\n",
       "      <td>广东省中山市东升镇东成路128号</td>\n",
       "      <td>董意</td>\n",
       "      <td>18680157531</td>\n",
       "      <td>18680157531</td>\n",
       "      <td>0</td>\n",
       "      <td>2019-06-12 11:17:59</td>\n",
       "      <td>2021-02-02 13:45:52</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>e065b7b4-ed0c-4a5b-a614-0665c48d05b4</td>\n",
       "      <td>None</td>\n",
       "      <td>1133904560725951744</td>\n",
       "      <td>YC001</td>\n",
       "      <td>中山综合云仓</td>\n",
       "      <td>2</td>\n",
       "      <td>委外托管</td>\n",
       "      <td>东成路128号</td>\n",
       "      <td>董意</td>\n",
       "      <td>18680157531</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>ced6ec57-2f74-4f29-a834-96baeb13dae8</td>\n",
       "      <td>aole2</td>\n",
       "      <td>86</td>\n",
       "      <td>YSHD</td>\n",
       "      <td>云山快仓--花都（源美）</td>\n",
       "      <td>11</td>\n",
       "      <td>奇门仓储</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2019-10-18 12:45:51</td>\n",
       "      <td>2021-02-02 13:45:52</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>61a0f3dd-353b-4c51-a85c-64b3f1d1ecf6</td>\n",
       "      <td>None</td>\n",
       "      <td>1137473719684007168</td>\n",
       "      <td>ZY003</td>\n",
       "      <td>京东虚拟玩具POP仓</td>\n",
       "      <td>1</td>\n",
       "      <td>自建自用</td>\n",
       "      <td>宏鼎云璟汇</td>\n",
       "      <td>得成</td>\n",
       "      <td>15914483322</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>3888190e-b29e-48d5-a458-011c822aa982</td>\n",
       "      <td>aole2</td>\n",
       "      <td>88</td>\n",
       "      <td>W03</td>\n",
       "      <td>安徽仓-次品仓</td>\n",
       "      <td>11</td>\n",
       "      <td>奇门仓储</td>\n",
       "      <td>安徽省亳州市蒙城县宇兴华东仓</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2019-11-06 17:37:37</td>\n",
       "      <td>2021-02-02 13:45:52</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>ab7644c6-14a9-45ea-8e61-c5d8f290d51f</td>\n",
       "      <td>aole2</td>\n",
       "      <td>106</td>\n",
       "      <td>SHZYC</td>\n",
       "      <td>售后专用仓</td>\n",
       "      <td>1</td>\n",
       "      <td>普通仓库</td>\n",
       "      <td>中山市 东升镇 东成路 128号   4楼</td>\n",
       "      <td>张扬超</td>\n",
       "      <td>18022325962</td>\n",
       "      <td>18022325962</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-07-22 19:01:56</td>\n",
       "      <td>2021-02-02 13:45:52</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>ce9f0acc-11cc-4f29-ae80-1b15f715404f</td>\n",
       "      <td>aole2</td>\n",
       "      <td>109</td>\n",
       "      <td>DBC</td>\n",
       "      <td>东蓓库</td>\n",
       "      <td>1</td>\n",
       "      <td>普通仓库</td>\n",
       "      <td>东升镇文献路15号仓库部</td>\n",
       "      <td>黄仙珍</td>\n",
       "      <td></td>\n",
       "      <td>19928025756</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-10-23 18:01:04</td>\n",
       "      <td>2020-10-23 18:01:04</td>\n",
       "      <td>dingf6c7a2573e10174a35c2f4657eb6378f</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      id    sid  source_warehouse_id  \\\n",
       "0   b38c2e7d-fa89-4d8c-b075-c42242bd9886  aole2                  110   \n",
       "1   9cd3998c-8018-4578-a0d2-fc18c68971b8   None  1171017489393058944   \n",
       "2   dbda25c4-30ac-41c1-a058-d50ebdf6a609  aole2                    5   \n",
       "3   4e0b6de8-8e40-4e73-b30a-76fe91df5e97   None  1163024700422258944   \n",
       "4   57036bc9-275d-4d70-9b05-626a79797900  aole2                    9   \n",
       "5   8ce96f37-b658-4454-a8a2-65af2c787851   None  1160660421956600064   \n",
       "6   81433f21-d13b-417e-bfde-5fda66f24c79  aole2                  116   \n",
       "7   e4565e08-4836-4961-aa9f-84e5d1b90663   None  1160873149716497280   \n",
       "8   f2449026-4dee-464d-8c93-89d43c00eb73  aole2                  117   \n",
       "9   95d890b6-c35d-425b-9dd3-abca22f15449   None  1184816864298173696   \n",
       "10  c18ec925-5877-473f-b6b4-b3d3518dac06  aole2                  118   \n",
       "11  5aec5499-b20e-4eaf-ad16-5675d06fc302   None  1189819543943414400   \n",
       "12  68aac285-873d-40c1-8bf8-bb698e0d1a5e  aole2                   77   \n",
       "13  f2ab5f93-8913-4ab9-a3cd-cc55bb482437   None  1143266390452241024   \n",
       "14  6b4f9226-8624-4423-9204-367d6916d392  aole2                   79   \n",
       "15  40015f9c-454a-40a2-af1a-2809309f8eae   None  1144218602545185408   \n",
       "16  a19a9a51-8b10-410f-b6b4-174252bad18a  aole2                   80   \n",
       "17  af7bc36e-100e-4972-ab67-6381698bcea1   None  1133231872668402176   \n",
       "18  a3e2a6e8-4263-41cd-a0b2-e45201cfc5c1  aole2                   85   \n",
       "19  653e87ab-21bc-4be1-ac1d-b606c295524b   None  1135466798305771904   \n",
       "20  f81004bf-bd82-4240-b2b3-d79d3ec89eaf  aole2                  102   \n",
       "21  d4321744-1999-4dc8-bc2c-6775bf9d7492  aole2                  104   \n",
       "22  2207ccb8-d876-4ad5-9952-dd20522bac27  aole2                  105   \n",
       "23  cd3db647-9b1f-4b5f-b273-bbf4ca0c95d4  aole2                  108   \n",
       "24  bb17e48c-30cb-4a76-b6c1-d6837dd4f5d9  aole2                   63   \n",
       "25  93579552-4684-4210-9c11-f50695d23345  aole2                   89   \n",
       "26  d3ba9dd2-057e-470d-ba5e-9726d42ba8db   None  1154880900413818112   \n",
       "27  056ac633-1dac-4a62-b166-53fba7cc8560  aole2                  122   \n",
       "28  cf4a1e4c-a51e-4bcc-b008-7e13e5f3eab6   None  1140472018611896576   \n",
       "29  06f04fe9-74f1-432a-8b19-38873bd83fdd  aole2                  125   \n",
       "30  6026d1c5-00f0-49f5-8239-55f6da7620f6   None  1140502621067116928   \n",
       "31  a2294850-d720-444e-ac09-fdc0b06c3ad1  aole2                   78   \n",
       "32  1f4389a9-f1c2-46ef-a664-db6f0895f4ad   None  1144218155897946752   \n",
       "33  6f9f0b08-968d-4f50-99c9-1d707d545342  aole2                   82   \n",
       "34  e065b7b4-ed0c-4a5b-a614-0665c48d05b4   None  1133904560725951744   \n",
       "35  ced6ec57-2f74-4f29-a834-96baeb13dae8  aole2                   86   \n",
       "36  61a0f3dd-353b-4c51-a85c-64b3f1d1ecf6   None  1137473719684007168   \n",
       "37  3888190e-b29e-48d5-a458-011c822aa982  aole2                   88   \n",
       "38  ab7644c6-14a9-45ea-8e61-c5d8f290d51f  aole2                  106   \n",
       "39  ce9f0acc-11cc-4f29-ae80-1b15f715404f  aole2                  109   \n",
       "\n",
       "   warehouse_no warehouse_name  warehouse_type warehouse_type_name  \\\n",
       "0           001      云山快仓--合肥仓              20               外部链路型   \n",
       "1         YC100       京东云交易虚拟仓               2                委外托管   \n",
       "2           Y01     云山快仓--广州花都              11                奇门仓储   \n",
       "3         YC008    合肥JITX云仓(固)               2                委外托管   \n",
       "4            06            代发仓               1                普通仓库   \n",
       "5         ZY005       东蓓工厂仓(固)               1                自建自用   \n",
       "6       YSHN-19   云山快仓--花都（艺晟）              20               外部链路型   \n",
       "7          T001           停用仓库               1                自建自用   \n",
       "8      YZXNC001          有赞虚拟仓               1                普通仓库   \n",
       "9         YC200       云交易抖音虚拟仓               2                委外托管   \n",
       "10      TMXNC01          天猫虚拟仓               1                普通仓库   \n",
       "11       CP-145   宁波芬德家居用品有限公司               3              供应商虚拟仓   \n",
       "12          JDC         京东仓POP               1                普通仓库   \n",
       "13        YC004    中山JITX云仓(固)               2                委外托管   \n",
       "14         JDZY          京东自营仓               1                普通仓库   \n",
       "15        YC006         花都艺晟云仓               2                委外托管   \n",
       "16         KLZY           考拉自营               1                普通仓库   \n",
       "17        YC002         花都云山快仓               2                委外托管   \n",
       "18         YSAH      云山快仓--安徽仓              11                奇门仓储   \n",
       "19        YC003         合肥云山快仓               2                委外托管   \n",
       "20         TMCS          天猫超市                1                普通仓库   \n",
       "21     WPH-JITX       唯品会JITX仓              20               外部链路型   \n",
       "22       ATJDZY        奥童京东自营仓               1                普通仓库   \n",
       "23        Y01CC          花都售后仓              11                奇门仓储   \n",
       "24         ZSSH          中山售后仓              11                奇门仓储   \n",
       "25         SNZY          苏宁自营仓               1                普通仓库   \n",
       "26        ZY004      供应商虚拟仓(固)               1                自建自用   \n",
       "27          002   云山快仓--合肥仓次品库              20               外部链路型   \n",
       "28        ZY001        星逸中山售后仓               1                自建自用   \n",
       "29         YHSY           益海塑业               1                普通仓库   \n",
       "30        ZY002        京东虚拟自营仓               1                自建自用   \n",
       "31         WPHC           唯品会仓               1                普通仓库   \n",
       "32        YC005         花都源美云仓               2                委外托管   \n",
       "33         ZSZH          中山综合仓              11                奇门仓储   \n",
       "34        YC001         中山综合云仓               2                委外托管   \n",
       "35         YSHD   云山快仓--花都（源美）              11                奇门仓储   \n",
       "36        ZY003     京东虚拟玩具POP仓               1                自建自用   \n",
       "37          W03        安徽仓-次品仓              11                奇门仓储   \n",
       "38        SHZYC          售后专用仓               1                普通仓库   \n",
       "39          DBC            东蓓库               1                普通仓库   \n",
       "\n",
       "                  address contact        telno       mobile  is_disabled  \\\n",
       "0          合肥市锦绣大道5092号3楼     王明亮  17891918818  17891918818            0   \n",
       "1                   宏鼎云璟汇      得成  15914483322         None            1   \n",
       "2       广州市花都区宏发路1号（云仓仓储）     梁晓杭  13416192275  13416192275            0   \n",
       "3               锦绣大道5092号      得成  15914483322         None            1   \n",
       "4                                                                      0   \n",
       "5               东成路128号之二     贾召全  15914638528         None            1   \n",
       "6                                                                      0   \n",
       "7                       1       1            1         None            1   \n",
       "8                                                                      0   \n",
       "9                       1       1            1         None            1   \n",
       "10                            苏剑勇                                      0   \n",
       "11            西园路10号A211室      刘军  18958307567         None            1   \n",
       "12                                                                     0   \n",
       "13                  东成路1号      得成  15914483322         None            1   \n",
       "14                                                                     0   \n",
       "15          宏发路1号十一号仓收货一部     梁晓杭  13416192275         None            1   \n",
       "16                                                                     0   \n",
       "17                  宏发路1号     梁晓杭  13416192275         None            1   \n",
       "18         安徽省亳州市蒙城县宇兴华东仓     王军旗  17368808728  17368808728            0   \n",
       "19              锦绣大道5092号     程宝安  18255133250         None            1   \n",
       "20                                                                     0   \n",
       "21       广东省中山市东升镇东成路128号      董意  18680157531  18680157531            0   \n",
       "22                                                                     0   \n",
       "23      广州市花都区宏发路1号（云仓仓储）     梁晓杭  13416192275  13416192275            0   \n",
       "24  中山市 东升镇 东成路 128号   4楼     张扬超  18022325962  18022325962            0   \n",
       "25                                                                     0   \n",
       "26                  宏鼎云璟汇     黄铭润  19925675949         None            1   \n",
       "27         合肥市锦绣大道5092号3楼                                              0   \n",
       "28                  105国道      得成  15914483322         None            1   \n",
       "29                             闫璞               17753920160            0   \n",
       "30                  宏鼎云璟汇      得成  15914483322         None            1   \n",
       "31                                                                     0   \n",
       "32          宏发路1号十一号仓收货一部     梁晓杭  13416192275         None            1   \n",
       "33       广东省中山市东升镇东成路128号      董意  18680157531  18680157531            0   \n",
       "34                东成路128号      董意  18680157531         None            1   \n",
       "35                                                                     0   \n",
       "36                  宏鼎云璟汇      得成  15914483322         None            1   \n",
       "37         安徽省亳州市蒙城县宇兴华东仓                                              0   \n",
       "38  中山市 东升镇 东成路 128号   4楼     张扬超  18022325962  18022325962            0   \n",
       "39           东升镇文献路15号仓库部     黄仙珍               19928025756            0   \n",
       "\n",
       "               created            modified  \\\n",
       "0  2020-12-28 10:02:04 2020-12-28 10:02:04   \n",
       "1                  NaT                 NaT   \n",
       "2  2016-06-13 10:50:52 2021-02-02 13:45:52   \n",
       "3                  NaT                 NaT   \n",
       "4  2016-07-08 15:53:08 2017-08-03 09:01:34   \n",
       "5                  NaT                 NaT   \n",
       "6  2021-01-07 15:42:36 2021-01-07 16:34:41   \n",
       "7                  NaT                 NaT   \n",
       "8  2021-01-12 11:09:30 2021-01-12 11:09:30   \n",
       "9                  NaT                 NaT   \n",
       "10 2021-01-21 09:56:47 2021-01-21 09:56:47   \n",
       "11                 NaT                 NaT   \n",
       "12 2018-09-19 16:41:48 2020-09-07 09:34:27   \n",
       "13                 NaT                 NaT   \n",
       "14 2018-09-20 13:30:37 2020-09-07 09:34:27   \n",
       "15                 NaT                 NaT   \n",
       "16 2018-12-28 16:32:20 2020-09-07 09:34:27   \n",
       "17                 NaT                 NaT   \n",
       "18 2019-09-17 15:28:18 2021-02-02 13:45:52   \n",
       "19                 NaT                 NaT   \n",
       "20 2020-04-25 14:30:30 2021-02-02 13:45:52   \n",
       "21 2020-05-08 11:18:52 2021-02-02 13:45:52   \n",
       "22 2020-05-08 18:05:01 2021-02-02 13:45:52   \n",
       "23 2020-09-14 15:37:53 2021-02-02 13:45:52   \n",
       "24 2018-05-14 09:36:00 2021-03-22 16:12:06   \n",
       "25 2019-12-09 09:54:21 2021-02-02 13:45:52   \n",
       "26                 NaT                 NaT   \n",
       "27 2021-02-25 14:30:18 2021-02-25 14:30:52   \n",
       "28                 NaT                 NaT   \n",
       "29 2021-03-13 17:53:57 2021-03-17 13:51:41   \n",
       "30                 NaT                 NaT   \n",
       "31 2018-09-19 16:42:09 2020-09-07 09:34:27   \n",
       "32                 NaT                 NaT   \n",
       "33 2019-06-12 11:17:59 2021-02-02 13:45:52   \n",
       "34                 NaT                 NaT   \n",
       "35 2019-10-18 12:45:51 2021-02-02 13:45:52   \n",
       "36                 NaT                 NaT   \n",
       "37 2019-11-06 17:37:37 2021-02-02 13:45:52   \n",
       "38 2020-07-22 19:01:56 2021-02-02 13:45:52   \n",
       "39 2020-10-23 18:01:04 2020-10-23 18:01:04   \n",
       "\n",
       "                                 corp_id  \n",
       "0   dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "1   dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "2   dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "3   dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "4   dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "5   dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "6   dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "7   dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "8   dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "9   dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "10  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "11  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "12  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "13  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "14  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "15  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "16  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "17  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "18  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "19  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "20  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "21  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "22  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "23  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "24  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "25  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "26  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "27  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "28  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "29  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "30  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "31  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "32  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "33  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "34  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "35  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "36  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "37  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "38  dingf6c7a2573e10174a35c2f4657eb6378f  \n",
       "39  dingf6c7a2573e10174a35c2f4657eb6378f  "
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "warehouse_df_cached"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "09f16cd6",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}

一键复制编辑原始数据按行查看历史

提交于 2021-10-21 16:38 . update

马建仓 AI 助手

尝试更多

代码解读

代码找茬

代码优化

https://gitee.com/demik/pytest.git

git@gitee.com:demik/pytest.git

demik

pytest

python文档

master

Demik/python文档

简介

发行版

贡献者

近期动态

Demik/python文档 .gitee-modal { width: 500px !important; }

简介

发行版

贡献者

近期动态

搜索帮助

Demik/python文档