巩义租房网,姚晓峰,宛转蛾眉马前死
comma-separated values 有时也称为字符分隔值,因为分隔字符也可以不是逗号。以
,
分隔的文件叫csv,以\t
分隔的叫tsv
import csv data=[] with open(r'data.csv',) as csvfile: file_list = csv.reader(csvfile,'mydialect') for line in file_list: data.append(line) print(data)
如果文件是其他分隔符,如
\n
,则需要传入分隔符类型。
import csv data=[] with open(r'data.csv',) as csvfile: file_list = csv.reader(csvfile,delimiter='\t') for line in file_list: data.append(line) print(data)
import csv with open('data.csv','r',encoding='utf-8') as csvfile: reader = csv.reader(csvfile) for row in reader: # 读取出的内容是列表格式的 print(row,type(row),row[1])
import csv with open('data.csv','r',encoding='utf-8') as csvfile: reader = csv.dictreader(csvfile) for row in reader: # 读取的内容是字典格式的 print(row['last_name'])
import csv with open('data.csv','a+',encoding='utf-8',newline='') as csvfile: writer = csv.writer(csvfile) # 写入一行 writer.writerow(['1','2','3','4','5','5','6']) # 写入多行 writer.writerows([[0, 1, 3], [1, 2, 3], [2, 3, 4]])
import csv with open('data.csv','a+',encoding='utf-8',newline='') as csvfile: filename = ['first_name','last_name'] # 写入列标题 writer = csv.dictwriter(csvfile,fieldnames=filename) writer.writeheader() writer.writerow({'first_name':'wl','last_name':'wtx'}) writer.writerow({'first_name': 'lovely', 'last_name': 'spam'}) writer.writerow({'first_name': 'wonderful', 'last_name': 'spam'})
python内置json包提供了四个函数:dumps、dump、loads、load。不带s的负责文件与字典的转换。带s的负责字符串和字典的转换。
import json test_str = json.dumps({'name' : "cat"})
import json test_dict = json.loads("{'name' : "cat"}")
import json with open("test.json","w") as f: json.dump({'name' : "cat"}, f)
import json with open("test.json",'r') as f: test_dict = json.load(f)
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
python求numpy中array按列非零元素的平均值案例
网友评论