电小米-CSDN博客

原创使用python的fpdf批量生成pdf文件

1、首先cmd下载fpdf包pip install fpdf2、调用fpdf包，先实现写入数据的功能from fpdf import FPDFpdf=FPDF()pdf.add_page()#新建一页pdf.set_xy(0,0)pdf.set_font('arial','B',14)#设置字体pdf.cell(60)#将定位向右移动60个单位pdf.cell(70,10,'The transcript',0,2,'C')pdf.cell(-40)#将定位向左移动40个单位pdf.ce

2021-02-08 17:29:52 3914 2

原创使用pandas按照一定判定条件分表和表

import pandas as pdimport xlwt,os,timeimport selectUsecols as suimport mergeExcel as meworkbook = xlwt.Workbook(encoding = 'ascii')worksheet = workbook.add_sheet('My Worksheet',cell_overwrite_ok=True)font = xlwt.Font() # 为样式创建字体font.name = '宋体'work

2020-12-28 11:33:52 675 2

原创 python-pandas&xlwings简单应用-20200812

import pandas as pdimport xlwings as xwzhuangtai=['正常进行']data=pd.read_excel(r'D:\cm\pycharm\nnnn.xlsx')for zhuang in zhuangtai: data_zheng=data[data['阶段状态']==zhuang] writes=pd.ExcelWriter('D:\\cm\\规范化报表\\报表\\shegncheng\\bbb.xlsx') data_zhen

2020-11-17 15:00:36 832

原创使用OS修改文件名称后缀

import osfilename=r'C:\Users\caoming\Desktop\新建文件夹\新建文本文档.txt'#确认需要改后缀的文件名ext = os.path.splitext(filename) # 将文件名路径与后缀分成两部分，文件名为ext[0]，后缀为ext[1]new_name = ext[0] + '.html' # 修改后缀为'html'os.rename(filename, new_name) # 将原先文件名改成修改完后缀的文件名...

2021-02-08 11:02:11 987

原创 pandas删选表格内某一列然后去重

import pandas as pddef hee(path,b:[int]): wb=pd.read_excel(path,usecols=b) wbb=wb.values.tolist() result=[] for bbb in wbb: result.append(bbb[0]) # print(set(result)) # bbb=pd.unique(result) bbb=list(set(result))

2020-12-28 11:35:28 277

原创批量合并文件夹内的excel文件

import osimport pandas as pdimport numpy as npdef hlo(path,path1): dir = path#设置工作路径 #新建列表，存放文件名（可以忽略，但是为了做的过程能心里有数，先放上） filename_excel = [] #新建列表，存放每个文件数据框（每一个excel读取后存放在数据框） frames = [] for root, dirs, files in os.walk(dir):#os

2020-12-28 11:34:34 567

原创使用win32com来实现outlook的自动发送

import win32com.client# 调用outlook applicationoutlook = win32com.client.Dispatch('outlook.application')# 创建一个itemmail = outlook.CreateItem(0)# 接收人mail.To = "cao@sinovoice.com.cn"# 抄送人mail.CC = "cao@sinovoice.com.cn"# 主题mail.Subject = "【售前项目进展问

2020-12-21 17:13:15 1369 1

原创预算表批量生成

# from docxtpl import DocxTemplate# data_dic={'t1':"航三",'t2':"李四"}# doc = DocxTemplate('jianhualixiang-tpl.docx')# doc.render(data_dic)# doc.save('demo.docx')import numpy as npimport pandas as pdimport math,osfrom docxtpl import DocxTemplatec

2020-11-17 16:52:48 272

原创项目计划批量生成

import numpy as npimport pandas as pdimport mathfrom docxtpl import DocxTemplatecol_order=['A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','AA','AB','AC','AD','AE','AF','AG','AH','AI','AJ','AK',.

2020-11-17 15:30:16 191

原创月度成本分摊表分表处理

import pandas as pdimport selectUsecols as suimport os,xlwt,datetime,calendar,timeimport xlsxwriterworkbook = xlwt.Workbook(encoding = 'ascii')wenjianname=r'C:\Users\caoming\Desktop\财务使用'filename='项目底表.xlsx'test1=os.path.join(wenjianname,filena

2020-11-17 15:29:19 375

原创成本工时归集表分表操作

import pandas as pdimport selectUsecols as suimport os,xlwt,datetime,calendar,timeimport xlsxwriterworkbook = xlwt.Workbook(encoding = 'ascii')wenjianname=r'C:\Users\caoming\Desktop\20200914数据处理'filename='SAMPLE061901.xlsx'test1=os.path.join(we

2020-11-17 15:28:36 295

原创 pandas&docxtpl&numpy简单应用

import numpy as npimport pandas as pdimport mathfrom docxtpl import DocxTemplatecol_order = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'AA', 'AB', 'A

2020-11-17 15:27:36 299

原创 python 使用pandas和xlwt将总表按照一定格式分成不同的分表20200927

import pandas as pdimport selectUsecols as suimport os,xlwtworkbook = xlwt.Workbook(encoding = 'ascii')worksheet = workbook.add_sheet('My Worksheet',cell_overwrite_ok=True)worksheet.col(0).width = 4638 # 设置单元格宽度worksheet.col(1).width = 4638 # 设置单元格

2020-11-17 15:23:00 221

原创 python-xlwt&pandas组合使用-20200915

import os,xlwtimport pandas as pdimport selectUsecols as suimport mergeExcel as meimport mergeEXCEL1 as meeworkbook = xlwt.Workbook(encoding = 'ascii')worksheet = workbook.add_sheet('My Worksheet',cell_overwrite_ok=True)style = xlwt.XFStyle() # 初始化

2020-11-17 15:12:51 572

原创 python-xlwings简单应用-20200814

import xlwings as xwapp = xw.App(visible = True, add_book = False)ws=app.books.open('nnnn.xlsx')wwww=ws.sheets['数据表格']rownumer=wwww.used_range.last_cell.rowb_range = wwww.range(':'.join(['A1', 'BC' +str(rownumer)]))wwww.range(b_range).api.Borders(8).

2020-11-17 15:01:43 143

原创 python基本操作-pandas-20200807

import pandas as pdzhuangtai=['正常进行']#创建列表data=pd.read_excel(r'D:\cm\pycharm\caoming.xlsx')#读取文件for zhuang in zhuangtai:#创建循环 data_zhuangtai = data[data['阶段状态'] ==zhuang]#读取文件中符合'阶段状态'的内容形成df writers=pd.ExcelWriter(r'D:\cm\pycharm\正常进行.xlsx')#创建

2020-11-17 14:15:20 108 1

weixin_49870995的博客