{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "d432e32a-ab45-477e-ad3d-6221a2bf0266",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f4a9069b-46bb-4ebc-9603-f15ac41ed812",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "JD_QingDanGL.csv\n",
      "JD_QingDanGL.csv\n",
      "JD_QingDanGL.csv\n",
      "JD_QingDanGL.csv\n"
     ]
    }
   ],
   "source": [
    "import os\n",
    "dirs = os.listdir(\"de\")\n",
    "all = []\n",
    "for dir in dirs:\n",
    "    files = os.listdir(\"de/\" + dir)\n",
    "    for entry in files:\n",
    "        if \"QingDan\" in entry:\n",
    "            print(entry)\n",
    "            df = pd.read_csv(\"de/\" + dir + \"/\" + entry)\n",
    "            \n",
    "            all.append(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "a2276b97-80e0-4475-9bd1-3433d8700a34",
   "metadata": {},
   "outputs": [],
   "source": [
    "allinone = pd.concat(all)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "42fb086c-907c-42f1-8fe5-bd24ee6e2286",
   "metadata": {},
   "outputs": [],
   "source": [
    "allinone.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "830903cf-4081-4858-b362-49e50c0c75a0",
   "metadata": {},
   "outputs": [],
   "source": [
    "b = allinone.drop([\"index\"], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "e42e454c-9ef4-41ec-99c0-df6814914aef",
   "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>xh</th>\n",
       "      <th>debh</th>\n",
       "      <th>gclmc</th>\n",
       "      <th>dw</th>\n",
       "      <th>gcljj</th>\n",
       "      <th>work</th>\n",
       "      <th>qdbh</th>\n",
       "      <th>lb</th>\n",
       "      <th>js</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>14SZ1-635</td>\n",
       "      <td>伐树,离地面20cm处树干直径(cm)内 φ30</td>\n",
       "      <td>10棵</td>\n",
       "      <td>247.43</td>\n",
       "      <td>砍伐树木</td>\n",
       "      <td>50101001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>14SZ1-636</td>\n",
       "      <td>伐树,离地面20cm处树干直径(cm)内 φ40</td>\n",
       "      <td>10棵</td>\n",
       "      <td>494.87</td>\n",
       "      <td>砍伐树木</td>\n",
       "      <td>50101001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>14SZ1-637</td>\n",
       "      <td>伐树,离地面20cm处树干直径(cm)内 φ50</td>\n",
       "      <td>10棵</td>\n",
       "      <td>734.56</td>\n",
       "      <td>砍伐树木</td>\n",
       "      <td>50101001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>14SZ1-638</td>\n",
       "      <td>伐树,离地面20cm处树干直径(cm)内 φ50以外</td>\n",
       "      <td>10棵</td>\n",
       "      <td>1646.97</td>\n",
       "      <td>砍伐树木</td>\n",
       "      <td>50101001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>14SZ1-639</td>\n",
       "      <td>挖树蔸,离地面20cm处树干直径(cm)内 φ30</td>\n",
       "      <td>10棵</td>\n",
       "      <td>448.47</td>\n",
       "      <td>挖树蔸</td>\n",
       "      <td>50101002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57198</th>\n",
       "      <td>16445</td>\n",
       "      <td>4-791</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 25</td>\n",
       "      <td>个</td>\n",
       "      <td>61.47</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57199</th>\n",
       "      <td>16446</td>\n",
       "      <td>4-792</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 35</td>\n",
       "      <td>个</td>\n",
       "      <td>67.75</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57200</th>\n",
       "      <td>16447</td>\n",
       "      <td>4-793</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 50</td>\n",
       "      <td>个</td>\n",
       "      <td>84.43</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57201</th>\n",
       "      <td>16448</td>\n",
       "      <td>4-794</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 70</td>\n",
       "      <td>个</td>\n",
       "      <td>98.54</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57202</th>\n",
       "      <td>16449</td>\n",
       "      <td>4-795</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 95</td>\n",
       "      <td>个</td>\n",
       "      <td>112.22</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>57203 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          xh       debh                           gclmc   dw    gcljj  \\\n",
       "0          1  14SZ1-635        伐树,离地面20cm处树干直径(cm)内 φ30  10棵   247.43   \n",
       "1          2  14SZ1-636        伐树,离地面20cm处树干直径(cm)内 φ40  10棵   494.87   \n",
       "2          3  14SZ1-637        伐树,离地面20cm处树干直径(cm)内 φ50  10棵   734.56   \n",
       "3          4  14SZ1-638      伐树,离地面20cm处树干直径(cm)内 φ50以外  10棵  1646.97   \n",
       "4          1  14SZ1-639       挖树蔸,离地面20cm处树干直径(cm)内 φ30  10棵   448.47   \n",
       "...      ...        ...                             ...  ...      ...   \n",
       "57198  16445      4-791  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 25    个    61.47   \n",
       "57199  16446      4-792  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 35    个    67.75   \n",
       "57200  16447      4-793  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 50    个    84.43   \n",
       "57201  16448      4-794  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 70    个    98.54   \n",
       "57202  16449      4-795  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 95    个   112.22   \n",
       "\n",
       "          work      qdbh   lb  js  \n",
       "0         砍伐树木  50101001  NaN   0  \n",
       "1         砍伐树木  50101001  NaN   0  \n",
       "2         砍伐树木  50101001  NaN   0  \n",
       "3         砍伐树木  50101001  NaN   0  \n",
       "4          挖树蔸  50101002  NaN   0  \n",
       "...        ...       ...  ...  ..  \n",
       "57198  电力电缆头制作  30408006  1.0   0  \n",
       "57199  电力电缆头制作  30408006  1.0   0  \n",
       "57200  电力电缆头制作  30408006  1.0   0  \n",
       "57201  电力电缆头制作  30408006  1.0   0  \n",
       "57202  电力电缆头制作  30408006  1.0   0  \n",
       "\n",
       "[57203 rows x 9 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "03dc76de-2bb1-4c52-9a38-44609fa9eeae",
   "metadata": {},
   "outputs": [],
   "source": [
    "b.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "114806cd-f71f-4d9e-8698-00ccaf6714f2",
   "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>index</th>\n",
       "      <th>xh</th>\n",
       "      <th>debh</th>\n",
       "      <th>gclmc</th>\n",
       "      <th>dw</th>\n",
       "      <th>gcljj</th>\n",
       "      <th>work</th>\n",
       "      <th>qdbh</th>\n",
       "      <th>lb</th>\n",
       "      <th>js</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>14SZ1-635</td>\n",
       "      <td>伐树,离地面20cm处树干直径(cm)内 φ30</td>\n",
       "      <td>10棵</td>\n",
       "      <td>247.43</td>\n",
       "      <td>砍伐树木</td>\n",
       "      <td>50101001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>14SZ1-636</td>\n",
       "      <td>伐树,离地面20cm处树干直径(cm)内 φ40</td>\n",
       "      <td>10棵</td>\n",
       "      <td>494.87</td>\n",
       "      <td>砍伐树木</td>\n",
       "      <td>50101001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>14SZ1-637</td>\n",
       "      <td>伐树,离地面20cm处树干直径(cm)内 φ50</td>\n",
       "      <td>10棵</td>\n",
       "      <td>734.56</td>\n",
       "      <td>砍伐树木</td>\n",
       "      <td>50101001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>14SZ1-638</td>\n",
       "      <td>伐树,离地面20cm处树干直径(cm)内 φ50以外</td>\n",
       "      <td>10棵</td>\n",
       "      <td>1646.97</td>\n",
       "      <td>砍伐树木</td>\n",
       "      <td>50101001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>14SZ1-639</td>\n",
       "      <td>挖树蔸,离地面20cm处树干直径(cm)内 φ30</td>\n",
       "      <td>10棵</td>\n",
       "      <td>448.47</td>\n",
       "      <td>挖树蔸</td>\n",
       "      <td>50101002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57198</th>\n",
       "      <td>57198</td>\n",
       "      <td>16445</td>\n",
       "      <td>4-791</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 25</td>\n",
       "      <td>个</td>\n",
       "      <td>61.47</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57199</th>\n",
       "      <td>57199</td>\n",
       "      <td>16446</td>\n",
       "      <td>4-792</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 35</td>\n",
       "      <td>个</td>\n",
       "      <td>67.75</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57200</th>\n",
       "      <td>57200</td>\n",
       "      <td>16447</td>\n",
       "      <td>4-793</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 50</td>\n",
       "      <td>个</td>\n",
       "      <td>84.43</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57201</th>\n",
       "      <td>57201</td>\n",
       "      <td>16448</td>\n",
       "      <td>4-794</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 70</td>\n",
       "      <td>个</td>\n",
       "      <td>98.54</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57202</th>\n",
       "      <td>57202</td>\n",
       "      <td>16449</td>\n",
       "      <td>4-795</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 95</td>\n",
       "      <td>个</td>\n",
       "      <td>112.22</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>57203 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       index     xh       debh                           gclmc   dw    gcljj  \\\n",
       "0          0      1  14SZ1-635        伐树,离地面20cm处树干直径(cm)内 φ30  10棵   247.43   \n",
       "1          1      2  14SZ1-636        伐树,离地面20cm处树干直径(cm)内 φ40  10棵   494.87   \n",
       "2          2      3  14SZ1-637        伐树,离地面20cm处树干直径(cm)内 φ50  10棵   734.56   \n",
       "3          3      4  14SZ1-638      伐树,离地面20cm处树干直径(cm)内 φ50以外  10棵  1646.97   \n",
       "4          4      1  14SZ1-639       挖树蔸,离地面20cm处树干直径(cm)内 φ30  10棵   448.47   \n",
       "...      ...    ...        ...                             ...  ...      ...   \n",
       "57198  57198  16445      4-791  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 25    个    61.47   \n",
       "57199  57199  16446      4-792  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 35    个    67.75   \n",
       "57200  57200  16447      4-793  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 50    个    84.43   \n",
       "57201  57201  16448      4-794  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 70    个    98.54   \n",
       "57202  57202  16449      4-795  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 95    个   112.22   \n",
       "\n",
       "          work      qdbh   lb  js  \n",
       "0         砍伐树木  50101001  NaN   0  \n",
       "1         砍伐树木  50101001  NaN   0  \n",
       "2         砍伐树木  50101001  NaN   0  \n",
       "3         砍伐树木  50101001  NaN   0  \n",
       "4          挖树蔸  50101002  NaN   0  \n",
       "...        ...       ...  ...  ..  \n",
       "57198  电力电缆头制作  30408006  1.0   0  \n",
       "57199  电力电缆头制作  30408006  1.0   0  \n",
       "57200  电力电缆头制作  30408006  1.0   0  \n",
       "57201  电力电缆头制作  30408006  1.0   0  \n",
       "57202  电力电缆头制作  30408006  1.0   0  \n",
       "\n",
       "[57203 rows x 10 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "00a5cb9c-b218-43d2-bb0c-61fb27cec7f9",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/4_/3lt_h2px0fx9q_s6shlnsnhm0000gn/T/ipykernel_8808/3488173377.py:1: DtypeWarning: Columns (23,24) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  b = pd.read_csv(\"DingEAllinone.csv\")\n"
     ]
    }
   ],
   "source": [
    "b = pd.read_csv(\"DingEAllinone.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "bd9fd80a-b48c-4a68-bc03-899b253ae440",
   "metadata": {},
   "outputs": [],
   "source": [
    "c = b.fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "d4aa19f6-9d38-4241-bb43-497017f29dba",
   "metadata": {},
   "outputs": [],
   "source": [
    "d = b.drop(['xh'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "4ae33740-78ff-4743-a771-b4e1d84989a9",
   "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>index</th>\n",
       "      <th>debh</th>\n",
       "      <th>gclmc</th>\n",
       "      <th>dw</th>\n",
       "      <th>gcljj</th>\n",
       "      <th>work</th>\n",
       "      <th>qdbh</th>\n",
       "      <th>lb</th>\n",
       "      <th>js</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4156</th>\n",
       "      <td>4156</td>\n",
       "      <td>1-98</td>\n",
       "      <td>平整场地</td>\n",
       "      <td>10m2</td>\n",
       "      <td>43.89</td>\n",
       "      <td>土方挖填</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4157</th>\n",
       "      <td>4157</td>\n",
       "      <td>1-86</td>\n",
       "      <td>人工挑抬 运距在20m以内 土</td>\n",
       "      <td>m3</td>\n",
       "      <td>16.94</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4158</th>\n",
       "      <td>4158</td>\n",
       "      <td>1-87</td>\n",
       "      <td>人工挑抬 运距在20m以内 淤泥、流砂</td>\n",
       "      <td>m3</td>\n",
       "      <td>28.49</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4159</th>\n",
       "      <td>4159</td>\n",
       "      <td>1-88</td>\n",
       "      <td>人工挑抬 运距在20m以内 石(碴)</td>\n",
       "      <td>m3</td>\n",
       "      <td>24.64</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4160</th>\n",
       "      <td>4160</td>\n",
       "      <td>1-89</td>\n",
       "      <td>人工挑抬 运距在200m以内每增加20m 土</td>\n",
       "      <td>m3</td>\n",
       "      <td>3.85</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4161</th>\n",
       "      <td>4161</td>\n",
       "      <td>1-90</td>\n",
       "      <td>人工挑抬 运距在200m以内每增加20m 淤泥、流砂</td>\n",
       "      <td>m3</td>\n",
       "      <td>5.39</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4162</th>\n",
       "      <td>4162</td>\n",
       "      <td>1-91</td>\n",
       "      <td>人工挑抬 运距在200m以内每增加20m 石(碴)</td>\n",
       "      <td>m3</td>\n",
       "      <td>4.62</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4163</th>\n",
       "      <td>4163</td>\n",
       "      <td>1-92</td>\n",
       "      <td>单(双)轮车运输 运距在50m以内 土</td>\n",
       "      <td>m3</td>\n",
       "      <td>14.63</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4164</th>\n",
       "      <td>4164</td>\n",
       "      <td>1-93</td>\n",
       "      <td>单(双)轮车运输 运距在50m以内 淤泥、流砂</td>\n",
       "      <td>m3</td>\n",
       "      <td>24.64</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4165</th>\n",
       "      <td>4165</td>\n",
       "      <td>1-94</td>\n",
       "      <td>单(双)轮车运输 运距在50m以内 石(碴)</td>\n",
       "      <td>m3</td>\n",
       "      <td>15.40</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4166</th>\n",
       "      <td>4166</td>\n",
       "      <td>1-95</td>\n",
       "      <td>单(双)轮车运输 运距在500m以内每增加50m 土</td>\n",
       "      <td>m3</td>\n",
       "      <td>3.08</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4167</th>\n",
       "      <td>4167</td>\n",
       "      <td>1-96</td>\n",
       "      <td>单(双)轮车运输 运距在500m以内每增加50m 淤泥、流砂</td>\n",
       "      <td>m3</td>\n",
       "      <td>4.62</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4168</th>\n",
       "      <td>4168</td>\n",
       "      <td>1-97</td>\n",
       "      <td>单(双)轮车运输 运距在500m以内每增加50m 石(碴)</td>\n",
       "      <td>m3</td>\n",
       "      <td>3.85</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4353</th>\n",
       "      <td>4353</td>\n",
       "      <td>1-273</td>\n",
       "      <td>平整场地(厚300mm以内) 推土机(kW以内) 75</td>\n",
       "      <td>1000m2</td>\n",
       "      <td>588.28</td>\n",
       "      <td>场地找平</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4354</th>\n",
       "      <td>4354</td>\n",
       "      <td>1-274</td>\n",
       "      <td>平整场地(厚300mm以内) 推土机(kW以内) 105</td>\n",
       "      <td>1000m2</td>\n",
       "      <td>617.06</td>\n",
       "      <td>场地找平</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4355</th>\n",
       "      <td>4355</td>\n",
       "      <td>1-275</td>\n",
       "      <td>平整场地(厚300mm以内) 推土机(kW以内) 180</td>\n",
       "      <td>1000m2</td>\n",
       "      <td>782.85</td>\n",
       "      <td>场地找平</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4356</th>\n",
       "      <td>4356</td>\n",
       "      <td>1-276</td>\n",
       "      <td>平整场地(厚300mm以内) 拖式铲运机(斗容量m3以内) 6～8</td>\n",
       "      <td>1000m2</td>\n",
       "      <td>494.25</td>\n",
       "      <td>场地找平</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4357</th>\n",
       "      <td>4357</td>\n",
       "      <td>1-277</td>\n",
       "      <td>平整场地(厚300mm以内) 拖式铲运机(斗容量m3以内) 8～10</td>\n",
       "      <td>1000m2</td>\n",
       "      <td>477.58</td>\n",
       "      <td>场地找平</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4358</th>\n",
       "      <td>4358</td>\n",
       "      <td>1-278</td>\n",
       "      <td>平整场地(厚300mm以内) 拖式铲运机(斗容量m3以内) 10～12</td>\n",
       "      <td>1000m2</td>\n",
       "      <td>464.92</td>\n",
       "      <td>场地找平</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4359</th>\n",
       "      <td>4359</td>\n",
       "      <td>1-279</td>\n",
       "      <td>平整场地(厚300mm以内) 自动平地机(kW以内) 75</td>\n",
       "      <td>1000m2</td>\n",
       "      <td>126.15</td>\n",
       "      <td>场地找平</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4360</th>\n",
       "      <td>4360</td>\n",
       "      <td>1-280</td>\n",
       "      <td>平整场地(厚300mm以内) 自动平地机(kW以内) 90</td>\n",
       "      <td>1000m2</td>\n",
       "      <td>130.66</td>\n",
       "      <td>场地找平</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4361</th>\n",
       "      <td>4361</td>\n",
       "      <td>1-281</td>\n",
       "      <td>平整场地(厚300mm以内) 自动平地机(kW以内) 120</td>\n",
       "      <td>1000m2</td>\n",
       "      <td>142.91</td>\n",
       "      <td>场地找平</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4362</th>\n",
       "      <td>4362</td>\n",
       "      <td>1-262</td>\n",
       "      <td>自卸汽车运土　运距在(km以内) 1</td>\n",
       "      <td>1000m3</td>\n",
       "      <td>7473.38</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4363</th>\n",
       "      <td>4363</td>\n",
       "      <td>1-263</td>\n",
       "      <td>自卸汽车运土　运距在(km以内) 3</td>\n",
       "      <td>1000m3</td>\n",
       "      <td>12111.29</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4364</th>\n",
       "      <td>4364</td>\n",
       "      <td>1-264</td>\n",
       "      <td>自卸汽车运土　运距在(km以内) 5</td>\n",
       "      <td>1000m3</td>\n",
       "      <td>14626.18</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4365</th>\n",
       "      <td>4365</td>\n",
       "      <td>1-265</td>\n",
       "      <td>自卸汽车运土　运距在(km以内) 7</td>\n",
       "      <td>1000m3</td>\n",
       "      <td>17622.28</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4366</th>\n",
       "      <td>4366</td>\n",
       "      <td>1-266</td>\n",
       "      <td>自卸汽车运土　运距在(km以内) 10</td>\n",
       "      <td>1000m3</td>\n",
       "      <td>21454.33</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4367</th>\n",
       "      <td>4367</td>\n",
       "      <td>1-267</td>\n",
       "      <td>自卸汽车运土　运距在(km以内) 13</td>\n",
       "      <td>1000m3</td>\n",
       "      <td>26203.69</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4368</th>\n",
       "      <td>4368</td>\n",
       "      <td>1-268</td>\n",
       "      <td>自卸汽车运土　运距在(km以内) 16</td>\n",
       "      <td>1000m3</td>\n",
       "      <td>31800.49</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4369</th>\n",
       "      <td>4369</td>\n",
       "      <td>1-269</td>\n",
       "      <td>自卸汽车运土　运距在(km以内) 20</td>\n",
       "      <td>1000m3</td>\n",
       "      <td>38406.61</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4370</th>\n",
       "      <td>4370</td>\n",
       "      <td>1-270</td>\n",
       "      <td>自卸汽车运土 运距在(km以内) 25</td>\n",
       "      <td>1000m3</td>\n",
       "      <td>46919.02</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4371</th>\n",
       "      <td>4371</td>\n",
       "      <td>1-271</td>\n",
       "      <td>自卸汽车运土 运距在(km以内) 30</td>\n",
       "      <td>1000m3</td>\n",
       "      <td>56181.56</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4372</th>\n",
       "      <td>4372</td>\n",
       "      <td>1-272</td>\n",
       "      <td>自卸汽车运土 超过30km每增加5km</td>\n",
       "      <td>1000m3</td>\n",
       "      <td>10187.82</td>\n",
       "      <td>运输</td>\n",
       "      <td>10101001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      index   debh                                gclmc      dw     gcljj  \\\n",
       "4156   4156   1-98                                 平整场地    10m2     43.89   \n",
       "4157   4157   1-86                      人工挑抬 运距在20m以内 土      m3     16.94   \n",
       "4158   4158   1-87                  人工挑抬 运距在20m以内 淤泥、流砂      m3     28.49   \n",
       "4159   4159   1-88                   人工挑抬 运距在20m以内 石(碴)      m3     24.64   \n",
       "4160   4160   1-89               人工挑抬 运距在200m以内每增加20m 土      m3      3.85   \n",
       "4161   4161   1-90           人工挑抬 运距在200m以内每增加20m 淤泥、流砂      m3      5.39   \n",
       "4162   4162   1-91            人工挑抬 运距在200m以内每增加20m 石(碴)      m3      4.62   \n",
       "4163   4163   1-92                  单(双)轮车运输 运距在50m以内 土      m3     14.63   \n",
       "4164   4164   1-93              单(双)轮车运输 运距在50m以内 淤泥、流砂      m3     24.64   \n",
       "4165   4165   1-94               单(双)轮车运输 运距在50m以内 石(碴)      m3     15.40   \n",
       "4166   4166   1-95           单(双)轮车运输 运距在500m以内每增加50m 土      m3      3.08   \n",
       "4167   4167   1-96       单(双)轮车运输 运距在500m以内每增加50m 淤泥、流砂      m3      4.62   \n",
       "4168   4168   1-97        单(双)轮车运输 运距在500m以内每增加50m 石(碴)      m3      3.85   \n",
       "4353   4353  1-273          平整场地(厚300mm以内) 推土机(kW以内) 75  1000m2    588.28   \n",
       "4354   4354  1-274         平整场地(厚300mm以内) 推土机(kW以内) 105  1000m2    617.06   \n",
       "4355   4355  1-275         平整场地(厚300mm以内) 推土机(kW以内) 180  1000m2    782.85   \n",
       "4356   4356  1-276    平整场地(厚300mm以内) 拖式铲运机(斗容量m3以内) 6～8  1000m2    494.25   \n",
       "4357   4357  1-277   平整场地(厚300mm以内) 拖式铲运机(斗容量m3以内) 8～10  1000m2    477.58   \n",
       "4358   4358  1-278  平整场地(厚300mm以内) 拖式铲运机(斗容量m3以内) 10～12  1000m2    464.92   \n",
       "4359   4359  1-279        平整场地(厚300mm以内) 自动平地机(kW以内) 75  1000m2    126.15   \n",
       "4360   4360  1-280        平整场地(厚300mm以内) 自动平地机(kW以内) 90  1000m2    130.66   \n",
       "4361   4361  1-281       平整场地(厚300mm以内) 自动平地机(kW以内) 120  1000m2    142.91   \n",
       "4362   4362  1-262                   自卸汽车运土　运距在(km以内) 1  1000m3   7473.38   \n",
       "4363   4363  1-263                   自卸汽车运土　运距在(km以内) 3  1000m3  12111.29   \n",
       "4364   4364  1-264                   自卸汽车运土　运距在(km以内) 5  1000m3  14626.18   \n",
       "4365   4365  1-265                   自卸汽车运土　运距在(km以内) 7  1000m3  17622.28   \n",
       "4366   4366  1-266                  自卸汽车运土　运距在(km以内) 10  1000m3  21454.33   \n",
       "4367   4367  1-267                  自卸汽车运土　运距在(km以内) 13  1000m3  26203.69   \n",
       "4368   4368  1-268                  自卸汽车运土　运距在(km以内) 16  1000m3  31800.49   \n",
       "4369   4369  1-269                  自卸汽车运土　运距在(km以内) 20  1000m3  38406.61   \n",
       "4370   4370  1-270                  自卸汽车运土 运距在(km以内) 25  1000m3  46919.02   \n",
       "4371   4371  1-271                  自卸汽车运土 运距在(km以内) 30  1000m3  56181.56   \n",
       "4372   4372  1-272                  自卸汽车运土 超过30km每增加5km  1000m3  10187.82   \n",
       "\n",
       "      work      qdbh   lb  js  \n",
       "4156  土方挖填  10101001  1.0   0  \n",
       "4157    运输  10101001  1.0   0  \n",
       "4158    运输  10101001  1.0   0  \n",
       "4159    运输  10101001  1.0   0  \n",
       "4160    运输  10101001  1.0   0  \n",
       "4161    运输  10101001  1.0   0  \n",
       "4162    运输  10101001  1.0   0  \n",
       "4163    运输  10101001  1.0   0  \n",
       "4164    运输  10101001  1.0   0  \n",
       "4165    运输  10101001  1.0   0  \n",
       "4166    运输  10101001  1.0   0  \n",
       "4167    运输  10101001  1.0   0  \n",
       "4168    运输  10101001  1.0   0  \n",
       "4353  场地找平  10101001  1.0   0  \n",
       "4354  场地找平  10101001  1.0   0  \n",
       "4355  场地找平  10101001  1.0   0  \n",
       "4356  场地找平  10101001  1.0   0  \n",
       "4357  场地找平  10101001  1.0   0  \n",
       "4358  场地找平  10101001  1.0   0  \n",
       "4359  场地找平  10101001  1.0   0  \n",
       "4360  场地找平  10101001  1.0   0  \n",
       "4361  场地找平  10101001  1.0   0  \n",
       "4362    运输  10101001  1.0   0  \n",
       "4363    运输  10101001  1.0   0  \n",
       "4364    运输  10101001  1.0   0  \n",
       "4365    运输  10101001  1.0   0  \n",
       "4366    运输  10101001  1.0   0  \n",
       "4367    运输  10101001  1.0   0  \n",
       "4368    运输  10101001  1.0   0  \n",
       "4369    运输  10101001  1.0   0  \n",
       "4370    运输  10101001  1.0   0  \n",
       "4371    运输  10101001  1.0   0  \n",
       "4372    运输  10101001  1.0   0  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d[d[\"qdbh\"] == 10101001]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "22f39ec2-6f9c-423d-904e-205871b52b17",
   "metadata": {},
   "outputs": [],
   "source": [
    "d.to_csv(\"QingDanAllInOne.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "cdb64245-d9da-40e3-ae70-b5a94cb7f1f8",
   "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>index</th>\n",
       "      <th>debh</th>\n",
       "      <th>gclmc</th>\n",
       "      <th>dw</th>\n",
       "      <th>gcljj</th>\n",
       "      <th>work</th>\n",
       "      <th>qdbh</th>\n",
       "      <th>lb</th>\n",
       "      <th>js</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>14SZ1-635</td>\n",
       "      <td>伐树,离地面20cm处树干直径(cm)内 φ30</td>\n",
       "      <td>10棵</td>\n",
       "      <td>247.43</td>\n",
       "      <td>砍伐树木</td>\n",
       "      <td>50101001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>14SZ1-636</td>\n",
       "      <td>伐树,离地面20cm处树干直径(cm)内 φ40</td>\n",
       "      <td>10棵</td>\n",
       "      <td>494.87</td>\n",
       "      <td>砍伐树木</td>\n",
       "      <td>50101001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>14SZ1-637</td>\n",
       "      <td>伐树,离地面20cm处树干直径(cm)内 φ50</td>\n",
       "      <td>10棵</td>\n",
       "      <td>734.56</td>\n",
       "      <td>砍伐树木</td>\n",
       "      <td>50101001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>14SZ1-638</td>\n",
       "      <td>伐树,离地面20cm处树干直径(cm)内 φ50以外</td>\n",
       "      <td>10棵</td>\n",
       "      <td>1646.97</td>\n",
       "      <td>砍伐树木</td>\n",
       "      <td>50101001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>14SZ1-639</td>\n",
       "      <td>挖树蔸,离地面20cm处树干直径(cm)内 φ30</td>\n",
       "      <td>10棵</td>\n",
       "      <td>448.47</td>\n",
       "      <td>挖树蔸</td>\n",
       "      <td>50101002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57198</th>\n",
       "      <td>57198</td>\n",
       "      <td>4-791</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 25</td>\n",
       "      <td>个</td>\n",
       "      <td>61.47</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57199</th>\n",
       "      <td>57199</td>\n",
       "      <td>4-792</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 35</td>\n",
       "      <td>个</td>\n",
       "      <td>67.75</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57200</th>\n",
       "      <td>57200</td>\n",
       "      <td>4-793</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 50</td>\n",
       "      <td>个</td>\n",
       "      <td>84.43</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57201</th>\n",
       "      <td>57201</td>\n",
       "      <td>4-794</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 70</td>\n",
       "      <td>个</td>\n",
       "      <td>98.54</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57202</th>\n",
       "      <td>57202</td>\n",
       "      <td>4-795</td>\n",
       "      <td>四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 95</td>\n",
       "      <td>个</td>\n",
       "      <td>112.22</td>\n",
       "      <td>电力电缆头制作</td>\n",
       "      <td>30408006</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>57203 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       index       debh                           gclmc   dw    gcljj  \\\n",
       "0          0  14SZ1-635        伐树,离地面20cm处树干直径(cm)内 φ30  10棵   247.43   \n",
       "1          1  14SZ1-636        伐树,离地面20cm处树干直径(cm)内 φ40  10棵   494.87   \n",
       "2          2  14SZ1-637        伐树,离地面20cm处树干直径(cm)内 φ50  10棵   734.56   \n",
       "3          3  14SZ1-638      伐树,离地面20cm处树干直径(cm)内 φ50以外  10棵  1646.97   \n",
       "4          4  14SZ1-639       挖树蔸,离地面20cm处树干直径(cm)内 φ30  10棵   448.47   \n",
       "...      ...        ...                             ...  ...      ...   \n",
       "57198  57198      4-791  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 25    个    61.47   \n",
       "57199  57199      4-792  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 35    个    67.75   \n",
       "57200  57200      4-793  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 50    个    84.43   \n",
       "57201  57201      4-794  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 70    个    98.54   \n",
       "57202  57202      4-795  四芯矿物绝缘电力电缆终端头  4芯 电缆(截面mm2) 95    个   112.22   \n",
       "\n",
       "          work      qdbh   lb  js  \n",
       "0         砍伐树木  50101001  NaN   0  \n",
       "1         砍伐树木  50101001  NaN   0  \n",
       "2         砍伐树木  50101001  NaN   0  \n",
       "3         砍伐树木  50101001  NaN   0  \n",
       "4          挖树蔸  50101002  NaN   0  \n",
       "...        ...       ...  ...  ..  \n",
       "57198  电力电缆头制作  30408006  1.0   0  \n",
       "57199  电力电缆头制作  30408006  1.0   0  \n",
       "57200  电力电缆头制作  30408006  1.0   0  \n",
       "57201  电力电缆头制作  30408006  1.0   0  \n",
       "57202  电力电缆头制作  30408006  1.0   0  \n",
       "\n",
       "[57203 rows x 9 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "4e77c76e-7855-4f25-bc0d-18ecad5c48b7",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pymongo import MongoClient"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "497d2b64-1aa8-4b06-94b1-ea96e89c658f",
   "metadata": {},
   "outputs": [],
   "source": [
    "client = MongoClient()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "e914280a-1e7a-4248-91ef-d369fc3cd555",
   "metadata": {},
   "outputs": [],
   "source": [
    "dedb = client[\"dinge\"]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "06ecc93f-621d-4d3b-a07d-df359e0fe838",
   "metadata": {},
   "outputs": [],
   "source": [
    "collection = dedb[\"de-collection\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "060bd228-1f6e-47c9-b809-a99d8cca3d34",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(len(b)):\n",
    "    item = b.iloc[i]\n",
    "    ##print(item.to_dict())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d92d1370-32f1-4e2e-a04e-2675fabc70df",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7ffb8687-7ffc-42dc-b8a1-1937ed7129a0",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b436a296-ee59-470d-8ce3-4a049dcf9401",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f0d90a94-a35a-4119-89d1-ec39a61f6d72",
   "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
}