此人真菜-CSDN博客

原创 pyautogui在网页内写入excel文件内容

import pyautogui as guiimport openpyxl as xlimport time#打开excelexcel=xl.load_workbook("改自制.xlsx")sheets=excel.sheetnamessheet=excel[sheets[0]]time.sleep(2)#设置GUIgui.PAUSE=0.3gui.click(80,130)#fw=gui.getActiveWindow#fw.maximize()#判定是否需要该自制Q2判定.

2021-08-01 14:52:18 658 3

原创 pyautogui打开记事本自动输入

win10，设定延时非常重要。用f"输入\n，列表模式会导致错误。import pyautogui as gui#import time 可以辅助使用，因为pause唯一。#gui.mouseInfo()gui.PAUSE=1gui.click(139,1045)#time.sleep(2)gui.write(f'txt\n\n',0.2)fw=gui.getActiveWindow()fw.maximize()gui.click(600,600)gui.press('shiftl

2021-07-30 16:19:32 529

原创 openpyxl写入py文件

import openpyxl as xlimport pprintprint("opening")workbook=xl.load_workbook('popdata.xlsx')sheets=workbook.sheetnamessheet=workbook[sheets[0]]coutrydata={ }for row in range(2,sheet.max_row+1): state=sheet[f'B{str(row)}'].value coutry=sheet[.

2021-07-28 14:58:42 197 1

原创 complie和findall

from re import compilek=[ 'a :188-8888-9999', 'b :199-2222-0000', 'c :101-4332-6324', 'd :111-1112-1112;111-1111-1111']n_max=len(k)phone_num=compile(r'\d\d\d-\d\d\d\d-\d\d\d\d')for n in range(0,n_max): mo=phone_num.search(k[n]) .

2021-07-24 12:56:53 127

原创地震位置点图

#需要json文件import jsonimport plotly.express as pximport pandas as pdfilename1='eq_data_1_day_m1.json'#filename2='readable_eq_data.json'with open(filename1) as f1: eq_all=json.load(f1)#with open(filename2,'w') as f2: # json.dump(eq_all,f2,inden.

2021-07-24 10:53:40 119

原创 between折线图

#需cvs文件import csvimport matplotlib.pyplot as pltfrom datetime import datetimefilename='weather.csv'with open(filename) as f: rd=csv.reader(f) h_r=next(rd) tmaxs,tmins,dates=[],[],[] for row in rd: if row[8]=='': tm.

2021-07-24 10:52:04 58

原创骰子柱状图

#result.pyfrom random import randintclass Diess: """初始化""" def __init__(self): self.die=[6,6,6] self.step=0 """获得400次1-6的数值列表""" def nums(self): while True: x=randint(1,6) self.die.append(x.

2021-07-24 10:49:44 179

原创随机漫步制图

###random_walk.py文件from random import choiceclass randomwalk(): def __init__(self,point=10000): self.point=point self.xa=[0] self.ya=[0]############################################## def walk(self): while len(sel.

2021-07-24 10:47:20 57

原创字典嵌套元组来编写石头剪刀布游戏

除了if，elif，else之外的写法，阅读和编写相对简单。当然字典编写起来比较麻烦和重复，不知道有没有大神有更简单的办法。from random import choice"""石头剪刀布字典，keys为元组"""k0='恭喜你赢了！'k1='真可惜，你输了！'k2='平局！'ab={ ('石头','剪刀'):k0, ('石头','布'):k1, ('剪刀','石头'):k1, ('剪刀','布'):k0, ('布','石头'):k0...

2021-07-23 13:32:24 367 1