![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
服务器
dong95write
行走在底层的程序猿,不定时更新(想起来更新,想不起来可能很久才会更新)
展开
-
openpyxl 写入execl
#--conding:utf-8--from openpyxl import Workbookfrom openpyxl import load_workbookimport osfilepath = '/home/public/a.xlsx'newfilepath = '/home/public/b.xlsx'output = '/home/public/output'#打开工作薄wb = load_workbook(filepath)#获取活动中的表格ws = wb.activ原创 2021-04-03 10:49:12 · 117 阅读 · 0 评论 -
python脚本备份数据库
# -*- coding:utf-8 -*-import osimport timeimport shutilimport scheduleimport datetimeDB_HOST = '127.0.0.1'DB_USER = 'root'DB_USER_PASSWD = '1234'DB_NAME = r'/home/public/wangyadong/mysql/mysqlAll.txt'BACKUP_PATH = '/home/public/wangyadong/mysql/'原创 2021-03-04 12:22:31 · 426 阅读 · 1 评论 -
python 处理200个文件的数据,存到文本内
# -*- coding:utf-8 -*-import reimport osimport pymysqlfrom datetime import datetime, date, timedeltaimport timeimport shutilimport sysimport _thread# 连接数据库#def dbh_connect(databaseName):# global cur# global conn# conn = pymysql.conne原创 2021-02-05 16:10:44 · 190 阅读 · 0 评论 -
python递归扫描关键字返回文件路径
# -*- coding:UTF-8 -*-import sysimport osreload(sys)sys.setdefaultencoding('utf-8')sys.setrecursionlimit(100000)arr = []def find_data(name,files,gPath): '''递归寻找文件的地址''' for filePath in files: fileList = {} dirList = {}原创 2021-01-20 10:21:12 · 149 阅读 · 0 评论 -
简单shell 脚本监控磁盘占用
#!/bin/bashpercent=`df -k | grep -v Filesystem| awk '{print int($5)}'`#oldIFS=$IFS#IFS=''percents=($percent)per=`df -k | grep -v Filesystem| awk '{print $6}'`pers=($per)local_host="`hostname --fqdn`"local_ip=`host $local_host 2>/dev/null | awk原创 2020-12-23 20:33:21 · 336 阅读 · 0 评论