{ "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": "4c8a42a1-ea31-4961-9502-a48af70cb05b", "metadata": {}, "outputs": [], "source": [ "from pymongo import MongoClient\n", "client = MongoClient()\n", "db = client[\"dinge\"]\n", "collection = db[\"de-collection\"]" ] }, { "cell_type": "code", "execution_count": 8, "id": "c76224fd-f579-4ba1-a072-f3ab0a75fbbc", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "DeleteResult({'n': 6891, 'ok': 1.0}, acknowledged=True)" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "collection.delete_many({'zhuanye': '市政'})" ] }, { "cell_type": "code", "execution_count": 9, "id": "f4a9069b-46bb-4ebc-9603-f15ac41ed812", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "DingE_Processedsz.csv\n" ] } ], "source": [ "import os\n", "dirs = os.listdir(\"de\")\n", "all = []\n", "for dir in dirs:\n", " if dir != 'sz':\n", " continue\n", " files = os.listdir(\"de/\" + dir)\n", " for entry in files:\n", " if \"DingE_Processed\" in entry:\n", " print(entry)\n", " df = pd.read_csv(\"de/\" + dir + \"/\" + entry)\n", " \n", " all.append(df)" ] }, { "cell_type": "code", "execution_count": 11, "id": "06ecc93f-621d-4d3b-a07d-df359e0fe838", "metadata": {}, "outputs": [], "source": [ "c = df.fillna(0)" ] }, { "cell_type": "code", "execution_count": 12, "id": "060bd228-1f6e-47c9-b809-a99d8cca3d34", "metadata": {}, "outputs": [], "source": [ "for i in range(len(c)):\n", " item = c.iloc[i]\n", " d = (item.to_dict())\n", " d['zhuanye'] = '市政'\n", " collection.insert_one(d)" ] }, { "cell_type": "code", "execution_count": 13, "id": "d92d1370-32f1-4e2e-a04e-2675fabc70df", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | Unnamed: 0.1 | \n", "Unnamed: 0 | \n", "id | \n", "DEBH | \n", "GCLMC | \n", "GCLGG | \n", "GCLRGR | \n", "GCLCLF | \n", "GCLJXF | \n", "GCLRGF | \n", "... | \n", "work | \n", "zhiyin | \n", "qfbz | \n", "ischaogao | \n", "zmlx | \n", "BH1 | \n", "BH2 | \n", "mcxz | \n", "DeId | \n", "parent | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "0 | \n", "0 | \n", "1 | \n", "1-1 | \n", "人工挖土方一、二类土 | \n", "0.0 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "1151.44 | \n", "... | \n", "挖土、抛土或装土、修整底边、边坡。 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "1.0 | \n", "第一册 通用项目 1 土石方工程 1.1 人工挖土方 | \n", "
| 1 | \n", "1 | \n", "1 | \n", "2 | \n", "1-2 | \n", "人工挖土方三类土 | \n", "0.0 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "1957.67 | \n", "... | \n", "挖土、抛土或装土、修整底边、边坡。 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "2.0 | \n", "第一册 通用项目 1 土石方工程 1.1 人工挖土方 | \n", "
| 2 | \n", "2 | \n", "2 | \n", "3 | \n", "1-3 | \n", "人工挖土方四类土 | \n", "0.0 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "3012.61 | \n", "... | \n", "挖土、抛土或装土、修整底边、边坡。 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "3.0 | \n", "第一册 通用项目 1 土石方工程 1.1 人工挖土方 | \n", "
| 3 | \n", "3 | \n", "3 | \n", "4 | \n", "1-4 | \n", "人工挖沟、槽土方一、二类土,深度在(m以内) 2 | \n", "0.0 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "2157.84 | \n", "... | \n", "挖土、装土或抛土于沟、槽边1m以外堆放,修整底边、边坡。 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "4.0 | \n", "第一册 通用项目 1 土石方工程 1.2 人工挖沟、槽土方 | \n", "
| 4 | \n", "4 | \n", "4 | \n", "5 | \n", "1-5 | \n", "人工挖沟、槽土方一、二类土,深度在(m以内) 4 | \n", "0.0 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "2812.37 | \n", "... | \n", "挖土、装土或抛土于沟、槽边1m以外堆放,修整底边、边坡。 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "5.0 | \n", "第一册 通用项目 1 土石方工程 1.2 人工挖沟、槽土方 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 6903 | \n", "6886 | \n", "6886 | \n", "6889 | \n", "泰补6-29 | \n", "CIPP紫光固化法 管径(mm内)DN600 | \n", "0.0 | \n", "0 | \n", "1818.48 | \n", "594.45 | \n", "63.95 | \n", "... | \n", "1.启闭井盖、强制通风、有毒气体检测、管壁清洗。\\r\\n2.设备就位、拉入底膜,拉入玻璃纤维... | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "6889.0 | \n", "泰州补充定额 泰州补充定额2021 非开挖修复定额 | \n", "
| 6904 | \n", "6887 | \n", "6887 | \n", "6890 | \n", "泰补6-30 | \n", "CIPP紫光固化法 管径(mm内)DN700 | \n", "0.0 | \n", "0 | \n", "2349.78 | \n", "636.17 | \n", "65.93 | \n", "... | \n", "1.启闭井盖、强制通风、有毒气体检测、管壁清洗。\\r\\n2.设备就位、拉入底膜,拉入玻璃纤维... | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "6890.0 | \n", "泰州补充定额 泰州补充定额2021 非开挖修复定额 | \n", "
| 6905 | \n", "6888 | \n", "6888 | \n", "6891 | \n", "泰补6-31 | \n", "CIPP紫光固化法 管径(mm内)DN800 | \n", "0.0 | \n", "0 | \n", "2701.12 | \n", "677.41 | \n", "67.91 | \n", "... | \n", "1.启闭井盖、强制通风、有毒气体检测、管壁清洗。\\r\\n2.设备就位、拉入底膜,拉入玻璃纤维... | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "6891.0 | \n", "泰州补充定额 泰州补充定额2021 非开挖修复定额 | \n", "
| 6906 | \n", "6889 | \n", "6889 | \n", "6892 | \n", "泰补6-32 | \n", "CIPP紫光固化法 管径(mm内)DN900 | \n", "0.0 | \n", "0 | \n", "3682.16 | \n", "722.20 | \n", "77.81 | \n", "... | \n", "1.启闭井盖、强制通风、有毒气体检测、管壁清洗。\\r\\n2.设备就位、拉入底膜,拉入玻璃纤维... | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "6892.0 | \n", "泰州补充定额 泰州补充定额2021 非开挖修复定额 | \n", "
| 6907 | \n", "6890 | \n", "6890 | \n", "6893 | \n", "泰补6-33 | \n", "CIPP紫光固化法 管径(mm内)DN1000 | \n", "0.0 | \n", "0 | \n", "4318.46 | \n", "791.67 | \n", "83.56 | \n", "... | \n", "1.启闭井盖、强制通风、有毒气体检测、管壁清洗。\\r\\n2.设备就位、拉入底膜,拉入玻璃纤维... | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "6893.0 | \n", "泰州补充定额 泰州补充定额2021 非开挖修复定额 | \n", "
6908 rows × 44 columns
\n", "