csv文本操作
open():打开一个文件,添加的条件有文件名、读写模式、读写编码等。
创建一个文件:
def creat_write():
with open('csv.csv','w',encoding='utf-8') as file:
file.write("id,name,url,num\n")
file.write("1,百度,www.baidu.com,100\n")
file.write("1,google,www.google.com,123\n")
file.write("1,hao123,www.hao123.com,1456")
读取:
可以直接用pandas读取:
import pandas as pd
def csv_read():
i = pd.read_csv('csv.csv',sep=',')
return i
更加常见的有导入csv包读取
import csv
def read_csv():
with open('csv.csv','r',encoding='utf-8') as csvFile:
# 读取csv文件,返回的是迭代类型(list,字典能循环的类型)
read = csv.reader(csvFile)
for i in read:
print(i)