数据文件操作类型
TXT文档导入数据库
txt导库
import pymysql
链接数据库
abc=pymysql.connect(host=‘192.168.0.161’,port=3306,
user=‘root’,password=‘123456’,
charset=‘utf8’)
【数据的链接方式根据不同地址更换即可这是自己本地创建的mysql数据库】
aaa=abc.cursor()
aaa.execute(‘use test5;’)
with open(‘b.txt’,‘r’,encoding=‘utf-8’) as f:
dd = f.readline()
a = dd.split(’,’)
aaa.execute(‘create table biao1({} char(30),{} int,{} char(40));’.format(a[0],a[1],a[2]))
for i in range (31):
x = f.readline()
b = x.split(’,’)
aaa.execute(‘insert into biao1 values("{}",{},"{}");’.format(b[0],b[1],b[2]))
abc.commit()
aaa.execute(‘select * from biao1;’)
print(aaa.fetchall())
######################
2.数据库导入TXT文档
库导txt
import pymysql
链接数据库
abc=pymysql.connect(host=‘192.168.0.161’,port=3306,
user=‘root’,password=‘123456’,
charset=‘utf8’)
aaa=abc.cursor()
aaa.execute(‘use test6;’)
aaa.execute(‘desc biao1;’)
biaotou=aaa.fetchall()
with open(‘b.txt’,‘w’,encoding=‘utf-8’) as f:
for i in biaotou:
f.write(i[0]+’-’)
if i ==len(biaotou)-1:
f.write(biaotou[i][0])
else:
f.write(biaotou[i][0])
aaa.execute(‘select * from biao1;’)
with open(‘b.txt’,‘a’,encoding=‘utf-8’) as f:
for j in aaa.fetchall():
f.write(’\n’+’{},{},{}’.format(j[0],j[1],j[2]))
数据库写到表格
import xlwt
f=xlwt.Workbook(encoding=‘utf-8’)
sheet=f.add_sheet(‘python操作excle表格’,cell_overwrite_ok=True)
import pymysql
链接数据库
abc=pymysql.connect(host=‘192.168.0.161’,port=3306,
user=‘root’,password=‘123456’,
charset=‘utf8’)
aaa=abc.cursor()
aaa.execute(‘use test5;’)
aaa.execute(‘desc biao1;’)
biaotou=aaa.fetchall()
for j in range(3):
sheet.write(0,j,’{}’.format(biaotou[j][0]))
aaa.execute(‘select * from biao1;’)
for i in range(1,len(aaa.fetchall())):
aaa.execute(‘select * from biao1;’)
for j in aaa.fetchall():
j=list(j)
sheet.write(i,0,’{}’.format(j[0]))
sheet.write(i, 1, ‘{}’.format( j[1]))
sheet.write(i, 2, ‘{}’.format( j[2]))
f.save(‘text1.xls’)
表格到TXT中
import xlrd
f=xlrd.open_workbook(‘text.xls’)
sheet=f.sheets()[0]
with open(‘d.txt’,‘a’,encoding=‘utf-8’) as f:
a=sheet.nrows
for i in range(sheet.nrows):
f.write(’{},{},{}’.format(sheet.row_values(i)[0],
sheet.row_values(i)[1],
sheet.row_values(i)[2])+’\n’)