把数据存储到txt
title = “hjskafsadf"
with open ("c:\\desktop\\title.txt","a+") as f:
f.write(title)
f.close()
有时需要把几个变量写入txt文件中,这时分隔符就比较重要了,可以采用tab进行分隔,因为在字符串中一般不会出现tab符号。用"\t".join将变量连接成一个字符串
aaa = "\t".join(["a","b","c","d"])
with open ("c:/you/desktop/text.txt","a+") as f:
f.write(aaa)
f.close(
把数据存储到CSV
csv是逗号分隔值的文件格式,其文件以纯文本的形式存储表格数据,csv文件的每一行都用换行符分隔
import csv
with open("test.csv","r",encoding = "utf-8") as csvfile:
csv_reader = csv_reader(csvfile)
for row in csv_reader:
print(row)
print(row[0])
把数据写入csv文件
import csv
output_list = ["1","2","3","4"]
with open("test.csv","a+",encoding = "utf-8",newline="") as csvfile:
w= csv.writer(csvfile)
w.writerrow(output_list)
#newline="" 换行
操作mysql数据库
import pymysql
#打开数据库连接
db = pymysql.connect("localhost","root","password","scraping")
#使用cursor = db.cursor()
#sql插入语句
sql = """insert into urls (url,connect) values ("www.baidu.com","hello world")"""
try:
#执行sql语句
cursor.execute(sql)
#提交到数据库执行
db.commit()
except:
#如果错误则回滚
db.rollback()
#关闭数据库连接
db.close()
db = pymysql.connect()用于创建数据库的连接,里面可以指定参数(用户,密码,主机等信息)。cursor = db.cursor()通过获取的数据库连接conn下的cursor()方法创建游标,然后,通过游标cur操作execute()方法可以写入纯sql语句,最后操作完成,关闭数据库。