apple710909-CSDN博客

转载统一TXT文件格式

from collections import Counter import jieba import jieba.posseg from jieba import analyse import sys #jieba.suggest_freq('乡村小规模学校', True) import re import importlib import linecache ...

2019-09-04 09:02:00 384

转载 getTable

import pymysql import xlrd import re import linecache import docx import sys import docx from docx import Document #导入库 import prettytable as pt import xlwt #连接数据库 try: ...

2019-08-19 08:52:00 337

转载根据指定id获取需要的正则内容

import pymysql import re # import wenjianduqu def getResult(x,y): sql=cursor.execute("select regular from regular where regular_id=%d"%x) regular=cursor.fetchmany(sql)#获取查询结果 Regular=eval...

2019-08-13 16:42:00 232

转载获取文件中表格并按表格形式输出

import re import linecache import docx import sys import docx from docx import Document #导入库 import prettytable as pt import xlrd import xlwt path = "D:\\文件\\政策汇\\有用\\untitled3\\docx...

2019-08-13 16:35:00 169

转载时间格式统一

def data2digit(text): if '年' in text: year = text.split('年')[0] month = text.split('年')[1].split('月')[0] day = text.split('月')[1].split('日')[0] elif '月' in text: year = 0 month = text.sp...

2019-08-07 14:52:00 122

转载时间转换（中文转数字）

#中文时间转换为****-**-**格式 def chinese2digit(text): """"中文日期转换为数字日期""" # 注意：输入格式必须是二〇一二年十月十一日年份不能写两千零一二 chinese_to_digit_table = {'零':0, 'O':0, 'Ο':0, 'О':0, '○':0, 'Ｏ': 0, '0':0, '〇': 0, '一':...

2019-08-07 14:51:00 636

转载获取docx文件中表格的内容

# -*- coding: UTF-8 -*- import re import linecache import docx import sys import docx from docx import Document #导入库 path = "D:\\文件\\政策汇\\有用\\untitled3\\docx\\printout.docx" #文件路径 ...

2019-08-07 09:22:00 653

转载从指定地址获取文件进行正则匹配，输出至指定表格

import pymysql import re conn = pymysql.connect( host='localhost', port=3306, user='root', passwd='123456', db='test', charset='utf8', ) cursor = conn.cursor() f = open('D:\\文件\\政策汇\...

2019-08-05 17:14:00 118

转载遍历ID从数据库获得需要的数据

import pymysql import re import linecache conn = pymysql.connect( host='localhost', port=3306, user='root', passwd='123456', db='test', charset='utf8', ) cursor = conn.cursor() sql1...

2019-08-02 10:31:00 590

转载 python实现将txt文件内容存入mysql数据库中

import pymysql #连接数据库 conn = pymysql.connect( host='localhost', port=3306, user='root', passwd='123456', db='test', charset='utf8', ) cursor = conn.cursor() f = open('C:\\Users\\zyl\\D...

2019-08-02 08:45:00 1619

apple710909的博客