{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "8d8fa929-88b4-41a2-b6be-950a3dcebafb",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "a = pd.read_csv('de/tj/JD_PeiBi.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "2fe8cd17-1722-4fa4-9137-3bd91cb05eb5",
   "metadata": {},
   "outputs": [],
   "source": [
    "b= a[a['PBMC'].str.contains('砂浆')]['PBBH'].to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "c1501edb-8dee-4b12-a4ab-fbc9c8b3e8f6",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    },
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['80010103',\n",
       " '80010104',\n",
       " '80010105',\n",
       " '80010106',\n",
       " '80050103',\n",
       " '80050104',\n",
       " '80050105',\n",
       " '80050106',\n",
       " '80010121',\n",
       " '80010122',\n",
       " '80010123',\n",
       " '80010124',\n",
       " '80010125',\n",
       " '80010161',\n",
       " '80070303',\n",
       " '80070304',\n",
       " '80070305',\n",
       " '80070306',\n",
       " '80010142',\n",
       " '80050120',\n",
       " '80050121',\n",
       " '80050122',\n",
       " '80050123',\n",
       " '80050124',\n",
       " '80050125',\n",
       " '80050126',\n",
       " '80050312',\n",
       " '80050127',\n",
       " '80050311',\n",
       " '80050128',\n",
       " '80050130',\n",
       " '80050317',\n",
       " '80050129',\n",
       " '80050133',\n",
       " '80030103',\n",
       " '80030104',\n",
       " '80030105',\n",
       " '80030106',\n",
       " '80030121',\n",
       " '80050503',\n",
       " '80071505',\n",
       " '80071506',\n",
       " '80070905',\n",
       " '80070906',\n",
       " '80070907',\n",
       " '80090325',\n",
       " '80090326',\n",
       " '80071521',\n",
       " '80071511',\n",
       " '80070721',\n",
       " '80090324',\n",
       " '80071307',\n",
       " '80071331',\n",
       " '80090314',\n",
       " '80090315',\n",
       " '80071321',\n",
       " '80050108',\n",
       " '80050111',\n",
       " '80010341']"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "26ce177b-fc51-471a-a4f7-1264c2f52f05",
   "metadata": {},
   "outputs": [],
   "source": [
    "c = pd.read_csv('de/tj/JD_PeiBiF.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "d04c8045-d274-4db2-a0c5-adba9865d500",
   "metadata": {},
   "outputs": [],
   "source": [
    "d = c[c['PBBH'].isin(b)][['PBBH', 'SL', 'RcjID']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "c15a291d-8ffb-4569-bd36-28db0ee42f9b",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([['80010103', 202.0, 273],\n",
       "       ['80010103', 1.61, 277],\n",
       "       ['80010103', 0.3, 1173],\n",
       "       ['80010104', 217.0, 273],\n",
       "       ['80010104', 1.61, 277],\n",
       "       ['80010104', 0.3, 1173],\n",
       "       ['80010105', 223.0, 273],\n",
       "       ['80010105', 1.61, 277],\n",
       "       ['80010105', 0.3, 1173],\n",
       "       ['80010106', 253.0, 273],\n",
       "       ['80010106', 1.61, 277],\n",
       "       ['80010106', 0.3, 1173],\n",
       "       ['80050103', 174.0, 273],\n",
       "       ['80050103', 1.61, 277],\n",
       "       ['80050103', 0.1, 1369],\n",
       "       ['80050103', 0.3, 1173],\n",
       "       ['80050104', 202.0, 273],\n",
       "       ['80050104', 1.61, 277],\n",
       "       ['80050104', 0.08, 1369],\n",
       "       ['80050104', 0.3, 1173],\n",
       "       ['80050105', 230.0, 273],\n",
       "       ['80050105', 1.61, 277],\n",
       "       ['80050105', 0.05, 1369],\n",
       "       ['80050105', 0.3, 1173],\n",
       "       ['80050106', 258.0, 273],\n",
       "       ['80050106', 1.61, 277],\n",
       "       ['80050106', 0.03, 1369],\n",
       "       ['80050106', 0.3, 1173],\n",
       "       ['80010121', 765.0, 273],\n",
       "       ['80010121', 1.007, 277],\n",
       "       ['80010121', 0.3, 1173],\n",
       "       ['80010122', 644.0, 273],\n",
       "       ['80010122', 1.272, 277],\n",
       "       ['80010122', 0.3, 1173],\n",
       "       ['80010123', 557.0, 273],\n",
       "       ['80010123', 1.464, 277],\n",
       "       ['80010123', 0.3, 1173],\n",
       "       ['80010124', 490.0, 273],\n",
       "       ['80010124', 1.611, 277],\n",
       "       ['80010124', 0.3, 1173],\n",
       "       ['80010125', 408.0, 273],\n",
       "       ['80010125', 1.611, 277],\n",
       "       ['80010125', 0.3, 1173],\n",
       "       ['80010161', 359.0, 273],\n",
       "       ['80010161', 1.611, 277],\n",
       "       ['80010161', 0.15, 1173],\n",
       "       ['80070303', 765.0, 273],\n",
       "       ['80070303', 1.007, 277],\n",
       "       ['80070303', 38.25, 1371],\n",
       "       ['80070303', 0.3, 1173],\n",
       "       ['80070304', 644.0, 273],\n",
       "       ['80070304', 1.272, 277],\n",
       "       ['80070304', 32.2, 1371],\n",
       "       ['80070304', 0.3, 1173],\n",
       "       ['80070305', 557.0, 273],\n",
       "       ['80070305', 1.464, 277],\n",
       "       ['80070305', 27.85, 1371],\n",
       "       ['80070305', 0.3, 1173],\n",
       "       ['80070306', 490.0, 273],\n",
       "       ['80070306', 1.611, 277],\n",
       "       ['80070306', 24.5, 1371],\n",
       "       ['80070306', 0.3, 1173],\n",
       "       ['80010142', 644.0, 274],\n",
       "       ['80010142', 1.28, 277],\n",
       "       ['80010142', 0.3, 1173],\n",
       "       ['80050120', 185.0, 273],\n",
       "       ['80050120', 1.48, 277],\n",
       "       ['80050120', 0.31, 1369],\n",
       "       ['80050120', 0.6, 1173],\n",
       "       ['80050121', 130.0, 273],\n",
       "       ['80050121', 1.56, 277],\n",
       "       ['80050121', 0.32, 1369],\n",
       "       ['80050121', 0.6, 1173],\n",
       "       ['80050122', 340.0, 273],\n",
       "       ['80050122', 0.46, 277],\n",
       "       ['80050122', 0.56, 1369],\n",
       "       ['80050122', 0.6, 1173],\n",
       "       ['80050123', 306.0, 273],\n",
       "       ['80050123', 1.63, 277],\n",
       "       ['80050123', 0.13, 1369],\n",
       "       ['80050123', 0.6, 1173],\n",
       "       ['80050124', 382.0, 273],\n",
       "       ['80050124', 1.01, 277],\n",
       "       ['80050124', 0.32, 1369],\n",
       "       ['80050124', 0.6, 1173],\n",
       "       ['80050125', 204.0, 273],\n",
       "       ['80050125', 1.63, 277],\n",
       "       ['80050125', 0.17, 1369],\n",
       "       ['80050125', 0.6, 1173],\n",
       "       ['80050126', 466.0, 273],\n",
       "       ['80050126', 1.52, 277],\n",
       "       ['80050126', 0.04, 1369],\n",
       "       ['80050126', 0.6, 1173],\n",
       "       ['80050312', 371.0, 273],\n",
       "       ['80050312', 1.48, 277],\n",
       "       ['80050312', 0.15, 1369],\n",
       "       ['80050312', 0.6, 1173],\n",
       "       ['80050127', 278.0, 273],\n",
       "       ['80050127', 1.48, 277],\n",
       "       ['80050127', 0.23, 1369],\n",
       "       ['80050127', 0.6, 1173],\n",
       "       ['80050311', 453.0, 273],\n",
       "       ['80050311', 1.2, 277],\n",
       "       ['80050311', 0.19, 1369],\n",
       "       ['80050311', 0.6, 1173],\n",
       "       ['80050128', 510.0, 273],\n",
       "       ['80050128', 1.36, 277],\n",
       "       ['80050128', 0.08, 1369],\n",
       "       ['80050128', 0.6, 1173],\n",
       "       ['80050130', 583.0, 273],\n",
       "       ['80050130', 0.77, 277],\n",
       "       ['80050130', 0.24, 1369],\n",
       "       ['80050130', 0.6, 1173],\n",
       "       ['80050317', 467.0, 273],\n",
       "       ['80050317', 0.62, 277],\n",
       "       ['80050317', 0.39, 1369],\n",
       "       ['80050317', 0.6, 1173],\n",
       "       ['80050129', 391.0, 273],\n",
       "       ['80050129', 1.56, 277],\n",
       "       ['80050129', 0.1, 1369],\n",
       "       ['80050129', 0.6, 1173],\n",
       "       ['80050133', 242.0, 273],\n",
       "       ['80050133', 1.61, 277],\n",
       "       ['80050133', 0.1, 1369],\n",
       "       ['80050133', 0.6, 1173],\n",
       "       ['80030103', 1.47, 277],\n",
       "       ['80030103', 0.47, 1369],\n",
       "       ['80030103', 0.6, 1173],\n",
       "       ['80030104', 1.61, 277],\n",
       "       ['80030104', 0.4, 1369],\n",
       "       ['80030104', 0.6, 1173],\n",
       "       ['80030105', 1.61, 277],\n",
       "       ['80030105', 0.36, 1369],\n",
       "       ['80030105', 0.6, 1173],\n",
       "       ['80030106', 1.61, 277],\n",
       "       ['80030106', 0.25, 1369],\n",
       "       ['80030106', 0.6, 1173],\n",
       "       ['80030121', 1.63, 277],\n",
       "       ['80030121', 0.34, 1369],\n",
       "       ['80030121', 0.6, 1173],\n",
       "       ['80030121', 16.6, 114],\n",
       "       ['80050503', 224.0, 273],\n",
       "       ['80050503', 1.18, 277],\n",
       "       ['80050503', 0.37, 1369],\n",
       "       ['80050503', 0.6, 1173],\n",
       "       ['80050503', 26.63, 1381],\n",
       "       ['80071505', 1.56, 277],\n",
       "       ['80071505', 530.0, 292],\n",
       "       ['80071505', 275.0, 838],\n",
       "       ['80071506', 1.69, 277],\n",
       "       ['80071506', 468.0, 292],\n",
       "       ['80071506', 244.0, 838],\n",
       "       ['80070905', 312.96, 273],\n",
       "       ['80070905', 1.18, 1362],\n",
       "       ['80070905', 0.4, 1173],\n",
       "       ['80070906', 340.1, 273],\n",
       "       ['80070906', 1.14, 1362],\n",
       "       ['80070906', 0.4, 1173],\n",
       "       ['80070907', 411.48, 273],\n",
       "       ['80070907', 1.04, 1362],\n",
       "       ['80070907', 0.4, 1173],\n",
       "       ['80090325', 391.0, 293],\n",
       "       ['80090325', 0.672, 280],\n",
       "       ['80090325', 68.0, 1359],\n",
       "       ['80090325', 1129.0, 1380],\n",
       "       ['80090326', 1085.0, 273],\n",
       "       ['80090326', 0.32, 275],\n",
       "       ['80090326', 1650.0, 1358],\n",
       "       ['80090326', 0.4, 1173],\n",
       "       ['80071521', 408.0, 838],\n",
       "       ['80071521', 1.23, 1360],\n",
       "       ['80071521', 219.0, 1377],\n",
       "       ['80071521', 224.0, 1379],\n",
       "       ['80071511', 543.0, 293],\n",
       "       ['80071511', 1.547, 280],\n",
       "       ['80071511', 280.0, 838],\n",
       "       ['80070721', 458.0, 293],\n",
       "       ['80070721', 1.082, 280],\n",
       "       ['80070721', 0.416, 1370],\n",
       "       ['80070721', 412.0, 1541],\n",
       "       ['80070721', 70.0, 900],\n",
       "       ['80090324', 490.0, 273],\n",
       "       ['80090324', 2.467, 1361],\n",
       "       ['80090324', 0.4, 1173],\n",
       "       ['80071307', 668.0, 293],\n",
       "       ['80071307', 1.336, 280],\n",
       "       ['80071307', 337.0, 1372],\n",
       "       ['80071307', 167.0, 905],\n",
       "       ['80071307', 67.0, 906],\n",
       "       ['80071331', 663.0, 293],\n",
       "       ['80071331', 1.324, 280],\n",
       "       ['80071331', 233.49, 1372],\n",
       "       ['80071331', 17.0, 905],\n",
       "       ['80071331', 46.7, 906],\n",
       "       ['80071331', 108.0, 813],\n",
       "       ['80090314', 585.0, 293],\n",
       "       ['80090314', 1.138, 280],\n",
       "       ['80090314', 23.0, 909],\n",
       "       ['80090314', 325.3, 815],\n",
       "       ['80090314', 10.0, 879],\n",
       "       ['80090314', 10.0, 1375],\n",
       "       ['80090315', 599.0, 293],\n",
       "       ['80090315', 1.164, 280],\n",
       "       ['80090315', 332.6, 1373],\n",
       "       ['80090315', 23.5, 909],\n",
       "       ['80090315', 10.0, 879],\n",
       "       ['80090315', 10.0, 1375],\n",
       "       ['80071321', 655.0, 293],\n",
       "       ['80071321', 1.31, 280],\n",
       "       ['80071321', 165.0, 1372],\n",
       "       ['80071321', 14.0, 905],\n",
       "       ['80071321', 14.0, 906],\n",
       "       ['80071321', 33.0, 903],\n",
       "       ['80071321', 166.0, 894],\n",
       "       ['80050111', 731.0, 1526],\n",
       "       ['80050111', 0.95, 1527],\n",
       "       ['80050111', 0.4, 1173],\n",
       "       ['80050108', 466.0, 1526],\n",
       "       ['80050108', 1.03, 1527],\n",
       "       ['80050108', 0.4, 1173]], dtype=object)"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d.to_numpy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "49210713-c7b3-4bc6-a144-6f26cd0b3a34",
   "metadata": {},
   "outputs": [],
   "source": [
    "did = d['RcjID']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "9385f4b9-7084-42ab-82d3-75c9820da698",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[273,\n",
       " 277,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1371,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1371,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1371,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1371,\n",
       " 1173,\n",
       " 274,\n",
       " 277,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 114,\n",
       " 273,\n",
       " 277,\n",
       " 1369,\n",
       " 1173,\n",
       " 1381,\n",
       " 277,\n",
       " 292,\n",
       " 838,\n",
       " 277,\n",
       " 292,\n",
       " 838,\n",
       " 273,\n",
       " 1362,\n",
       " 1173,\n",
       " 273,\n",
       " 1362,\n",
       " 1173,\n",
       " 273,\n",
       " 1362,\n",
       " 1173,\n",
       " 293,\n",
       " 280,\n",
       " 1359,\n",
       " 1380,\n",
       " 273,\n",
       " 275,\n",
       " 1358,\n",
       " 1173,\n",
       " 838,\n",
       " 1360,\n",
       " 1377,\n",
       " 1379,\n",
       " 293,\n",
       " 280,\n",
       " 838,\n",
       " 293,\n",
       " 280,\n",
       " 1370,\n",
       " 1541,\n",
       " 900,\n",
       " 273,\n",
       " 1361,\n",
       " 1173,\n",
       " 293,\n",
       " 280,\n",
       " 1372,\n",
       " 905,\n",
       " 906,\n",
       " 293,\n",
       " 280,\n",
       " 1372,\n",
       " 905,\n",
       " 906,\n",
       " 813,\n",
       " 293,\n",
       " 280,\n",
       " 909,\n",
       " 815,\n",
       " 879,\n",
       " 1375,\n",
       " 293,\n",
       " 280,\n",
       " 1373,\n",
       " 909,\n",
       " 879,\n",
       " 1375,\n",
       " 293,\n",
       " 280,\n",
       " 1372,\n",
       " 905,\n",
       " 906,\n",
       " 903,\n",
       " 894,\n",
       " 1526,\n",
       " 1527,\n",
       " 1173,\n",
       " 1526,\n",
       " 1527,\n",
       " 1173]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "did.to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "2e06083f-afee-4575-aa8a-42611ac2b784",
   "metadata": {},
   "outputs": [],
   "source": [
    "e = pd.read_csv('de/tj/JD_CaiLiaoK.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "8baa861f-711e-4669-83ca-4271d84673b0",
   "metadata": {},
   "outputs": [],
   "source": [
    "f = e[e['RcjID'].isin(did.to_list())][['CLBH', 'CLMC', 'JLDW', 'YSJG', 'RcjID']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "958ee8cb-2f5a-4d3a-9b26-287af4d63f45",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([['02290501', '麻刀', 'kg', 2.4, 114],\n",
       "       ['04010611', '水泥 32.5级', 'kg', 0.31, 273],\n",
       "       ['04010701', '白水泥', 'kg', 0.7, 274],\n",
       "       ['04030100', '黄砂', 't', 74.0, 275],\n",
       "       ['04030107', '中砂', 't', 69.37, 277],\n",
       "       ['04030133', '石英砂', 't', 180.0, 280],\n",
       "       ['04090602', '滑石粉', 'kg', 0.62, 292],\n",
       "       ['04090700', '石英粉', 'kg', 0.35, 293],\n",
       "       ['11410319', '呋喃树脂', 'kg', 18.0, 813],\n",
       "       ['11410324', '邻苯型不饱和聚酸树脂', 'kg', 20.0, 815],\n",
       "       ['11550105', '石油沥青 30#', 'kg', 5.5, 838],\n",
       "       ['11593507', '过氧化环乙酮二丁酯糊 50%', 'kg', 16.0, 879],\n",
       "       ['12060323', '煤焦油', 'kg', 2.8, 894],\n",
       "       ['12300325', '氟硅酸钠', 'kg', 2.8, 900],\n",
       "       ['12310303', '二甲苯', 'kg', 5.9, 903],\n",
       "       ['12310307', '乙二胺', 'kg', 15.0, 905],\n",
       "       ['12310308', '丙酮', 'kg', 6.0, 906],\n",
       "       ['12310317', '苯乙烯', 'kg', 9.7, 909],\n",
       "       ['31150101', '水', 'm3', 4.7, 1173],\n",
       "       ['01650104', '钢屑', 'kg', 2.4, 1358],\n",
       "       ['02070404', '聚硫橡胶', 'kg', 30.0, 1359],\n",
       "       ['04030121', '白云石砂 4#', 't', 133.0, 1360],\n",
       "       ['04030129', '重晶石砂', 't', 330.0, 1361],\n",
       "       ['04030139', '轻质砂', 'm3', 70.0, 1362],\n",
       "       ['04090120', '石灰膏', 'm3', 216.0, 1369],\n",
       "       ['04090605', '铸石粉', 't', 712.5, 1370],\n",
       "       ['04230108', '防水剂', 'kg', 5.0, 1371],\n",
       "       ['11410305', '环氧树脂 E42', 'kg', 19.95, 1372],\n",
       "       ['11410325', '双酚A不饱和聚脂树脂', 'kg', 19.0, 1373],\n",
       "       ['12310329', '环烷酸钴苯乙烯液', 'kg', 12.0, 1375],\n",
       "       ['13010102', '温石棉', 'kg', 7.79, 1377],\n",
       "       ['13160303', '硅藻土', 'kg', 0.38, 1379],\n",
       "       ['31052502', '硫磺', 'kg', 1.8, 1380],\n",
       "       ['31132509', '纸筋', 'kg', 1.5, 1381],\n",
       "       ['04010611', '复合硅酸盐水泥  32.5级', 'kg', 0.31, 1526],\n",
       "       ['04030107', '中(粗)砂', 't', 69.37, 1527],\n",
       "       ['12413531', '水玻璃', 'kg', 0.85, 1541]], dtype=object)"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f.to_numpy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "76ce8804-c253-48d9-b28e-e69bb836c5bd",
   "metadata": {},
   "outputs": [],
   "source": [
    "a = pd.read_csv('de/yl/JD_PeiBi.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "874a65e8-007a-45a5-a0e8-35aa7837d31f",
   "metadata": {},
   "outputs": [],
   "source": [
    "b= a[a['PBMC'].str.contains('砂浆')]['PBBH'].to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "5d4dde93-5027-4cfa-be48-7bfd826cc8a2",
   "metadata": {},
   "outputs": [],
   "source": [
    "c = pd.read_csv('de/yl/JD_PeiBiF.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "4dd89efa-4818-483c-9797-c0c6000cc67a",
   "metadata": {},
   "outputs": [],
   "source": [
    "d = c[c['PBBH'].isin(b)][['PBBH', 'SL', 'RcjID']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "3a857052-f75d-4e45-b882-76a1a7ae3e53",
   "metadata": {},
   "outputs": [],
   "source": [
    "did = d['RcjID']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "fb120379-e658-4ff3-a77f-076f8093ea65",
   "metadata": {},
   "outputs": [],
   "source": [
    "e = pd.read_csv('de/yl/JD_CaiLiaoK.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "f3933c63-ee0c-42e9-9669-f7aa2ae269d8",
   "metadata": {},
   "outputs": [],
   "source": [
    "f = e[e['RcjID'].isin(did.to_list())][['CLBH', 'CLMC', 'JLDW', 'YSJG', 'RcjID']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "a22cd4fb-9e93-4c24-a079-e3983ae4f357",
   "metadata": {},
   "outputs": [],
   "source": [
    "d['PBBH'] = d['PBBH'].astype(str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "56853e5c-12c2-49eb-9cd7-ee1f66e075f1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([['0430061', '白水泥', 'kg', 0.52, 29595],\n",
       "       ['0430080', '水泥 32.5级', 'kg', 0.3, 29596],\n",
       "       ['0530135', '白石子', 't', 106.3, 29611],\n",
       "       ['0530490', '石灰膏', 'm3', 118.0, 29677],\n",
       "       ['0530720', '中砂', 't', 36.5, 29714],\n",
       "       ['1730060', '防水剂', 'kg', 1.52, 29983],\n",
       "       ['2230080', '滑石粉', 'kg', 0.45, 30134],\n",
       "       ['2230131', '石油沥青 30#', 'kg', 3.69, 30140],\n",
       "       ['2330290', '麻刀', 'kg', 2.0, 30165],\n",
       "       ['2330450', '水', 'm3', 4.1, 30181],\n",
       "       ['2330520', '纸筋', 'kg', 0.5, 30188],\n",
       "       ['2359999', '其它材料费(调整)', '元', 1.0, 31054]], dtype=object)"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f.to_numpy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "ed8dcdc0-9402-4dbe-b3b8-ec927f31afb2",
   "metadata": {},
   "outputs": [],
   "source": [
    "a = pd.read_csv('de/xsaz/JD_PeiBi.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "019a31b8-610a-4873-b9d2-c31191c8f014",
   "metadata": {},
   "outputs": [],
   "source": [
    "b= a[a['PBMC'].str.contains('砂浆')]['PBBH'].to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "22b2eaaa-e170-4ad0-9ad4-cc8e5acbe141",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[304912001,\n",
       " 304912002,\n",
       " 304912003,\n",
       " 304912004,\n",
       " 304912005,\n",
       " 304912006,\n",
       " 304912007,\n",
       " 304912008,\n",
       " 304913001,\n",
       " 304913002,\n",
       " 304913003,\n",
       " 304913004,\n",
       " 304913005,\n",
       " 304913006,\n",
       " 304913007,\n",
       " 304913008,\n",
       " 304913009,\n",
       " 304913010,\n",
       " 304913012,\n",
       " 304913013,\n",
       " 304913014,\n",
       " 304913015,\n",
       " 304913016,\n",
       " 304913017,\n",
       " 304913018,\n",
       " 304913019,\n",
       " 304913020,\n",
       " 304913021,\n",
       " 304913022,\n",
       " 304913023,\n",
       " 304913024,\n",
       " 304913025,\n",
       " 304913026,\n",
       " 304913027,\n",
       " 304913028,\n",
       " 304913029,\n",
       " 304913030,\n",
       " 304913031,\n",
       " 304913071,\n",
       " 304913072,\n",
       " 304914008,\n",
       " 304914009,\n",
       " 304914015,\n",
       " 304913011,\n",
       " 304916001,\n",
       " 304916002,\n",
       " 304916003,\n",
       " 304916004,\n",
       " 304916005,\n",
       " 304916006,\n",
       " 304916007]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "34afe716-d6b8-4aef-be8d-44663da37adf",
   "metadata": {},
   "outputs": [],
   "source": [
    "c = pd.read_csv('de/xsaz/JD_PeiBiF.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "c754318f-c287-4855-b364-77008be11029",
   "metadata": {},
   "outputs": [],
   "source": [
    "d = c[c['PBBH'].isin(b)][['PBBH', 'SL', 'RcjID']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "b78a55c6-60e4-4219-b164-2f6c3942ca3e",
   "metadata": {},
   "outputs": [],
   "source": [
    "d['PBBH'] = d['PBBH'].astype(str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "d06696a5-112f-4c98-9430-3edb49de49c2",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([['304912001', 202.0, 263],\n",
       "       ['304912001', 1.61, 5],\n",
       "       ['304912001', 0.3, 353],\n",
       "       ['304912002', 217.0, 263],\n",
       "       ['304912002', 1.61, 5],\n",
       "       ['304912002', 0.3, 353],\n",
       "       ['304912003', 223.0, 263],\n",
       "       ['304912003', 1.61, 5],\n",
       "       ['304912003', 0.3, 353],\n",
       "       ['304912004', 253.0, 263],\n",
       "       ['304912004', 1.61, 5],\n",
       "       ['304912004', 0.3, 353],\n",
       "       ['304912005', 174.0, 263],\n",
       "       ['304912005', 1.61, 5],\n",
       "       ['304912005', 0.1, 38],\n",
       "       ['304912005', 0.3, 353],\n",
       "       ['304912006', 202.0, 263],\n",
       "       ['304912006', 1.61, 5],\n",
       "       ['304912006', 0.08, 38],\n",
       "       ['304912006', 0.3, 353],\n",
       "       ['304912007', 230.0, 263],\n",
       "       ['304912007', 1.61, 5],\n",
       "       ['304912007', 0.05, 38],\n",
       "       ['304912007', 0.3, 353],\n",
       "       ['304912008', 258.0, 263],\n",
       "       ['304912008', 1.61, 5],\n",
       "       ['304912008', 0.03, 38],\n",
       "       ['304912008', 0.3, 353],\n",
       "       ['304913001', 765.0, 263],\n",
       "       ['304913001', 1.007, 5],\n",
       "       ['304913001', 0.3, 353],\n",
       "       ['304913002', 644.0, 263],\n",
       "       ['304913002', 1.272, 5],\n",
       "       ['304913002', 0.3, 353],\n",
       "       ['304913003', 557.0, 263],\n",
       "       ['304913003', 1.464, 5],\n",
       "       ['304913003', 0.3, 353],\n",
       "       ['304913004', 490.0, 263],\n",
       "       ['304913004', 1.611, 5],\n",
       "       ['304913004', 0.3, 353],\n",
       "       ['304913005', 408.0, 263],\n",
       "       ['304913005', 1.611, 5],\n",
       "       ['304913005', 0.3, 353],\n",
       "       ['304913006', 359.0, 263],\n",
       "       ['304913006', 1.611, 5],\n",
       "       ['304913006', 0.15, 353],\n",
       "       ['304913012', 644.0, 266],\n",
       "       ['304913012', 1.28, 5],\n",
       "       ['304913012', 0.3, 353],\n",
       "       ['304913013', 185.0, 263],\n",
       "       ['304913013', 0.31, 38],\n",
       "       ['304913013', 1.48, 5],\n",
       "       ['304913013', 0.3, 353],\n",
       "       ['304913014', 130.0, 263],\n",
       "       ['304913014', 0.32, 38],\n",
       "       ['304913014', 1.56, 5],\n",
       "       ['304913014', 0.3, 353],\n",
       "       ['304913015', 340.0, 263],\n",
       "       ['304913015', 0.56, 38],\n",
       "       ['304913015', 0.46, 5],\n",
       "       ['304913015', 0.3, 353],\n",
       "       ['304913016', 306.0, 263],\n",
       "       ['304913016', 0.13, 38],\n",
       "       ['304913016', 1.63, 5],\n",
       "       ['304913016', 0.3, 353],\n",
       "       ['304913017', 382.0, 263],\n",
       "       ['304913017', 0.32, 38],\n",
       "       ['304913017', 1.01, 5],\n",
       "       ['304913017', 0.3, 353],\n",
       "       ['304913018', 204.0, 263],\n",
       "       ['304913018', 0.17, 38],\n",
       "       ['304913018', 1.63, 5],\n",
       "       ['304913018', 0.3, 353],\n",
       "       ['304913019', 466.0, 263],\n",
       "       ['304913019', 0.04, 38],\n",
       "       ['304913019', 1.52, 5],\n",
       "       ['304913019', 0.3, 353],\n",
       "       ['304913020', 371.0, 263],\n",
       "       ['304913020', 0.15, 38],\n",
       "       ['304913020', 1.48, 5],\n",
       "       ['304913020', 0.3, 353],\n",
       "       ['304913021', 278.0, 263],\n",
       "       ['304913021', 0.23, 38],\n",
       "       ['304913021', 1.48, 5],\n",
       "       ['304913021', 0.3, 353],\n",
       "       ['304913022', 453.0, 263],\n",
       "       ['304913022', 0.19, 38],\n",
       "       ['304913022', 1.2, 5],\n",
       "       ['304913022', 0.3, 353],\n",
       "       ['304913023', 510.0, 263],\n",
       "       ['304913023', 0.08, 38],\n",
       "       ['304913023', 1.36, 5],\n",
       "       ['304913023', 0.3, 353],\n",
       "       ['304913024', 583.0, 263],\n",
       "       ['304913024', 0.24, 38],\n",
       "       ['304913024', 0.77, 5],\n",
       "       ['304913024', 0.3, 353],\n",
       "       ['304913025', 467.0, 263],\n",
       "       ['304913025', 0.39, 38],\n",
       "       ['304913025', 0.62, 5],\n",
       "       ['304913025', 0.3, 353],\n",
       "       ['304913026', 391.0, 263],\n",
       "       ['304913026', 0.1, 38],\n",
       "       ['304913026', 1.56, 5],\n",
       "       ['304913026', 0.3, 353],\n",
       "       ['304913027', 242.0, 263],\n",
       "       ['304913027', 0.1, 38],\n",
       "       ['304913027', 1.61, 5],\n",
       "       ['304913027', 0.3, 353],\n",
       "       ['304913028', 0.47, 38],\n",
       "       ['304913028', 1.47, 5],\n",
       "       ['304913028', 0.3, 353],\n",
       "       ['304913029', 0.4, 38],\n",
       "       ['304913029', 1.61, 5],\n",
       "       ['304913029', 0.3, 353],\n",
       "       ['304913030', 0.36, 38],\n",
       "       ['304913030', 1.61, 5],\n",
       "       ['304913030', 0.3, 353],\n",
       "       ['304913031', 0.25, 38],\n",
       "       ['304913031', 1.61, 5],\n",
       "       ['304913031', 0.3, 353],\n",
       "       ['304913071', 0.34, 38],\n",
       "       ['304913071', 1.63, 5],\n",
       "       ['304913071', 16.6, 1198],\n",
       "       ['304913071', 0.3, 353],\n",
       "       ['304913072', 224.0, 263],\n",
       "       ['304913072', 0.37, 38],\n",
       "       ['304913072', 1.18, 5],\n",
       "       ['304913072', 26.63, 47],\n",
       "       ['304913072', 0.3, 353],\n",
       "       ['304914008', 1.56, 5],\n",
       "       ['304914008', 275.0, 1085],\n",
       "       ['304914008', 530.0, 41],\n",
       "       ['304914009', 1.69, 5],\n",
       "       ['304914009', 244.0, 1085],\n",
       "       ['304914009', 468.0, 41],\n",
       "       ['304914015', 1085.0, 263],\n",
       "       ['304914015', 0.32, 6],\n",
       "       ['304914015', 1650.0, 864],\n",
       "       ['304914015', 0.4, 353],\n",
       "       ['304913007', 765.0, 263],\n",
       "       ['304913007', 1.007, 5],\n",
       "       ['304913007', 38.25, 1305],\n",
       "       ['304913007', 0.3, 353],\n",
       "       ['304913008', 644.0, 263],\n",
       "       ['304913008', 1.272, 5],\n",
       "       ['304913008', 32.2, 1305],\n",
       "       ['304913008', 0.3, 353],\n",
       "       ['304913009', 557.0, 263],\n",
       "       ['304913009', 1.464, 5],\n",
       "       ['304913009', 27.85, 1305],\n",
       "       ['304913009', 0.3, 353],\n",
       "       ['304913010', 490.0, 263],\n",
       "       ['304913010', 1.611, 5],\n",
       "       ['304913010', 24.5, 1305],\n",
       "       ['304913010', 0.3, 353],\n",
       "       ['304913011', 408.0, 263],\n",
       "       ['304913011', 1.611, 5],\n",
       "       ['304913011', 0.3, 353],\n",
       "       ['304913011', 20.4, 1305],\n",
       "       ['304916001', 312.96, 263],\n",
       "       ['304916001', 1.18, 12],\n",
       "       ['304916001', 0.4, 353],\n",
       "       ['304916002', 340.1, 263],\n",
       "       ['304916002', 1.14, 12],\n",
       "       ['304916002', 0.4, 353],\n",
       "       ['304916003', 411.48, 263],\n",
       "       ['304916003', 1.04, 12],\n",
       "       ['304916003', 0.4, 353],\n",
       "       ['304916004', 180.46, 263],\n",
       "       ['304916004', 1.13, 12],\n",
       "       ['304916004', 0.12, 38],\n",
       "       ['304916004', 0.4, 353],\n",
       "       ['304916005', 262.65, 263],\n",
       "       ['304916005', 0.99, 12],\n",
       "       ['304916005', 0.13, 38],\n",
       "       ['304916005', 0.4, 353],\n",
       "       ['304916006', 281.51, 263],\n",
       "       ['304916006', 0.94, 12],\n",
       "       ['304916006', 0.14, 38],\n",
       "       ['304916006', 0.4, 353],\n",
       "       ['304916007', 312.96, 263],\n",
       "       ['304916007', 0.92, 12],\n",
       "       ['304916007', 0.13, 38],\n",
       "       ['304916007', 0.4, 353]], dtype=object)"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d.to_numpy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "330bcab6-f079-4c5f-b8f6-6607af510723",
   "metadata": {},
   "outputs": [],
   "source": [
    "did = d['RcjID']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "91382314-5f2b-4103-9b6a-59d731b8e5b6",
   "metadata": {},
   "outputs": [],
   "source": [
    "e = pd.read_csv('de/xsaz/JD_CaiLiaoK.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "f2c17949-af8b-4fd5-842d-816f6bf1a14f",
   "metadata": {},
   "outputs": [],
   "source": [
    "f = e[e['RcjID'].isin(did.to_list())][['CLBH', 'CLMC', 'JLDW', 'YSJG', 'RcjID']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "191315e4-099d-4f68-b0bd-9ee0d0b578cb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([['0101020201', '中砂', 't', 68.5, 5],\n",
       "       ['0101020401', '砂', 't', 59.0, 6],\n",
       "       ['0101070501', '轻质砂 JML', 'm3', 70.0, 12],\n",
       "       ['0105010201', '石灰膏', 'm3', 160.0, 38],\n",
       "       ['0105050201', '滑石粉', 'kg', 0.45, 41],\n",
       "       ['0105060402', '纸筋', 'kg', 0.5, 47],\n",
       "       ['0301010102', '水泥 32.5级', 'kg', 0.31, 263],\n",
       "       ['0301030100', '白水泥', 'kg', 0.58, 266],\n",
       "       ['0612070102', '水', 'm3', 4.1, 353],\n",
       "       ['0512010304', '钢屑', 'kg', 0.76, 864],\n",
       "       ['0604010302', '石油沥青30#', 'kg', 3.69, 1085],\n",
       "       ['0608013501', '麻刀', 'kg', 2.0, 1198],\n",
       "       ['0609100611', '防水剂', 'kg', 1.52, 1305]], dtype=object)"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f.to_numpy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "851f0031-a904-400d-8724-19e563340bec",
   "metadata": {},
   "outputs": [],
   "source": [
    "a = pd.read_csv('de/xstj/JD_PeiBi.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "f8553bd8-6734-4f4a-bebe-405c82682f63",
   "metadata": {},
   "outputs": [],
   "source": [
    "b= a[a['PBMC'].str.contains('砂浆')]['PBBH'].to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "a2201037-0720-465c-a072-d9c0458b82c6",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[304912001,\n",
       " 304912002,\n",
       " 304912003,\n",
       " 304912004,\n",
       " 304912005,\n",
       " 304912006,\n",
       " 304912007,\n",
       " 304912008,\n",
       " 304913001,\n",
       " 304913002,\n",
       " 304913003,\n",
       " 304913004,\n",
       " 304913005,\n",
       " 304913006,\n",
       " 304913007,\n",
       " 304913008,\n",
       " 304913009,\n",
       " 304913010,\n",
       " 304913012,\n",
       " 304913013,\n",
       " 304913014,\n",
       " 304913015,\n",
       " 304913016,\n",
       " 304913017,\n",
       " 304913018,\n",
       " 304913019,\n",
       " 304913020,\n",
       " 304913021,\n",
       " 304913022,\n",
       " 304913023,\n",
       " 304913024,\n",
       " 304913025,\n",
       " 304913026,\n",
       " 304913027,\n",
       " 304913028,\n",
       " 304913029,\n",
       " 304913030,\n",
       " 304913031,\n",
       " 304913071,\n",
       " 304913072,\n",
       " 304914008,\n",
       " 304914009,\n",
       " 304914015,\n",
       " 304913011,\n",
       " 304916001,\n",
       " 304916002,\n",
       " 304916003,\n",
       " 304916004,\n",
       " 304916005,\n",
       " 304916006,\n",
       " 304916007]"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "788d018d-b53d-4148-9a91-198ac7f92029",
   "metadata": {},
   "outputs": [],
   "source": [
    "c = pd.read_csv('de/xstj/JD_PeiBiF.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "9db33591-4b6e-46a5-b2c4-518b4545689c",
   "metadata": {},
   "outputs": [],
   "source": [
    "d = c[c['PBBH'].isin(b)][['PBBH', 'SL', 'RcjID']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "983405ed-8ce7-40eb-bf5c-5e369f0f843b",
   "metadata": {},
   "outputs": [],
   "source": [
    "d['PBBH'] = d['PBBH'].astype(str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "a2a8c56a-33b3-4cfd-a171-e82d098ae17f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([['304912001', 202.0, 263],\n",
       "       ['304912001', 1.61, 5],\n",
       "       ['304912001', 0.3, 353],\n",
       "       ['304912002', 217.0, 263],\n",
       "       ['304912002', 1.61, 5],\n",
       "       ['304912002', 0.3, 353],\n",
       "       ['304912003', 223.0, 263],\n",
       "       ['304912003', 1.61, 5],\n",
       "       ['304912003', 0.3, 353],\n",
       "       ['304912004', 253.0, 263],\n",
       "       ['304912004', 1.61, 5],\n",
       "       ['304912004', 0.3, 353],\n",
       "       ['304912005', 174.0, 263],\n",
       "       ['304912005', 1.61, 5],\n",
       "       ['304912005', 0.1, 38],\n",
       "       ['304912005', 0.3, 353],\n",
       "       ['304912006', 202.0, 263],\n",
       "       ['304912006', 1.61, 5],\n",
       "       ['304912006', 0.08, 38],\n",
       "       ['304912006', 0.3, 353],\n",
       "       ['304912007', 230.0, 263],\n",
       "       ['304912007', 1.61, 5],\n",
       "       ['304912007', 0.05, 38],\n",
       "       ['304912007', 0.3, 353],\n",
       "       ['304912008', 258.0, 263],\n",
       "       ['304912008', 1.61, 5],\n",
       "       ['304912008', 0.03, 38],\n",
       "       ['304912008', 0.3, 353],\n",
       "       ['304913001', 765.0, 263],\n",
       "       ['304913001', 1.007, 5],\n",
       "       ['304913001', 0.3, 353],\n",
       "       ['304913002', 644.0, 263],\n",
       "       ['304913002', 1.272, 5],\n",
       "       ['304913002', 0.3, 353],\n",
       "       ['304913003', 557.0, 263],\n",
       "       ['304913003', 1.464, 5],\n",
       "       ['304913003', 0.3, 353],\n",
       "       ['304913004', 490.0, 263],\n",
       "       ['304913004', 1.611, 5],\n",
       "       ['304913004', 0.3, 353],\n",
       "       ['304913005', 408.0, 263],\n",
       "       ['304913005', 1.611, 5],\n",
       "       ['304913005', 0.3, 353],\n",
       "       ['304913006', 359.0, 263],\n",
       "       ['304913006', 1.611, 5],\n",
       "       ['304913006', 0.15, 353],\n",
       "       ['304913012', 644.0, 266],\n",
       "       ['304913012', 1.28, 5],\n",
       "       ['304913012', 0.3, 353],\n",
       "       ['304913013', 185.0, 263],\n",
       "       ['304913013', 0.31, 38],\n",
       "       ['304913013', 1.48, 5],\n",
       "       ['304913013', 0.3, 353],\n",
       "       ['304913014', 130.0, 263],\n",
       "       ['304913014', 0.32, 38],\n",
       "       ['304913014', 1.56, 5],\n",
       "       ['304913014', 0.3, 353],\n",
       "       ['304913015', 340.0, 263],\n",
       "       ['304913015', 0.56, 38],\n",
       "       ['304913015', 0.46, 5],\n",
       "       ['304913015', 0.3, 353],\n",
       "       ['304913016', 306.0, 263],\n",
       "       ['304913016', 0.13, 38],\n",
       "       ['304913016', 1.63, 5],\n",
       "       ['304913016', 0.3, 353],\n",
       "       ['304913017', 382.0, 263],\n",
       "       ['304913017', 0.32, 38],\n",
       "       ['304913017', 1.01, 5],\n",
       "       ['304913017', 0.3, 353],\n",
       "       ['304913018', 204.0, 263],\n",
       "       ['304913018', 0.17, 38],\n",
       "       ['304913018', 1.63, 5],\n",
       "       ['304913018', 0.3, 353],\n",
       "       ['304913019', 466.0, 263],\n",
       "       ['304913019', 0.04, 38],\n",
       "       ['304913019', 1.52, 5],\n",
       "       ['304913019', 0.3, 353],\n",
       "       ['304913020', 371.0, 263],\n",
       "       ['304913020', 0.15, 38],\n",
       "       ['304913020', 1.48, 5],\n",
       "       ['304913020', 0.3, 353],\n",
       "       ['304913021', 278.0, 263],\n",
       "       ['304913021', 0.23, 38],\n",
       "       ['304913021', 1.48, 5],\n",
       "       ['304913021', 0.3, 353],\n",
       "       ['304913022', 453.0, 263],\n",
       "       ['304913022', 0.19, 38],\n",
       "       ['304913022', 1.2, 5],\n",
       "       ['304913022', 0.3, 353],\n",
       "       ['304913023', 510.0, 263],\n",
       "       ['304913023', 0.08, 38],\n",
       "       ['304913023', 1.36, 5],\n",
       "       ['304913023', 0.3, 353],\n",
       "       ['304913024', 583.0, 263],\n",
       "       ['304913024', 0.24, 38],\n",
       "       ['304913024', 0.77, 5],\n",
       "       ['304913024', 0.3, 353],\n",
       "       ['304913025', 467.0, 263],\n",
       "       ['304913025', 0.39, 38],\n",
       "       ['304913025', 0.62, 5],\n",
       "       ['304913025', 0.3, 353],\n",
       "       ['304913026', 391.0, 263],\n",
       "       ['304913026', 0.1, 38],\n",
       "       ['304913026', 1.56, 5],\n",
       "       ['304913026', 0.3, 353],\n",
       "       ['304913027', 242.0, 263],\n",
       "       ['304913027', 0.1, 38],\n",
       "       ['304913027', 1.61, 5],\n",
       "       ['304913027', 0.3, 353],\n",
       "       ['304913028', 0.47, 38],\n",
       "       ['304913028', 1.47, 5],\n",
       "       ['304913028', 0.3, 353],\n",
       "       ['304913029', 0.4, 38],\n",
       "       ['304913029', 1.61, 5],\n",
       "       ['304913029', 0.3, 353],\n",
       "       ['304913030', 0.36, 38],\n",
       "       ['304913030', 1.61, 5],\n",
       "       ['304913030', 0.3, 353],\n",
       "       ['304913031', 0.25, 38],\n",
       "       ['304913031', 1.61, 5],\n",
       "       ['304913031', 0.3, 353],\n",
       "       ['304913071', 0.34, 38],\n",
       "       ['304913071', 1.63, 5],\n",
       "       ['304913071', 16.6, 1198],\n",
       "       ['304913071', 0.3, 353],\n",
       "       ['304913072', 224.0, 263],\n",
       "       ['304913072', 0.37, 38],\n",
       "       ['304913072', 1.18, 5],\n",
       "       ['304913072', 26.63, 47],\n",
       "       ['304913072', 0.3, 353],\n",
       "       ['304914008', 1.56, 5],\n",
       "       ['304914008', 275.0, 1085],\n",
       "       ['304914008', 530.0, 41],\n",
       "       ['304914009', 1.69, 5],\n",
       "       ['304914009', 244.0, 1085],\n",
       "       ['304914009', 468.0, 41],\n",
       "       ['304914015', 1085.0, 263],\n",
       "       ['304914015', 0.32, 6],\n",
       "       ['304914015', 1650.0, 864],\n",
       "       ['304914015', 0.4, 353],\n",
       "       ['304913007', 765.0, 263],\n",
       "       ['304913007', 1.007, 5],\n",
       "       ['304913007', 38.25, 1305],\n",
       "       ['304913007', 0.3, 353],\n",
       "       ['304913008', 644.0, 263],\n",
       "       ['304913008', 1.272, 5],\n",
       "       ['304913008', 32.2, 1305],\n",
       "       ['304913008', 0.3, 353],\n",
       "       ['304913009', 557.0, 263],\n",
       "       ['304913009', 1.464, 5],\n",
       "       ['304913009', 27.85, 1305],\n",
       "       ['304913009', 0.3, 353],\n",
       "       ['304913010', 490.0, 263],\n",
       "       ['304913010', 1.611, 5],\n",
       "       ['304913010', 24.5, 1305],\n",
       "       ['304913010', 0.3, 353],\n",
       "       ['304913011', 408.0, 263],\n",
       "       ['304913011', 1.611, 5],\n",
       "       ['304913011', 0.3, 353],\n",
       "       ['304913011', 20.4, 1305],\n",
       "       ['304916001', 312.96, 263],\n",
       "       ['304916001', 1.18, 12],\n",
       "       ['304916001', 0.4, 353],\n",
       "       ['304916002', 340.1, 263],\n",
       "       ['304916002', 1.14, 12],\n",
       "       ['304916002', 0.4, 353],\n",
       "       ['304916003', 411.48, 263],\n",
       "       ['304916003', 1.04, 12],\n",
       "       ['304916003', 0.4, 353],\n",
       "       ['304916004', 180.46, 263],\n",
       "       ['304916004', 1.13, 12],\n",
       "       ['304916004', 0.12, 38],\n",
       "       ['304916004', 0.4, 353],\n",
       "       ['304916005', 262.65, 263],\n",
       "       ['304916005', 0.99, 12],\n",
       "       ['304916005', 0.13, 38],\n",
       "       ['304916005', 0.4, 353],\n",
       "       ['304916006', 281.51, 263],\n",
       "       ['304916006', 0.94, 12],\n",
       "       ['304916006', 0.14, 38],\n",
       "       ['304916006', 0.4, 353],\n",
       "       ['304916007', 312.96, 263],\n",
       "       ['304916007', 0.92, 12],\n",
       "       ['304916007', 0.13, 38],\n",
       "       ['304916007', 0.4, 353]], dtype=object)"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d.to_numpy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "0a97b9aa-7394-4adf-8bdb-b43482cccaba",
   "metadata": {},
   "outputs": [],
   "source": [
    "did = d['RcjID']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "c7fac77b-6dbc-4aee-b4d1-abdb960f9dae",
   "metadata": {},
   "outputs": [],
   "source": [
    "e = pd.read_csv('de/xstj/JD_CaiLiaoK.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "e1c38780-88cf-4f65-9996-ae65a4d76fa0",
   "metadata": {},
   "outputs": [],
   "source": [
    "f = e[e['RcjID'].isin(did.to_list())][['CLBH', 'CLMC', 'JLDW', 'YSJG', 'RcjID']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "c9392424-45da-4ac2-9693-5372657de6a2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([['0101020201', '中砂', 't', 68.5, 5],\n",
       "       ['0101020401', '砂', 't', 59.0, 6],\n",
       "       ['0101070501', '轻质砂 JML', 'm3', 70.0, 12],\n",
       "       ['0105010201', '石灰膏', 'm3', 160.0, 38],\n",
       "       ['0105050201', '滑石粉', 'kg', 0.45, 41],\n",
       "       ['0105060402', '纸筋', 'kg', 0.5, 47],\n",
       "       ['0301010102', '水泥 32.5级', 'kg', 0.31, 263],\n",
       "       ['0301030100', '白水泥', 'kg', 0.58, 266],\n",
       "       ['0612070102', '水', 'm3', 4.1, 353],\n",
       "       ['0512010304', '钢屑', 'kg', 0.76, 864],\n",
       "       ['0604010302', '石油沥青30#', 'kg', 3.69, 1085],\n",
       "       ['0608013501', '麻刀', 'kg', 2.0, 1198],\n",
       "       ['0609100611', '防水剂', 'kg', 1.52, 1305]], dtype=object)"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f.to_numpy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "11ebe1f1-d2e4-4058-aee6-d535239b2ccf",
   "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.13.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}