Python
Python小白在工作中的应用
zuopinde
这个作者很懒,什么都没留下…
展开
-
Python和Excel结合的一些应用
数据展现import xlrdimport pandas as pdimport numpy as npurl ="C:\\Users\\FCX\\Desktop\\君子供货台账 (2).xlsx"data = xlrd.open_workbook(url)sheets = ['营收指标完成情况汇总', '君子合作业务汇总表', '共管账户流水(680)', '共管账户流水(946)', 'DL20190801', 'DL20190802', 'GH20190805', 'DL2019原创 2020-07-19 11:30:26 · 911 阅读 · 0 评论 -
批量打印文件
常常遇到doc和pdf不能直接拉选右键打印#批量打印文件import win32apiimport win32printimport os#b = ['1.txt','2.txt','3.txt','4.txt']url = "F:\\0党建工作\\0每日一学\\新建文件夹 (3)"fns = []for dirs in os.walk(url): fns.append(dirs)for fn in fns: win32api.ShellExecute(0,'prin原创 2020-07-19 10:44:08 · 411 阅读 · 0 评论 -
按照序号+单位命名文件
#按照序号+单位命名文件import pandas as pdimport difflibimport sysimport osimport shutilfname1 = ['1.txt','2.txt']url = "C:\\Users\\FCX\\Desktop\\000"fname0 = os.listdir(url)for fn1 in fname1: for fn0 in fname0: if fn0 == fn1: ...原创 2020-07-19 10:43:01 · 171 阅读 · 0 评论 -
用docxtpl填充文本模板
先在word给固定区域打标签{{}}from docxtpl import DocxTemplatedocurl = "C:\\Users\\FCX\\Desktop\\0君子\\test\\附件5:君子科技公司采购清单(包含成本价).docx"savepathname = "C:\\Users\\FCX\\Desktop\\0君子行\\test\\demo.docx"a = "做啊"b="是多久"data_dic = {'ii':a,"jj":b}doc = DocxTempl原创 2020-07-19 10:41:06 · 778 阅读 · 1 评论 -
分析日志并可视化每天报错计数
# -*- coding:utf-8 -*-import refrom collections import Counterimport numpy as npimport matplotlib.pyplot as pltl = []patternForTime = r'(\d{4}[\D]\d{1,2}[\D]\d{1,2}[\D]?\d{2})' for j in range(1,30): if j <10: path = 'C:\\User...原创 2020-07-19 10:34:25 · 163 阅读 · 0 评论 -
收文文件放进文件夹
先上代码import difflibimport sysimport osimport shutilurl = "C:\\Users\\FCX\\Desktop\\000000"filenames = []for dirs in os.walk(url): filenames.append(dirs) for docname in filenames[0][2]: a = difflib.get_close_matches(docname, filena...原创 2020-07-19 10:22:11 · 85 阅读 · 0 评论 -
桌面背单词,单词图片做背景
#桌面背单词,单词图片做背景from PIL import Image,ImageFont,ImageDraw a = ['reed【【【【n.芦笛,牧笛','reef【【【【n.礁,礁石,暗礁','reel【【【【vt.卷,绕','referee【【【【n.(足球等)裁判员','refinery【【【【n.精炼厂,提炼厂','regime【【【【n.政体,政权;制度','re原创 2018-01-27 18:26:31 · 4322 阅读 · 12 评论