python文件读写与数据库操作上课讲义
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
PYTHON文件读写 与数据库操作
来自百度文库主讲：刘军辉 2018年6月26日
PYTHON文件夹操作1
import os import shutil rootdir = 'D:\\dist' jsdir="D:\\test" list = os.listdir(rootdir) for file in list:
PYTHON读写文本文件3
read()一次性读取文件的所有内容放在一个大字符串中 readline()逐行读取文本，结果是一个list readlines()一次性读取文本的所有内容，结果是一个list file.write(str)将字符串写入文件，返回的是写入的字符长度。 file.writelines(sequence)向文件写入一个序列字符串列表，
VALUES (1, 'Paul', 32, 'California', 20000.00 )"); c.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \
writer = csv.writer(csvfile) writer.writerow(["index","a_name","b_name"]) writer.writerows([[0,1,3],[1,2,3],[2,3,4]])
PYTHON读写EXCEL文件2
python读写excel文件要用到两个库：xlrd和xlwt import xlrd data = xlrd.open_workbook(excelFile) table = data.sheets()[0] nrows = table.nrows ncols = table.ncols for i in xrange(0,nrows):
PYTHON读写CSV文件1
Impoer csv csv_reader = csv.reader(open('data.file', encoding='utf-8'))
for row in csv_reader: print(row)
d= (["index","a_name","b_name"]) with open("test.csv","w") as csvfile:
PYTHON操作SQLITE2
import sqlite3 conn = sqlite3.connect('test.db') c = conn.cursor() print "Opened database successfully"; c.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \
if file.endswith('.py'): shutil.copy(os.path.join(rootdir,file),os.path.join(jsdir,file))
if file.endswith('.txt'): os.remove(os.path.join(rootdir,file))
rowValues= table.row_values(i) #逐行获取内容 for item in rowValues:
print item #table.cell(i,j).value 可以直接读取某个单元格的值
PYTHON读写EXCEL文件3
import xlrd excelFile = unicode(strFile, "utf8") wbk = xlwt.Workbook() sheet = wbk.add_sheet('sheet1',cell_overwrite_ok=True) headList = ['标题1','标题2','标题3','标题4','总计'] rowIndex = 0 WriteSheetRow(sheet,headList,rowIndex,True) for i in xrange(1,11):
for j in xrange(1,5): sheet.write(i,j,str(i*j))
wbk.save(excelFile)
PYTHON操作SQLITE1
import sqlite3 conn = sqlite3.connect('test.db') print "Opened database successfully"; c = conn.cursor() c.execute('''CREATE TABLE COMPANY
PYTHON读写文本文件1
file_object = open('test.txt','rU') try:
for line in file_object: print(line)
finally: file_object.close()
PYTHON读写文本文件2
with open(‘test','w') as f: for yy in dataArr: line="" for ss in yy: f.write(line)
(ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS CHAR(50), SALARY REAL);''') print "Table created successfully"; conn.commit() conn.close()
PYTHON文件夹操作2
1.创建单个目录：os.mkdir(“test”) 2.列出所有文件和目录名:os.listdir() 3.检验给出的路径是否是一个文件：os.path.isfile() 4.检验给出的路径是否是一个目录：os.path.isdir() 5.函数用来删除一个文件:os.remove() 6.检验给出的路径是否真地存:os.path.exists() 7..分离扩展名：os.path.splitext() 8.获取路径名：os.path.dirname() 9.获取文件名：os.path.basename() 10.复制文件： shutil.copy(file1,file2)
来自百度文库主讲：刘军辉 2018年6月26日
PYTHON文件夹操作1
import os import shutil rootdir = 'D:\\dist' jsdir="D:\\test" list = os.listdir(rootdir) for file in list:
PYTHON读写文本文件3
read()一次性读取文件的所有内容放在一个大字符串中 readline()逐行读取文本，结果是一个list readlines()一次性读取文本的所有内容，结果是一个list file.write(str)将字符串写入文件，返回的是写入的字符长度。 file.writelines(sequence)向文件写入一个序列字符串列表，
VALUES (1, 'Paul', 32, 'California', 20000.00 )"); c.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \
writer = csv.writer(csvfile) writer.writerow(["index","a_name","b_name"]) writer.writerows([[0,1,3],[1,2,3],[2,3,4]])
PYTHON读写EXCEL文件2
python读写excel文件要用到两个库：xlrd和xlwt import xlrd data = xlrd.open_workbook(excelFile) table = data.sheets()[0] nrows = table.nrows ncols = table.ncols for i in xrange(0,nrows):
PYTHON读写CSV文件1
Impoer csv csv_reader = csv.reader(open('data.file', encoding='utf-8'))
for row in csv_reader: print(row)
d= (["index","a_name","b_name"]) with open("test.csv","w") as csvfile:
PYTHON操作SQLITE2
import sqlite3 conn = sqlite3.connect('test.db') c = conn.cursor() print "Opened database successfully"; c.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \
if file.endswith('.py'): shutil.copy(os.path.join(rootdir,file),os.path.join(jsdir,file))
if file.endswith('.txt'): os.remove(os.path.join(rootdir,file))
rowValues= table.row_values(i) #逐行获取内容 for item in rowValues:
print item #table.cell(i,j).value 可以直接读取某个单元格的值
PYTHON读写EXCEL文件3
import xlrd excelFile = unicode(strFile, "utf8") wbk = xlwt.Workbook() sheet = wbk.add_sheet('sheet1',cell_overwrite_ok=True) headList = ['标题1','标题2','标题3','标题4','总计'] rowIndex = 0 WriteSheetRow(sheet,headList,rowIndex,True) for i in xrange(1,11):
for j in xrange(1,5): sheet.write(i,j,str(i*j))
wbk.save(excelFile)
PYTHON操作SQLITE1
import sqlite3 conn = sqlite3.connect('test.db') print "Opened database successfully"; c = conn.cursor() c.execute('''CREATE TABLE COMPANY
PYTHON读写文本文件1
file_object = open('test.txt','rU') try:
for line in file_object: print(line)
finally: file_object.close()
PYTHON读写文本文件2
with open(‘test','w') as f: for yy in dataArr: line="" for ss in yy: f.write(line)
(ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS CHAR(50), SALARY REAL);''') print "Table created successfully"; conn.commit() conn.close()
PYTHON文件夹操作2
1.创建单个目录：os.mkdir(“test”) 2.列出所有文件和目录名:os.listdir() 3.检验给出的路径是否是一个文件：os.path.isfile() 4.检验给出的路径是否是一个目录：os.path.isdir() 5.函数用来删除一个文件:os.remove() 6.检验给出的路径是否真地存:os.path.exists() 7..分离扩展名：os.path.splitext() 8.获取路径名：os.path.dirname() 9.获取文件名：os.path.basename() 10.复制文件： shutil.copy(file1,file2)