Skip to content
Merged
Show file tree
Hide file tree
Changes from all commits
Commits
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
11 changes: 11 additions & 0 deletions lwh/12/demo.txt
Original file line number Diff line number Diff line change
@@ -0,0 +1,11 @@
北京
程序员
公务员
领导
牛比
牛逼
你娘
你妈
love
sex
jiangge
31 changes: 31 additions & 0 deletions lwh/12/filter.py
Original file line number Diff line number Diff line change
@@ -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)
43 changes: 43 additions & 0 deletions lwh/14/SaveToExcel.py
Original file line number Diff line number Diff line change
@@ -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()
5 changes: 5 additions & 0 deletions lwh/14/demo.txt
Original file line number Diff line number Diff line change
@@ -0,0 +1,5 @@
{
"1":["张三",150,120,100],
"2":["李四",90,99,95],
"3":["王五",60,66,68]
}
Empty file added lwh/14/demo.txt~
Empty file.
5 changes: 5 additions & 0 deletions lwh/17/demo.txt
Original file line number Diff line number Diff line change
@@ -0,0 +1,5 @@
{
"1":["张三",150,120,100],
"2":["李四",90,99,95],
"3":["王五",60,66,68]
}
Binary file added lwh/17/test.xlsx
Binary file not shown.
53 changes: 53 additions & 0 deletions lwh/17/xlxs_to_xml.py
Original file line number Diff line number Diff line change
@@ -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()
Binary file added lwh/20/CallInfo.xls
Binary file not shown.
81 changes: 81 additions & 0 deletions lwh/20/callinfo.py
Original file line number Diff line number Diff line change
@@ -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.')

62 changes: 62 additions & 0 deletions lwh/20/callinfo.py~
Original file line number Diff line number Diff line change
@@ -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.')

24 changes: 24 additions & 0 deletions lwh/21/encrpyt.py
Original file line number Diff line number Diff line change
@@ -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)