摘要：
import pymssqlimport loggingimport mathimport datetimefrom DataCleaning.library.functions.processBar import *def list2SQL(cursor, list0, tempTableName 阅读全文
posted @ 2021-10-05 20:30
石棠
阅读(42)
评论(0)
推荐(0)
摘要：
import jsonfrom collections import namedtupledef json2Object(jsonObj): return json.loads(jsonObj, object_hook=lambda d: namedtuple('jsonMain', d.keys( 阅读全文
posted @ 2021-10-05 20:29
石棠
阅读(53)
评论(0)
推荐(0)
摘要：
# input: xlrd.book.Book# output: two sheetsdef getTwoSheets(bk): return bk.sheets()[0], bk.sheets()[1] 阅读全文
posted @ 2021-10-05 20:28
石棠
阅读(32)
评论(0)
推荐(0)
摘要：
import loggingimport os# from DataCleaning.library.functions.changeDirectory import *from DataCleaning.library.config.config import LOG_FORMAT, DATE_F 阅读全文
posted @ 2021-10-05 20:28
石棠
阅读(53)
评论(0)
推荐(0)
摘要：
# from DataCleaning.library.functions.getLatestFileName import *# getLatestFileName(keyWord, fileNames, sep = "_", comparePath = "")from DataCleaning. 阅读全文
posted @ 2021-10-05 20:27
石棠
阅读(45)
评论(0)
推荐(0)
摘要：
import pymssqlimport loggingfrom DataCleaning.library.functions.getFileNames import *from DataCleaning.library.functions.readXlsxFile import *from Dat 阅读全文
posted @ 2021-10-05 20:26
石棠
阅读(31)
评论(0)
推荐(0)
摘要：
import datetimeimport xlrddef excelDateFormatter(sh, i, j, sep = "-"): if sh.cell(i, j).ctype == 3: cell = sh.cell_value(i, j) date = datetime.datetim 阅读全文
posted @ 2021-10-05 20:25
石棠
阅读(37)
评论(0)
推荐(0)
摘要：
from DataCleaning.library.functions.floatFormatter import *from DataCleaning.library.functions.list2SQL import *from DataCleaning.library.functions.ex 阅读全文
posted @ 2021-10-05 20:25
石棠
阅读(67)
评论(0)
推荐(0)
摘要：
# load all packages with necessary functionsimport osimport sysimport datetimeimport loggingimport gcfrom DataCleaning.library.functions.initLogConfig 阅读全文
posted @ 2021-10-05 20:24
石棠
阅读(22)
评论(0)
推荐(0)
摘要：
from DataCleaning.library.functions.changeDirectory import *def createTxt(string, target, targetPath = ""): tempWD = os.getcwd() if targetPath != "": 阅读全文
posted @ 2021-10-05 20:24
石棠
阅读(27)
评论(0)
推荐(0)
浙公网安备 33010602011771号