前言
本章主要记录下脚本,里面踩的坑也有一些
很多地方都可以优化一下
比如数据可以 直接写入excel即可,不用进行转换
我这里的话就直接复用以前的代码就先转txt再转excel了,懒得搞了
一、层级架构
二、代码
1、format_conversion
# 该类为相关文件转换类
import xlwt
class FormatConversion:
# 1、 将list对象写入到txt文件中
def list_to_txt(a):
# a = [
# {"Jodie1": "123"},
# {"Jodie2": "456"},
# {"Jodie3": "789"},
# ]
with open('1.txt', 'w') as f:
for i in range(len(a)):
for key, values in a[i].items():
print(key + "," + values + "\r")
f.write(key + "," + values + "\r")
# 2、 txt文件转excell
def txt_xls(filename, xlsname):
try:
f = open(filename, encoding='utf-8')
xls = xlwt.Workbook()
# 生成excel的方法,声明excel
sheet = xls.add_sheet('sheet', cell_overwrite_ok=True)
x = 0 # 在excel开始写的位置(y)
while True: # 循环读取文本里面的内容
line = f.readline() # 一行一行的读
if not line: # 如果没有内容,则退出循环
break
for i in range(len(line.split(','))):
item = line.split(',')[i]
# print("输出item的值", item)
sheet.write(x, i, item) # x单元格经度,i单元格纬度
x += 1 # 另起一行
f.close()
xls.save(xlsname) # 保存为xls文件
except:
raise
if __name__ == '__main__':
filename = 'export_data.txt'
xlsname = 'exp_export_data.xls'
fm = FormatConversion
fm.txt_xls(filename, xlsname)
2、check_recommend_export
校验导出数据与列表数据是否一致
import os
import time
from os import listdir
from os.path import isfile, join
from selenium import webdriver
import pandas as pd
import requests
import json
from test.format_conversion import *
headers_admin = {'content-type': 'application/json; charset=UTF-8', "zone": "1052650-recommend"}
host = "https://xxx.xxx.xxx" # 请求环境
sid = "2951D93BC7AECFB5594BAD209EA8D16B1C19CB519F91CAAA5AFAA211F823E48EFDDE250C290D3794"
# url拼接
def get_total_url(url, sid):
global host
print("url:" + host + url + "?sid=" + sid)
return (host + url + "?sid=" + sid)
# 1、导出推荐数据 -->加载到下载中心
def export_recommend_data(scene, memberId):
print("==========&#