{ "cells": [ { "cell_type": "code", "execution_count": 10, "id": "d432e32a-ab45-477e-ad3d-6221a2bf0266", "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 11, "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": 33, "id": "c76224fd-f579-4ba1-a072-f3ab0a75fbbc", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "DeleteResult({'n': 4633, 'ok': 1.0}, acknowledged=True)" ] }, "execution_count": 33, "metadata": {}, "output_type": "execute_result" } ], "source": [ "collection.delete_many({'zhuanye': '园林'})" ] }, { "cell_type": "code", "execution_count": 29, "id": "f4a9069b-46bb-4ebc-9603-f15ac41ed812", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "DingE_Processedyl.csv\n" ] } ], "source": [ "import os\n", "dirs = os.listdir(\"de\")\n", "all = []\n", "for dir in dirs:\n", " if dir != 'yl':\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": 30, "id": "06ecc93f-621d-4d3b-a07d-df359e0fe838", "metadata": {}, "outputs": [], "source": [ "c = df.fillna(0)" ] }, { "cell_type": "code", "execution_count": 34, "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": 31, "id": "d92d1370-32f1-4e2e-a04e-2675fabc70df", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Unnamed: 0.1Unnamed: 0idDEBHGCLMCGCLGGGCLRGRGCLCLFGCLJXFGCLRGF...workzhiyinqfbzischaogaozmlxBH1BH2mcxzDeIdparent
00011-1人工挖一类干土深度在2m以内0.000.000.004.88...挖土、抛土或装筐、修整底边。0.00.000.00.00.00221751.通用项目 土石方、打桩、基础垫层工程 人工土、石方 人工挖土方
11121-2人工挖二类干土深度在2m以内0.000.000.007.33...挖土、抛土或装筐、修整底边。0.00.000.00.00.0|人工挖二类干土深度在2m以内人工挖二类干土深度在2m以内人工挖二类干土深度在2m以内 ...221761.通用项目 土石方、打桩、基础垫层工程 人工土、石方 人工挖土方
22231-3人工挖三类干土深度在2m以内0.000.000.0012.62...挖土、抛土或装筐、修整底边。0.00.000.00.00.00221771.通用项目 土石方、打桩、基础垫层工程 人工土、石方 人工挖土方
33341-4人工挖四类干土深度在2m以内0.000.000.0019.13...挖土、抛土或装筐、修整底边。0.00.000.00.00.00221781.通用项目 土石方、打桩、基础垫层工程 人工土、石方 人工挖土方
44451-5人工挖一类湿土深度在2m以内0.000.000.005.29...挖土、抛土或装筐、修整底边。0.00.000.00.00.00221791.通用项目 土石方、打桩、基础垫层工程 人工土、石方 人工挖土方
..................................................................
2579258025802581泰1-补6青砖加工0.002.0847.5951.80...运输、六个面切割及打磨，20m以内堆放整齐。0.00.000.00.00.00247555.补充定额
2580258125812582SB1-1082清水墙砌筑 1/2 砖0.00477.188.68350.96...包括调制砂浆、运铺砂浆、运砌砖、立门窗框、安装术砖、垫块。0.00.000.00.00.00247565.补充定额
2581258225822583SB1-1083清水墙砌筑 1砖0.00475.6310.12316.72...包括调制砂浆、运铺砂浆、运砌砖、立门窗框、安装术砖、垫块。0.00.000.00.00.00247575.补充定额
2582258325832584SB1-1084清水墙砌筑 1砖以上0.00476.1210.66284.09...包括调制砂浆、运铺砂浆、运砌砖、立门窗框、安装术砖、垫块。0.00.000.00.00.00247585.补充定额
2583258425842585SB2-746石构件表面做旧处理0.000.000.0043.79...表面做旧、石材加工、清理废弃物等。0.00.000.00.00.00247595.补充定额
\n", "

2584 rows × 44 columns

\n", "
" ], "text/plain": [ " Unnamed: 0.1 Unnamed: 0 id DEBH GCLMC GCLGG GCLRGR \\\n", "0 0 0 1 1-1 人工挖一类干土深度在2m以内 0.0 0 \n", "1 1 1 2 1-2 人工挖二类干土深度在2m以内 0.0 0 \n", "2 2 2 3 1-3 人工挖三类干土深度在2m以内 0.0 0 \n", "3 3 3 4 1-4 人工挖四类干土深度在2m以内 0.0 0 \n", "4 4 4 5 1-5 人工挖一类湿土深度在2m以内 0.0 0 \n", "... ... ... ... ... ... ... ... \n", "2579 2580 2580 2581 泰1-补6 青砖加工 0.0 0 \n", "2580 2581 2581 2582 SB1-1082 清水墙砌筑 1/2 砖 0.0 0 \n", "2581 2582 2582 2583 SB1-1083 清水墙砌筑 1砖 0.0 0 \n", "2582 2583 2583 2584 SB1-1084 清水墙砌筑 1砖以上 0.0 0 \n", "2583 2584 2584 2585 SB2-746 石构件表面做旧处理 0.0 0 \n", "\n", " GCLCLF GCLJXF GCLRGF ... work zhiyin \\\n", "0 0.00 0.00 4.88 ... 挖土、抛土或装筐、修整底边。 0.0 \n", "1 0.00 0.00 7.33 ... 挖土、抛土或装筐、修整底边。 0.0 \n", "2 0.00 0.00 12.62 ... 挖土、抛土或装筐、修整底边。 0.0 \n", "3 0.00 0.00 19.13 ... 挖土、抛土或装筐、修整底边。 0.0 \n", "4 0.00 0.00 5.29 ... 挖土、抛土或装筐、修整底边。 0.0 \n", "... ... ... ... ... ... ... \n", "2579 2.08 47.59 51.80 ... 运输、六个面切割及打磨，20m以内堆放整齐。 0.0 \n", "2580 477.18 8.68 350.96 ... 包括调制砂浆、运铺砂浆、运砌砖、立门窗框、安装术砖、垫块。 0.0 \n", "2581 475.63 10.12 316.72 ... 包括调制砂浆、运铺砂浆、运砌砖、立门窗框、安装术砖、垫块。 0.0 \n", "2582 476.12 10.66 284.09 ... 包括调制砂浆、运铺砂浆、运砌砖、立门窗框、安装术砖、垫块。 0.0 \n", "2583 0.00 0.00 43.79 ... 表面做旧、石材加工、清理废弃物等。 0.0 \n", "\n", " qfbz ischaogao zmlx BH1 BH2 \\\n", "0 0.0 0 0.0 0.0 0.0 \n", "1 0.0 0 0.0 0.0 0.0 \n", "2 0.0 0 0.0 0.0 0.0 \n", "3 0.0 0 0.0 0.0 0.0 \n", "4 0.0 0 0.0 0.0 0.0 \n", "... ... ... ... ... ... \n", "2579 0.0 0 0.0 0.0 0.0 \n", "2580 0.0 0 0.0 0.0 0.0 \n", "2581 0.0 0 0.0 0.0 0.0 \n", "2582 0.0 0 0.0 0.0 0.0 \n", "2583 0.0 0 0.0 0.0 0.0 \n", "\n", " mcxz DeId \\\n", "0 0 22175 \n", "1 |人工挖二类干土深度在2m以内人工挖二类干土深度在2m以内人工挖二类干土深度在2m以内 ... 22176 \n", "2 0 22177 \n", "3 0 22178 \n", "4 0 22179 \n", "... ... ... \n", "2579 0 24755 \n", "2580 0 24756 \n", "2581 0 24757 \n", "2582 0 24758 \n", "2583 0 24759 \n", "\n", " parent \n", "0 1.通用项目 土石方、打桩、基础垫层工程 人工土、石方 人工挖土方 \n", "1 1.通用项目 土石方、打桩、基础垫层工程 人工土、石方 人工挖土方 \n", "2 1.通用项目 土石方、打桩、基础垫层工程 人工土、石方 人工挖土方 \n", "3 1.通用项目 土石方、打桩、基础垫层工程 人工土、石方 人工挖土方 \n", "4 1.通用项目 土石方、打桩、基础垫层工程 人工土、石方 人工挖土方 \n", "... ... \n", "2579 5.补充定额 \n", "2580 5.补充定额 \n", "2581 5.补充定额 \n", "2582 5.补充定额 \n", "2583 5.补充定额 \n", "\n", "[2584 rows x 44 columns]" ] }, "execution_count": 31, "metadata": {}, "output_type": "execute_result" } ], "source": [ "c" ] }, { "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 }