with open('data.txt', 'r') as file:
    res_list = []
    lines = file.readlines()
    print('[+]去重之前一共{0}行'.format(len(lines)))
    print('[+]开始去重，请稍等.....')
    for i in lines:
        if i not in res_list:
            res_list.append(i)
    print('[+]去重后一共{0}行'.format(len(res_list)))
    print(res_list)

with open('data1.txt', 'w') as new_file:
    for j in res_list:
        new_file.write(j)

import binascii

with open('data1.txt','r') as file:
    with open('data2.txt','wb') as data:
        for i in file.readlines():
            data.write(binascii.unhexlify(i[:-1]))

hash.digest() 
#返回摘要，作为二进制数据字符串值

hash.hexdigest() 
#返回摘要，作为十六进制数据字符串值

code_str = 'etaonrhisdluygw'
code_dict = {'a':'dIW','b':'sSD','c':'adE ','d':'jVf','e':'QW8','f':'SA=','g':'jBt','h':'5RE','i':'tRQ','j':'SPA','k':'8DS','l':'XiE','m':'S8S','n':'MkF','o':'T9p','p':'PS5','q':'E/S','r':'-sd','s':'SQW','t':'obW','u':'/WS','v':'SD9','w':'cw=','x':'ASD','y':'FTa','z':'AE7'}
base_str=''
for i in code_str:
    i = code_dict[i]
    base_str += i
print(base_str)

# coding=utf-8
import xlwt
import xlrd
from xlutils.copy import copy


# 创建execl
'''
def create_execl(file_name):
    wb = xlwt.Workbook()
    ws = wb.add_sheet('Info')
    ws.write(0, 0, "1")
    ws.write(1, 0, "2")
    ws.write(2, 0, "3")
    ws.write(3, 0, "2")
    wb.save(file_name)//
'''

# 单元格上色
def color_execl(file_name):
    styleBlueBkg = xlwt.easyxf('pattern: pattern solid, fore_colour black;')  # 黑色
    rb = xlrd.open_workbook(file_name)  # 打开t.xls文件
    ro = rb.sheets()[0]  # 读取表单0
    wb = copy(rb)  # 利用xlutils.copy下的copy函数复制
    ws = wb.get_sheet(0)  # 获取表单0
    for j in  range(ro.ncols):
        for i in range(ro.nrows):  # 循环所有的行列
            result = ro.cell(i, j).value
            if result == 1:  # 判断是否等于1
                ws.write(i, j, ro.cell(i, j).value, styleBlueBkg)
    wb.save(file_name)


if __name__ == '__main__':
    file_name = 'flag.xls'
    #create_execl(file_name)
    color_execl(file_name)

def bin_to_str(s):
    return ''.join([chr(i) for i in [int(b, 2) for b in s.split(' ')]])
a = "01101100 00101100 00001100 01101100 10011100 10101100 00001100 10000110 10101100 00101100 10001100 00011100 00101100 01000110 00100110 10101100 01100110 10100110 01101100 01000110 01101100 10100110 10101100 01000110 00101100 11000110 10100110 00101100 11001100 00011100 11001100 01001100"
a = a.split(' ')
flag = ''
for i in a:
    test = i[::-1]#::-1表示将字符串倒序，因为题目提示屁股，我们可以考虑是反着来的。
    flag += bin_to_str(test)

print(flag)