qq_31228567的博客

读取配置文件方法import configparserimport osdef get_ini_value(key,value): config=configparser.ConfigParser() path=os.path.abspath(os.path.dirname(os.getcwd())) + "\conf\conf.ini" config.read(path, encoding='utf-8') try: return config[k

打印九九乘法表for i in range(1,10): for j in range(1,i+1): print(i,'*',j,'=',i*j,end='\t') # print('{}x{}={}\t'.format(j, i, i * j), end='') print("")

import smtplibfrom email.header import Headerfrom email.mime.text import MIMETextsmtoserver='.com'user='@.com'password=''reciver=''mail_title='nihao你好'f = open('allure-report/index.html', 'rb') # HTML文件默认和当前文件在同一路径下，若不在同一路径下，需要指定要发送的HTML文件的路径ma

安装报错pip install pymssql： ERROR: No matching distribution found for setuptools>=54.0

test_str = "张是s s4 444，"kong = 0 # 空格数量han = 0 # 汉字数量zi = 0 # 字母数量shuzi = 0 # 数字qita = 0for i in test_str: if i.isspace(): kong += 1 elif '\u4e00' <= i <= '\u9fff': han += 1 elif i.isdigit(): shuzi += 1

有几个注意的点，excel里面的数据要用双引号因为：1、get请求传params需要是dict EXCEL里面的数据拿到的是str,所有要转成dictjson.loads(data)可以将str转成dict 前提是数据里面键值对要用双引号2、post请求传data需要是str,所以直接拿就好不用转，假如要把dictr转成str,用到的是json.dumps(data)import requestsimport jsonimport xlrdimport xlsxwriter as xls

有的时候定位元素，反复检查写的代码没问题啊，但是就是定位不到，后来发现是页面没加载到，设置隐式等待时间就解决了。driver.implicitly_wait(5)

import base64import xlrdimport xlwtpath=r"C:\Users\Desktop\用户.xlsx"path1=r"C:\Users\Desktop\yonghu.xls"#获取base64码def base(name): a=base64.b64encode(name.encode("utf-8")) return str(a,"utf-8")base("1")def readEcl(path): book=xlrd.ope

dict1={"a":1,"b":2,'a':4}#键值对set1={"a",'b','a'}#不可重复tuple1=('a','b','c')#不可变list1=['a','b','c','a']#可重复，可变print(dict1)print(set1)print(tuple1)print(list1)运行结果：{‘b’: 2, ‘a’: 4}{‘b’, ‘a’}(‘a’, ‘b’, ‘c’)[‘a’, ‘b’, ‘c’, ‘a’]dict：字典 {}set:集合 {}t

import xlrdfrom docx import Documentimport docx#文档路径path_word = r"C:\Users\Desktop\test.docx"path_txt = r"C:\Users\Desktop\test.txt"path_excel=r"C:\Users\Desktop\test.xlsx"#todo 读取docx#获取文档对象 以下两种写法都可以file=docx.Document(path_word)file=Document(p

读取txt 报错，加上encoding='utf-8’就可以解决了#todo 读取txtwith open(path_txt,encoding='utf-8') as a: print("a.read()>>>>>>>>>>",a.read())

read_txt.pyfrom flask import Flask, request, render_templateread_txt = Flask(__name__)@read_txt.route('/signin', methods=['get','POST'])def signin(): path = r"C:\Users\Desktop\text.txt" data = "" with open(path, encoding='utf-8') as filen

import xlsxwriterimport randomimport gcfrom datetime import datetimeC:\Users\测试数据_105万.xlsx"kaoshengnum=1060000#创建目标excel文档xl=xlsxwriter.Workbook(path)#todo 创建sheet1考生测试信息sheet_ceshi=xl.add_worksheet("信息")#选择题数量xuanze_end=5#填空题数量tiankong_en

直接上效果图import matplotlib.pyplot as pltimport numpy as npdef auto_text(rects): for rect in rects: ax.text(rect.get_x()+0.15, rect.get_height(), rect.get_height(), ha='left', va='bottom')fig, ax = plt.subplots()#设置字体，避免汉字乱码plt.rcParams[

创建上10万的测试数据，并写入EXCEL，这里的创建数据是不重复的英文组合，代码可能有点搓，好歹实现了import xlsxwriterall=[]le=100000all.clear()for i in range(97,123):if (len(all) < le):all.append(chr(i))print(chr(i))for j in range(97,123):if(len(all)<le):all.append(chr(i)+chr(j))print(c

import xlrdimport xlsxwriter#todo 读取excel的值 计算后出结果 最后创建一个新的excel 并将结果写入excelpath=r"E:\autoproject\selenium\FreeTme.xlsx"pathheji=r"E:\autoproject\selenium\tiaoxiuhour.xlsx"def count(path): data = xlrd.open_workbook(path) sheet = data.shee

目标创建一个90W行，43列的测试数据。重点用到gc.collect() 进行垃圾回收，如果不用这个方法会导致电脑的内存和磁盘占用到100%，整个电脑卡住，程序运行不成功import xlsxwriterimport randomimport gcfrom datetime import datetime#所有大写字母# for i in range(65,91):# print(chr(i))# #所有小写字母# for i in range(97,123):#