摘要:
#coding = utf-8 import xlrd import csv # excel 转换 csv w = xlrd.open_workbook("data.xls") sheet = w.sheet_by_name(w.sheet_names()[0]) data = [] for row in range(1,sheet.nrows): d = {} for c... 阅读全文
摘要:
import pickle d = dict(name='Bob', age=20, score=88) print(d) f = open('D:/untitled/1022/dump.txt', 'wb') #对象写入文件 pickle.dump(d,f) f.close() #文件读取 g = open('D:/untitled/1022/dump.txt', 'rb') e=pick... 阅读全文
摘要:
#coding=utf-8 import xlrd import json import csv #地址前用'\'转译符要加 workbook=xlrd.open_workbook('D:/untitled/1022/date.xls') #提取表格名称 sheets=workbook.sheet_names() #提取第一个表格内容 worksheet=workbook.sheet_by_n... 阅读全文
摘要:
#conding=utf-8 import logging import os,time logger=logging.getLogger(__name__) logger.setLevel(logging.INFO) formatter=logging.Formatter('%(asctime)s - %(name)s - %(levelname)s - %(message)s') ... 阅读全文
摘要:
#conding=utf-8 #火车站信息显示 import requests #xls 文件读取 火车站代码导入 import xlrd import os #表格显示信息 from prettytable import PrettyTable #打开文件 workbook = xlrd.open_workbook(r'D:\untitled\hc.xls') #读取第一个页面 she... 阅读全文
摘要:
#conding=utf-8from lxml import htmlimport requestsimport csvheader={'User-Agent':'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like 阅读全文