




版權(quán)說明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)
文檔簡(jiǎn)介
1、PYTHON文件讀寫與數(shù)據(jù)庫操作主講:劉軍輝2018年6月26日PYTHON文件夾操作1import osimport shutilrootdir = D:distjsdir=D:testlist = os.listdir(rootdir)for file in list: 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)PYTHON文件夾操作21.創(chuàng)
2、建單個(gè)目錄:os.mkdir(“test”)2.列出所有文件和目錄名:os.listdir()3.檢驗(yàn)給出的路徑是否是一個(gè)文件:os.path.isfile()4.檢驗(yàn)給出的路徑是否是一個(gè)目錄:os.path.isdir()5.函數(shù)用來刪除一個(gè)文件:os.remove()6.檢驗(yàn)給出的路徑是否真地存:os.path.exists()7.分離擴(kuò)展名:os.path.splitext()8.獲取路徑名:os.path.dirname()9.獲取文件名:os.path.basename()10.復(fù)制文件: shutil.copy(file1,file2)PYTHON讀寫文本文件1file_objec
3、t = open(test.txt,rU)try: for line in file_object: print(line)finally: file_object.close()PYTHON讀寫文本文件2with open(test,w) as f: for yy in dataArr: line= for ss in yy: f.write(line)PYTHON讀寫文本文件3read()一次性讀取文件的所有內(nèi)容放在一個(gè)大字符串中readline()逐行讀取文本,結(jié)果是一個(gè)listreadlines()一次性讀取文本的所有內(nèi)容,結(jié)果是一個(gè)listfile.write(str)將字符串寫入文
4、件,返回的是寫入的字符長(zhǎng)度。file.writelines(sequence)向文件寫入一個(gè)序列字符串列表,PYTHON讀寫CSV文件1Impoer 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: writer = csv.writer(csvfile) writer.writerow(index,a_name,b_name) writer.
5、writerows(0,1,3,1,2,3,2,3,4)PYTHON讀寫EXCEL文件2python讀寫excel文件要用到兩個(gè)庫:xlrd和xlwtimport xlrddata = xlrd.open_workbook(excelFile)table = data.sheets()0nrows = table.nrows ncols = table.ncols for i in xrange(0,nrows):rowValues= table.row_values(i) #逐行獲取內(nèi)容for item in rowValues:print item#table.cell(i,j).valu
6、e 可以直接讀取某個(gè)單元格的值PYTHON讀寫EXCEL文件3import xlrdexcelFile = unicode(strFile, utf8)wbk = xlwt.Workbook()sheet = wbk.add_sheet(sheet1,cell_overwrite_ok=True)headList = 標(biāo)題1,標(biāo)題2,標(biāo)題3,標(biāo)題4,總計(jì)rowIndex = 0WriteSheetRow(sheet,headList,rowIndex,True) for i in xrange(1,11): for j in xrange(1,5): sheet.write(i,j,str(i
7、*j) wbk.save(excelFile)PYTHON操作SQLITE1import sqlite3conn = sqlite3.connect(test.db)print Opened database successfully;c = conn.cursor()c.execute(CREATE TABLE COMPANY (ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS CHAR(50), SALARY REAL);)print Table created successfully;m
8、it()conn.close()PYTHON操作SQLITE2import sqlite3conn = sqlite3.connect(test.db)c = conn.cursor()print Opened database successfully;c.execute(INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, Paul, 32, California, 20000.00 );c.execute(INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (2,
9、 Allen, 25, Texas, 15000.00 );mit()print Records created successfully;conn.close()PYTHON操作SQLITE3import sqlite3conn = sqlite3.connect(test.db)c = conn.cursor()print Opened database successfully;cursor = c.execute(SELECT id, name, address, salary from COMPANY)for row in cursor: print ID = , row0 prin
10、t NAME = , row1 print ADDRESS = , row2 print SALARY = , row3, nprint Operation done successfully;conn.close()PYTHON操作SQLITE4import sqlite3conn = sqlite3.connect(test.db)c = conn.cursor()print Opened database successfully;c.execute(UPDATE COMPANY set SALARY = 25000.00 where ID=1)mit()print Total numb
11、er of rows updated :, conn.total_changescursor = conn.execute(SELECT id, name, address, salary from COMPANY)for row in cursor: print NAME = , row1 print ADDRESS = , row2print Operation done successfully;conn.close()PYTHON操作SQLITE5import sqlite3conn = sqlite3.connect(test.db)c = conn.cursor()print Op
12、ened database successfully;c.execute(DELETE from COMPANY where ID=2;)mit()print Total number of rows deleted :, conn.total_changescursor = conn.execute(SELECT id, name, address, salary from COMPANY)for row in cursor: print NAME = , row1 print ADDRESS = , row2print Operation done successfully;conn.cl
13、ose()PYTHON操作MYSQL1連接Mysql,Python3中可以用pymysql,而Python2中則使用mysqldb。import pymysql db = pymysql.connect(localhost,testuser,test123,TESTDB )cursor = db.cursor()cursor.execute(SELECT VERSION()data = cursor.fetchone()print (Database version : %s % data)db.close()PYTHON操作MYSQL2import pymysqldb = pymysql.c
14、onnect(localhost,testuser,test123,TESTDB )cursor = db.cursor()cursor.execute(DROP TABLE IF EXISTS EMPLOYEE)sql = CREATE TABLE EMPLOYEE ( FIRST_NAME CHAR(20) NOT NULL, LAST_NAME CHAR(20), AGE INT, SEX CHAR(1), INCOME FLOAT )cursor.execute(sql)db.close()PYTHON操作MYSQL3 db = pymysql.connect(localhost,te
15、stuser,test123,TESTDB ) cursor = db.cursor() sql = INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) VALUES (Mac, Mohan, 20, M, 2000) try: cursor.execute(sql) mit() except: db.rollback() PYTHON操作MYSQL4db = pymysql.connect(localhost,testuser,test123,TESTDB )cursor = db.cursor()sql = SELEC
16、T * FROM EMPLOYEE WHERE INCOME %d % (1000)try: cursor.execute(sql) results = cursor.fetchall() for row in results: fname = row0 print (fname=%s %(fname)except: print (Error: unable to fetch data)db.close()PYTHON操作MYSQL5import pymysqldb = pymysql.connect(localhost,testuser,test123,TESTDB )cursor = db.cursor()sql = UPDATE EMPLOYEE SET AGE = AGE + 1 WHERE SEX = %c % (M)try: cursor.execute(sql) mit()except: db.rollback()db.close()PYTHON操作MYSQL6import pymysqldb = pymysql.connect(localhost,testuser,test123,TESTDB )cursor = db.cursor()sql = DELETE FROM EMPLOYEE WHERE AGE %d % (20)try:
溫馨提示
- 1. 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
- 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
- 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁內(nèi)容里面會(huì)有圖紙預(yù)覽,若沒有圖紙預(yù)覽就沒有圖紙。
- 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
- 5. 人人文庫網(wǎng)僅提供信息存儲(chǔ)空間,僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
- 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請(qǐng)與我們聯(lián)系,我們立即糾正。
- 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。
最新文檔
- 城市污水管網(wǎng)建設(shè)項(xiàng)目數(shù)字化方案(范文參考)
- 2025年垃圾收轉(zhuǎn)裝備項(xiàng)目發(fā)展計(jì)劃
- 市政污水管網(wǎng)改造項(xiàng)目資金申請(qǐng)報(bào)告(范文模板)
- 健康飲食產(chǎn)業(yè)園項(xiàng)目建議書
- 香港八井加油站維護(hù)修復(fù)計(jì)劃
- 物業(yè)元旦宣傳的標(biāo)語(320句)
- 2025年跑道磨擦系數(shù)測(cè)試設(shè)備合作協(xié)議書
- 西藏拉薩中學(xué)2024-2025學(xué)年高二英語下學(xué)期第七次月考試題含解析
- 物流配送服務(wù)操作指南
- 衛(wèi)生應(yīng)急工作總結(jié)
- GB/T 25146-2010工業(yè)設(shè)備化學(xué)清洗質(zhì)量驗(yàn)收規(guī)范
- 山東中醫(yī)藥大學(xué)2020-2021學(xué)年內(nèi)科護(hù)理學(xué)試題及答案1
- 公司制成檢驗(yàn)記錄表
- DB32T 4174-2021 城市居住區(qū)和單位綠化標(biāo)準(zhǔn)
- 基本原理與性能特點(diǎn)多自由度電磁軸承課件
- Q∕SY 1836-2015 鍋爐 加熱爐燃油(氣)燃燒器及安全聯(lián)鎖保護(hù)裝置檢測(cè)規(guī)范
- 北京輸變電工程標(biāo)準(zhǔn)工藝應(yīng)用圖冊(cè)(圖文并茂)
- 儀器使用記錄表
- 石河子大學(xué)化學(xué)化工學(xué)院學(xué)院綜合測(cè)評(píng)方案-理學(xué)院
- 《汽車電工電子技術(shù)》全套教案(完整版)
- 國家職業(yè)技能標(biāo)準(zhǔn) (2021年版) 嬰幼兒發(fā)展引導(dǎo)員
評(píng)論
0/150
提交評(píng)論