Merge pull request Show-Me-the-Code#170 from lwhhhh/master

horx · horx · commit b06f19f31abe · 2016-01-30T09:04:04.000+08:00
add 17,20,21
diff --git a/lwh/12/demo.txt b/lwh/12/demo.txt
@@ -0,0 +1,11 @@
+北京
+程序员
+公务员
+领导
+牛比
+牛逼
+你娘
+你妈
+love
+sex
+jiangge
diff --git a/lwh/12/filter.py b/lwh/12/filter.py
@@ -0,0 +1,31 @@
+import re
+import string
+
+
+class Filter(object):
+
+    def __init__(self):
+        self.filtered_word_list = []
+        self.readIO()
+
+    def check(self, word_input):
+        res = word_input
+        for e in self.filtered_word_list:
+            # print(e)
+            if e in word_input:
+                res = res.replace(e, '*' * len(e))
+        return res
+
+    def readIO(self):
+        with open('demo.txt', 'r') as f:
+            s_temp = f.readline().strip()
+            while s_temp != "":
+                self.filtered_word_list.append(s_temp)
+                s_temp = f.readline().strip()
+
+if __name__ == "__main__":
+    filter_obj = Filter()
+    while True:
+        word_input = input("Enter a sentence to check >")
+        str_ans = filter_obj.check(word_input)
+        print(str_ans)
diff --git a/lwh/14/SaveToExcel.py b/lwh/14/SaveToExcel.py
@@ -0,0 +1,43 @@
+from openpyxl import Workbook
+from openpyxl import load_workbook
+
+path_save = "/home/lwh/SublimeTextProject/test.xlsx"
+path_read = "/home/lwh/SublimeTextProject/demo.txt"
+
+
+def write_test():
+    wb = Workbook()     # 1.creat a work book
+    wb_sheet0 = wb.create_sheet("student")  # 2.create a sheet in the work book
+
+    datas_str = ""
+    datas_dict = {}
+
+    with open(path_read, "r") as f:
+        lines = f.readlines()
+
+    # process the data from txt file.I make it be a dict
+    for line in lines:
+        if len(line.strip()) > 1:
+            key, value = line.split(':')
+            key = key.strip().strip("\"")
+            value = value.strip().strip(",").strip("[").strip("]")
+            value_list = value.split(",")
+            # print(len(value_list))
+            datas_dict[key] = value_list
+
+    for i in range(1, 4):       # 3.assign value to cell of the sheet
+        for j in range(1, 5):
+            cell = wb_sheet0.cell(row=i, column=j + 1)
+            cell.value = datas_dict[str(i)][j - 1]
+            # print(cell.value)
+        cell = wb_sheet0.cell(row=i, column=1)
+        cell.value = i
+    '''
+    for row in wb_sheet0.iter_rows():
+        for cell in row:
+            print(cell.value)
+    '''
+    wb.save(path_save)      # 4.save the file
+    print('success')
+
+write_test()
diff --git a/lwh/14/demo.txt b/lwh/14/demo.txt
@@ -0,0 +1,5 @@
+{
+    "1":["张三",150,120,100],
+    "2":["李四",90,99,95],
+    "3":["王五",60,66,68]
+}
diff --git a/lwh/14/demo.txt~ b/lwh/14/demo.txt~
diff --git a/lwh/17/demo.txt b/lwh/17/demo.txt
@@ -0,0 +1,5 @@
+{
+    "1":["张三",150,120,100],
+    "2":["李四",90,99,95],
+    "3":["王五",60,66,68]
+}
diff --git a/lwh/17/test.xlsx b/lwh/17/test.xlsx
diff --git a/lwh/17/xlxs_to_xml.py b/lwh/17/xlxs_to_xml.py
@@ -0,0 +1,53 @@
+from xml.etree.ElementTree import ElementTree, Element, SubElement, Comment
+from openpyxl import load_workbook
+import json
+from pprint import pprint
+
+
+class ExcelToXml(object):
+
+    def __init__(self):
+        self.path_save = '/home/lwh/SublimeTextProject/test.xml'
+        self.path_read = '/home/lwh/SublimeTextProject/test.xlsx'
+        self.excel_dict = self.get_excel_dict()
+        self.data = self.get_text(self.excel_dict)
+        self.xml_final = self.get_xml(self.data)
+        self.save_xml(self.xml_final)
+
+    def get_excel_dict(self):
+        wb = load_workbook(self.path_read)
+        wb_sheet_student = wb['student']
+        excel_dict = {}
+        for row in wb_sheet_student.iter_rows():
+            key = str(row[0].value).strip()
+            value_list = row[1:]
+            value = [ele.value for ele in value_list]
+            excel_dict[key] = str(value)
+        return excel_dict
+
+    def get_text(self, excel_dict):
+        res = '{\r\n'
+        for key, val in excel_dict.items():
+            res += ' ' + str(key) + ':' + val + '\n'
+        res += '}\n'
+        # print(res)
+        return res
+
+    def get_xml(self, data):
+        root = Element('root')
+        student = SubElement(root, 'students')
+        student.append(Comment('学生信息表 "id" : [名字, 数学, 语文, 英文]'))
+        # student.
+        print(data)
+        student.text = data
+        xml_final = ElementTree(root)
+        # print(xml_final)
+        return xml_final
+
+    def save_xml(self, xml_to_save):
+        xml_to_save.write(
+            self.path_save, encoding="us-ascii", default_namespace=None, short_empty_elements=True)
+
+
+if __name__ == '__main__':
+    excel_to_xml_obj = ExcelToXml()
diff --git a/lwh/20/CallInfo.xls b/lwh/20/CallInfo.xls
diff --git a/lwh/20/callinfo.py b/lwh/20/callinfo.py
@@ -0,0 +1,81 @@
+import xlrd
+import xlwt
+
+
+class Statistics(object):
+
+    def __init__(self, user):
+        self.path_read = '/home/lwh/SublimeTextProject/CallInfo.xls'
+        self.path_save = '/home/lwh/SublimeTextProject/CallInfo(1).xls'
+        self.user = user
+        self.work()
+
+    # change all format of time to second
+    def tran_time(self, time_str):
+        time = time_str.replace('分', '.').replace('秒', '')
+        temp = time.split('.')
+        if len(temp) == 1:      # just second
+            time = int(temp[0])
+            # print(time)
+        elif len(temp) == 2:    # minute and second
+            m = int(temp[0]) * 60
+            s = int(temp[1])
+            time = m + s
+        # print(time)
+        return time
+
+    def work(self):
+        wb = xlrd.open_workbook(self.path_read)
+        sheets_list = wb.sheet_names()
+        for sheet_name in sheets_list:
+            wb_sheet = wb.sheet_by_name(sheet_name)
+            # print(wb_sheet)
+            # print(wb_sheet.nrows)
+            # print(wb_sheet.ncols)
+            # print(wb_sheet.cell_value(3,8))
+            for i in range(1, wb_sheet.nrows):
+                row = wb_sheet.row(i)
+
+                # time
+                time_str = row[3].value
+                time = self.tran_time(time_str)
+                self.user.total_time += time
+
+                # calling info
+                in_or_out = row[4].value
+                if in_or_out == '被叫':
+                    number_in = row[5].value
+                    if number_in not in self.user.number_in_dict:
+                        self.user.number_in_dict[number_in] = 0
+                    else:
+                        self.user.number_in_dict[number_in] += 1
+                elif in_or_out == '主叫':
+                    number_out = row[5].value
+                    if number_out not in self.user.number_out_dict:
+                        self.user.number_out_dict[number_out] = 0
+                    else:
+                        self.user.number_out_dict[number_out] += 1
+            for key, val in self.user.number_in_dict.items():
+                print('in', key, val)
+            for key, val in self.user.number_out_dict.items():
+                print('out', key, val)
+        # print(self.user.total_time)
+
+
+class User():
+
+    def __init__(self, name, num):
+        self.name = name
+        self.num = num
+        self.total_time = 0
+        self.most_call_out = ''
+        self.most_call_in = ''
+        self.number_in_dict = {}
+        self.number_out_dict = {}
+
+
+if __name__ == '__main__':
+    user0 = User('lwh', '13257584928')
+    analyzer_obj0 = Statistics(user0)
+    print('success.')
+
diff --git a/lwh/20/callinfo.py~ b/lwh/20/callinfo.py~
@@ -0,0 +1,62 @@
+import xlrd
+import xlwt
+
+
+class Statistics(object):
+
+    def __init__(self, user):
+        self.path_read = '/home/lwh/SublimeTextProject/CallInfo.xls'
+        self.path_save = '/home/lwh/SublimeTextProject/CallInfo(1).xls'
+        self.user = user
+        self.work()
+
+    # change all format of time to second
+    def tran_time(self, time_str):
+        time = time_str.replace('分','.').replace('秒','')
+        temp = time.split('.')
+        if len(temp) == 1:      # just second
+            time = int(temp[0])
+            #print(time)
+        elif len(temp) == 2:    # minute and second
+            m = int(temp[0]) * 60
+            s = int(temp[1])
+            time = m + s
+        #print(time)
+        return time
+        
+
+    def work(self):
+        wb = xlrd.open_workbook(self.path_read)
+        sheets_list = wb.sheet_names()
+        for sheet_name in sheets_list:
+            wb_sheet = wb.sheet_by_name(sheet_name)
+            # print(wb_sheet)
+            # print(wb_sheet.nrows)
+            # print(wb_sheet.ncols)
+            # print(wb_sheet.cell_value(3,8))
+            for i in range(1, wb_sheet.nrows):
+                row = wb_sheet.row(i)
+                time_str = row[3].value
+                time = self.tran_time(time_str)
+                self.user.total_time += time
+                # print(each_time)
+                # self.user.total_time = row[]
+        print(self.user.total_time)
+
+class User():
+
+    def __init__(self, name, num):
+        self.name = name
+        self.num = num
+        self.total_time = 0
+        self.most_call_out = ''
+        self.most_call_in = ''
+        self.number_in_dict = ''
+        self.number_out_dict = ''
+
+
+if __name__ == '__main__':
+    user0 = User('lwh', '13257584928')
+    analyzer_obj0 = Statistics(user0)
+    print('success.')
+
diff --git a/lwh/21/encrpyt.py b/lwh/21/encrpyt.py
@@ -0,0 +1,24 @@
+from hashlib import sha256
+from hmac import HMAC
+import os
+
+
+class Encrypt(object):
+
+    def encrypt(self, password, salt=None):
+        if salt is None:
+            salt = os.urandom(8)
+        result = password.encode('utf-8')
+        for i in range(10):
+            result = HMAC(result, salt, sha256).digest()
+        return salt + result
+
+    def vaildate(self, password, hashed):
+        return hashed == self.encrypt(password, salt=hashed[:8])
+
+if __name__ == '__main__':
+    obj = Encrypt()
+    hashed = obj.encrypt('wh5622')
+    # print(bytes.decode(hashed))
+    ans = obj.vaildate('wh5622', hashed)
+    print(ans)

-Original file line number
+Diff line change
@@ @@ -0,0 +1,11 @@ @@
 +北京
 +程序员
 +公务员
 +领导
 +牛比
 +牛逼
 +你娘
 +你妈
 +love
 +sex
 +jiangge