Skip to content

Commit 1664d24

Browse files
dfkaidfkai
committed
Merge branch 'editing'
2 parents 5e57611 + 8ec7d31 commit 1664d24

File tree

4 files changed

+123
-7
lines changed

4 files changed

+123
-7
lines changed

‎013-Python 直播课/Class_01_20200324_Python安装及Jupyter使用.ipynb‎

Lines changed: 123 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -51,20 +51,66 @@
5151
"### 数据抓取\n",
5252
"\n",
5353
"你可以利用 Python 爬虫。\n",
54-
"\n",
54+
"\n"
55+
]
56+
},
57+
{
58+
"cell_type": "code",
59+
"execution_count": null,
60+
"metadata": {},
61+
"outputs": [],
62+
"source": []
63+
},
64+
{
65+
"cell_type": "markdown",
66+
"metadata": {},
67+
"source": [
5568
"### 数据清洗\n",
5669
"\n",
5770
"你可以利用 Python 处理数据，尤其是海量数据，Excel 打开都困难的。\n",
58-
"\n",
71+
"\n"
72+
]
73+
},
74+
{
75+
"cell_type": "code",
76+
"execution_count": null,
77+
"metadata": {},
78+
"outputs": [],
79+
"source": []
80+
},
81+
{
82+
"cell_type": "markdown",
83+
"metadata": {},
84+
"source": [
5985
"### 数据可视化\n",
6086
"\n",
6187
"你可以利用 Python 将数据转化成图，更加形象生动。\n",
62-
"\n",
88+
"\n"
89+
]
90+
},
91+
{
92+
"cell_type": "code",
93+
"execution_count": null,
94+
"metadata": {},
95+
"outputs": [],
96+
"source": []
97+
},
98+
{
99+
"cell_type": "markdown",
100+
"metadata": {},
101+
"source": [
63102
"### 数据挖掘\n",
64103
"\n",
65104
"你可以利用 Python 从数据中找到更深层次的信息。\n"
66105
]
67106
},
107+
{
108+
"cell_type": "code",
109+
"execution_count": null,
110+
"metadata": {},
111+
"outputs": [],
112+
"source": []
113+
},
68114
{
69115
"cell_type": "markdown",
70116
"metadata": {},
@@ -74,14 +120,84 @@
74120
},
75121
{
76122
"cell_type": "code",
77-
"execution_count": 1,
123+
"execution_count": 9,
78124
"metadata": {},
79-
"outputs": [],
125+
"outputs": [
126+
{
127+
"name": "stdout",
128+
"output_type": "stream",
129+
"text": [
130+
"A公司合同完成\n",
131+
"B公司合同完成\n",
132+
"C公司合同完成\n",
133+
"D公司合同完成\n",
134+
"E公司合同完成\n",
135+
"F公司合同完成\n",
136+
"G公司合同完成\n",
137+
"H公司合同完成\n",
138+
"I公司合同完成\n",
139+
"J公司合同完成\n",
140+
"K公司合同完成\n",
141+
"L公司合同完成\n",
142+
"M公司合同完成\n",
143+
"N公司合同完成\n",
144+
"O公司合同完成\n",
145+
"P公司合同完成\n",
146+
"Q公司合同完成\n",
147+
"R公司合同完成\n"
148+
]
149+
}
150+
],
80151
"source": [
81-
"# 创建 12 个 Excel 表\n",
152+
"from docx import Document\n",
153+
"import xlrd\n",
154+
"\n",
155+
"\n",
156+
"def change_text(old_text, new_text):\n",
157+
" all_paragraphs = document.paragraphs\n",
158+
" for paragraph in all_paragraphs:\n",
159+
" for run in paragraph.runs:\n",
160+
" run_text = run.text.replace(old_text, new_text)\n",
161+
" run.text = run_text\n",
162+
"\n",
163+
" all_tables = document.tables\n",
164+
" for table in all_tables:\n",
165+
" for row in table.rows:\n",
166+
" for cell in row.cells:\n",
167+
" cell_text = cell.text.replace(old_text, new_text)\n",
168+
" cell.text = cell_text\n",
169+
"\n",
82170
"\n",
171+
"xlsx = xlrd.open_workbook('Excel_Files/合同信息表.xlsx')\n",
172+
"sheet = xlsx.sheet_by_index(0)\n",
83173
"\n",
84-
"# 每个表 100 个 Sheet 表"
174+
"for table_row in range(1, sheet.nrows):\n",
175+
" document = Document(\"Word_Files/修改模板.docx\")\n",
176+
" for table_col in range(0, sheet.ncols):\n",
177+
" change_text(str(sheet.cell_value(0, table_col)), str(sheet.cell_value(table_row, table_col)))\n",
178+
"\n",
179+
" document.save(\"Word_Files/%s合同.docx\" % str(sheet.cell_value(table_row, 2)))\n",
180+
" print(\"%s合同完成\" % str(sheet.cell_value(table_row, 2)))"
181+
]
182+
},
183+
{
184+
"cell_type": "code",
185+
"execution_count": 10,
186+
"metadata": {},
187+
"outputs": [
188+
{
189+
"name": "stdout",
190+
"output_type": "stream",
191+
"text": [
192+
"Collecting fuzzywuzzy\n",
193+
" Downloading fuzzywuzzy-0.18.0-py2.py3-none-any.whl (18 kB)\n",
194+
"Installing collected packages: fuzzywuzzy\n",
195+
"Successfully installed fuzzywuzzy-0.18.0\n"
196+
]
197+
}
198+
],
199+
"source": [
200+
"!pip install fuzzywuzzy"
85201
]
86202
},
87203
{

‎013-Python 直播课/Excel_Files/合同信息表.xlsx‎

15.9 KB
Binary file not shown.

‎013-Python 直播课/Word_Files/修改模板.docx‎

24.6 KB
Binary file not shown.

‎013-Python 直播课/Word_Files/原始模板.docx‎

39.3 KB
Binary file not shown.

0 commit comments

Comments
 (0)