Show-Me-the-Code · horx · Sep 18, 2017 · Sep 1, 2017
diff --git a/monkey/0008/The world's leading software development platform · GitHub.html b/monkey/0008/The world's leading software development platform · GitHub.html
diff --git a/monkey/0008/main.py b/monkey/0008/main.py
@@ -0,0 +1,27 @@
+# -*- coding:utf-8 -*-
+
+'''
+
+第 0008 题：一个HTML文件，找出里面的正文。
+
+@Author monkey
+@Date   2017-8-31
+'''
+import json
+
+from bs4 import BeautifulSoup
+
+
+def findContent():
+    path = "The world's leading software development platform · GitHub.html"
+
+    with open(path, encoding='UTF-8') as file:
+        soup = BeautifulSoup(file)
+
+    # print(soup.prettify())
+    print(soup.body)
+
+
+
+if __name__ == '__main__':
+    findContent()
diff --git a/monkey/0009/The world's leading software development platform · GitHub.html b/monkey/0009/The world's leading software development platform · GitHub.html
diff --git a/monkey/0009/main.py b/monkey/0009/main.py
@@ -0,0 +1,29 @@
+# -*- coding:utf-8 -*-
+
+'''
+
+第 0009 题：一个HTML文件，找出里面的链接。
+
+@Author monkey
+@Date   2017-8-31
+'''
+import json
+
+from bs4 import BeautifulSoup
+
+
+def findTagA():
+    path = "The world's leading software development platform · GitHub.html"
+
+    with open(path, encoding='UTF-8') as file:
+        soup = BeautifulSoup(file)
+
+    # print(soup.prettify())
+    links = []
+    for i in soup.find_all('a'):
+        links.append(i['href'])
+
+    print(links)
+
+if __name__ == '__main__':
+    findTagA()
diff --git a/monkey/0014/main.py b/monkey/0014/main.py
@@ -0,0 +1,56 @@
+# -*- coding:utf-8 -*-
+
+'''
+
+第 0014 题： 纯文本文件 student.txt为学生信息, 里面的内容（包括花括号）如下所示：
+{
+    "1":["张三",150,120,100],
+    "2":["李四",90,99,95],
+    "3":["王五",60,66,68]
+}
+请将上述内容写到 student.xls 文件中。
+
+@Author monkey
+@Date   2017-8-31
+'''
+import json
+import xlwt
+
+def getStudent():
+
+    with open('student.txt', 'r', encoding = 'UTF-8') as file:
+        text = ''
+        for line in file:
+            text = text + line
+
+        stu_json = json.loads(text, encoding = 'UTF-8')
+
+    print(stu_json)
+
+    writeInXLS(stu_json)
+
+
+def writeInXLS(dict):
+    fileName = 'student.xls'
+    # 创建 xls 文件
+    file = xlwt.Workbook(encoding = 'utf-8')
+    # 创建 表
+    sheet = file.add_sheet('student', cell_overwrite_ok=True)
+
+    row = 0
+    col = 0
+
+    for k, v in sorted(dict.items(), key=lambda d:d[0]):
+        sheet.write(row, col, k)
+        for i in v:
+            col += 1
+            sheet.write(row, col, i)
+
+        row += 1
+        col = 0
+
+    file.save(fileName)
+    print('写入成功')
+
+if __name__ == '__main__':
+    getStudent()
diff --git a/monkey/0014/student.txt b/monkey/0014/student.txt
@@ -0,0 +1,5 @@
+{
+	"1":["张三",150,120,100],
+	"2":["李四",90,99,95],
+	"3":["王五",60,66,68]
+}
diff --git a/monkey/0014/student.xls b/monkey/0014/student.xls
diff --git a/monkey/0015/city.txt b/monkey/0015/city.txt
@@ -0,0 +1,5 @@
+{
+    "1" : "上海",
+    "2" : "北京",
+    "3" : "成都"
+}
diff --git a/monkey/0015/city.xls b/monkey/0015/city.xls
diff --git a/monkey/0015/main.py b/monkey/0015/main.py
@@ -0,0 +1,54 @@
+# -*- coding:utf-8 -*-
+
+'''
+第 0015 题： 纯文本文件 city.txt为城市信息, 里面的内容（包括花括号）如下所示：
+
+{
+    "1" : "上海",
+    "2" : "北京",
+    "3" : "成都"
+}
+请将上述内容写到 city.xls 文件中，如下图所示：
+
+@Author monkey
+@Date   2017-8-31
+'''
+import json
+import xlwt
+
+def getCity():
+
+    with open('city.txt', 'r', encoding='UTF-8') as file:
+        text = ''
+        for line in file:
+            text = text + line
+
+        city_json = json.loads(text, encoding = 'UTF-8')
+        print(city_json)
+
+        writeInXLS(city_json)
+
+
+def writeInXLS(dict):
+    fileName = 'city.xls'
+
+    # 创建 文件
+    file = xlwt.Workbook()
+    # 创建 表
+    sheet = file.add_sheet('city', cell_overwrite_ok=True)
+
+    row = 0
+    col = 0
+
+    for k, v in sorted(dict.items(), key=lambda d:d[0]):
+        sheet.write(row, col, k)
+        col += 1
+        sheet.write(row, col, v)
+
+        row += 1
+        col = 0
+
+    file.save(fileName)
+
+if __name__ == '__main__':
+    getCity()
diff --git a/monkey/0016/main.py b/monkey/0016/main.py
@@ -0,0 +1,55 @@
+# -*- coding:utf-8 -*-
+
+'''
+纯文本文件 numbers.txt, 里面的内容（包括方括号）如下所示：
+
+[
+	[1, 82, 65535],
+	[20, 90, 13],
+	[26, 809, 1024]
+]
+请将上述内容写到 numbers.xls 文件中，如下图所示：
+
+@Author monkey
+@Date   2017-8-31
+'''
+import json
+import xlwt
+
+def getNumber():
+
+    with open('numbers.txt', 'r', encoding='UTF-8') as file:
+        text = ''
+        for line in file:
+            text = text + line
+
+        number_json = json.loads(text, encoding = 'UTF-8')
+        print(number_json)
+
+        writeInXLS(number_json)
+
+
+def writeInXLS(list):
+    fileName = 'numbers.xls'
+
+    # 创建 文件
+    file = xlwt.Workbook()
+    # 创建 表
+    sheet = file.add_sheet('numbers', cell_overwrite_ok=True)
+
+    row = 0
+    col = 0
+
+
+    for l in list:
+        for i in l:
+            sheet.write(row, col, i)
+            col += 1
+
+        row += 1
+        col = 0
+
+    file.save(fileName)
+
+if __name__ == '__main__':
+    getNumber()
diff --git a/monkey/0016/numbers.txt b/monkey/0016/numbers.txt
@@ -0,0 +1,5 @@
+[
+	[1, 82, 65535],
+	[20, 90, 13],
+	[26, 809, 1024]
+]
diff --git a/monkey/0016/numbers.xls b/monkey/0016/numbers.xls